SQL & Relational Databases
Go from your first SELECT to production-grade schema design, transactions, indexing, and query optimisation across PostgreSQL, MySQL, and SQLite.
Make this roadmap your plan
Sign in to save your routine, streaks, notes, and progress across devices.
SQL Foundations
The relational model and the core of every query: SELECT, filtering, and sorting.
The Relational Model
beginner45mSELECT, WHERE & ORDER BY
beginner1h 30mFiltering & Pattern Matching
beginner1hWorking with Multiple Tables
Joins, set operations, subqueries, and CTEs — combining data across relations.
Joins
intermediate2hSet Operations
intermediate45mSubqueries & CTEs
intermediate2hAggregation & Analytics
Summarise data with grouping, and analyse it with window functions.
Grouping & Aggregates
intermediate1h 30mWindow Functions
advanced2hData Modeling & Schema Design
Types, constraints, normalization, and ER modeling — designing a schema that stays correct.
Data Types & Constraints
beginner1h 15mNormalization
advanced2hER Modeling
intermediate1h 15mModifying Data & DDL
Writing data, defining schema objects, and encapsulating logic in views, procedures, and triggers.
INSERT, UPDATE, DELETE
beginner1hDDL & Views
intermediate1h 15mStored Procedures & Triggers
advanced1h 30mTransactions & Concurrency
ACID guarantees, isolation levels, locking, and MVCC — correctness under concurrent access.
Transactions & ACID
intermediate1h 15mIsolation, Locking & MVCC
advanced2hPerformance & Production
Indexing, query plans, optimisation, security, and the features you reach for in real systems.