Overview
Your complete guide to Databases
Four lessons on one coffee shop: the four SQL commands, joining tables, designing the database and normalising it, then connecting Python to it safely. Every query runs on a real SQLite inside the lesson.
Each part opens with an animation, then what you need before you start, then the idea with code you run, then a step-by-step and a worked example. Read the parts in order, as each builds on the last.
Each part ends with myth vs reality, a multiple-choice question, cards that flip when tapped, and "check your understanding" questions with hidden answers. Use them before you say "got it".
Do not leave a part before its exercise tests pass. Reading alone proves nothing; the exercise does.
Pick a topic
A look at Databases
You start with one table you add to, read, update and delete from, then split the data across tables and join them, then learn why you split it that way through normalisation, and finally write a Python program that talks to the database.
| Part | Topic | You learn |
|---|---|---|
| 1 | SQL, CRUD Operations | INSERT, SELECT, UPDATE, DELETE and grouping |
| 2 | SQL, Joins & Relationships | Foreign keys, INNER and LEFT JOIN, subqueries |
| 3 | SQL: Database Design & Normalization | The three normal forms, constraints and ON DELETE |
| 4 | Python & Databases | The driver and commit, safe queries, an ORM |
| 5 | NoSQL: documents and key-value | NoSQL families, document design, MongoDB and Redis |
Done with this lesson?
Sign in to save your progress.