The SQL & Databases roadmap

Every SQL & Databases lesson we teach, laid out as one path. Each station is a stage; tap any lesson to open it. Stations turn teal as you finish them.

Legend:Lesson stageStage completeTap a lesson to open it

Relational Concepts & Basics

Relational Databases vs NoSQL

RDBMS Engines (Postgres, MySQL)

Tables, Rows, & Columns

Data Types (INT, VARCHAR, BOOLEAN)

Basic & Filtering Queries

Writing SELECT Statements

Filtering Data (WHERE, LIKE)

Sorting & Limiting (ORDER BY, LIMIT)

Handling Null Values

Aggregation & Grouping

Aggregate Functions (COUNT, SUM)

Grouping Data (GROUP BY)

Filtering Groups (HAVING)

Unique Records (DISTINCT)

Relational Data & Joins

Primary & Foreign Keys

Table Constraints (UNIQUE, NOT NULL)

INNER JOIN

LEFT, RIGHT, & FULL OUTER JOIN

Schema, Mutations & Transactions

Schema Design (CREATE, ALTER TABLE)

Data Mutations (INSERT, UPDATE, DELETE)

Transactions & ACID Properties

Database Views

Advanced Queries & Optimization

Subqueries & CTEs (WITH)

Window Functions

Database Indexing

Execution Plans (EXPLAIN ANALYZE)

Modern Database Ecosystem

ORMs & Query Builders (Prisma, Drizzle)

Schema Migrations

Serverless DBs (Neon, Supabase)

NoSQL & Vector Databases