← All lessons

Learn SQLite

How this course works, what the workbench can do, and the chapter list.

This is a SQLite course for the Swiftener SQLite editor. You already know Python from Introduction to Python. Here you store kiosk rows in a database file in the browser.

Language syntax belongs in Introduction to Python. Scripts and tests belong in Introduction to Software Engineering with Python. This course stays on sqlite3.

Goal

Finish every chapter by running the copy-paste blocks in the workbench. The last chapter is a kiosk ledger you can reuse.

How to take the course

  1. Keep this tutorial tab and the SQLite workbench side by side.
  2. Wait until the workbench status says Python is ready.
  3. Copy an exercise, paste it as the whole editor, run it, then read the printed rows. Each shaded block is a complete script.
  4. When a chapter asks for a file, download it from the banner, then click Add files.

What this editor can and cannot do

  • Can: stdlib sqlite3, print, CSV / SQL uploads, kiosk.db writes, downloads.
  • Cannot: a server Postgres, input(), or fetching URLs.
  • Always print(...) query results.

Sample files

  • kiosk.sql — CREATE + INSERT for cities
  • sales.csv — city_id, units, price
  • cities.csv — id, name

Chapter list