← Back to the catalogue

Level 1 · Enrolled

SQLite + Python

Syllabus · 11 units · ~1 month

Every unit this programme teaches, in the order it is taught. Headlines only — the material itself opens once you are enrolled.

1. Unit 1 What is SQLite
2. Unit 2 Creating Tables & Types
3. Unit 3 Primary & Foreign Keys
4. Unit 4 Relational Design
5. Unit 5 CRUD: Insert & Select
6. Unit 6 CRUD: Update & Delete
7. Unit 7 Joins & Aggregation
8. Unit 8 Indexes & Query Plans
9. Unit 9 Python sqlite3 Basics
10. Unit 10 Transactions & Context Managers
11. Unit 11 Capstone: a CLI Task Tracker