This is a SQL language course for the Swiftener SQL Playground (sql.js in the browser). Each exercise creates its own Kenya tables — do not rely on the sample bookstore already in the playground. Python sqlite3 belongs in Learn SQLite.
Goal
Finish every chapter by running the copy-paste scripts. The last chapter is a three-table kiosk ledger.
How to take the course
- Keep this tutorial tab and the SQL Playground side by side.
- Wait until SQLite is ready.
- Copy an exercise, paste it as the whole editor, then press Ctrl+Enter (or Cmd+Enter).
- Result tables appear under the editor. Each script starts with
DROP/CREATE/INSERT.
What this playground can and cannot do
- Can: SQLite SQL, result tables, Reset DB, CSV attach, local drafts.
- Cannot: a server Postgres, Python
sqlite3(that is Learn SQLite), or the bookstore seed as your lesson data.
Sample files
sales.csv— Nairobi kiosk rows