SQL & Databases
Go from your first SELECT to window functions, then learn to design schemas that stay correct and fast — indexes, query plans and transactions included. Examples use PostgreSQL.
- 13 lessons
- 3 stages
- 12 concept notes
Also part of Backend with Go, Backend with Node.js, AI Engineer, Python, System Design and Rust — progress here counts there too.
Your progress
0 / 13
required steps
Not started In progress Done Optional Pick one Embedded roadmap
- 01
Querying
Ask questions of your data.
- 02
Advanced SQL
Express complex questions in a single query.
- 03
Design & performance
Build schemas that stay correct and fast.
- 09Schema design & normalizationModelling entities and relationships.
- 10Constraints & data integrityPrimary, foreign, unique and check constraints.
- 11IndexesB-trees, composite indexes and when not to index.
- 12Reading query plansEXPLAIN ANALYZE and finding slow spots.
- 13Transactions & isolationACID, isolation levels and locking.
- You made it.