SQL curriculum

Joins, aggregation, window functions on a live SQLite database.

0 / 18 lessons completed

Beginner

Start here — the syntax and mental models everything else builds on.

5 min

Read columns out of a table and shape the output.

0 / 1 done

14 min

WHERE, ORDER BY, LIMIT and the NULL rules that trip people up.

0 / 2 done

8 min

COUNT, SUM, AVG, GROUP BY and HAVING.

0 / 1 done

Combine data from several places and reshape it into answers.

15 min

Inner, left and self joins across related tables.

0 / 2 done

18 min

Nest one query inside another, then name the steps with WITH.

0 / 2 done

25 min

Date arithmetic, string functions and CASE expressions.

0 / 3 done

The techniques that show up in real interviews and real pipelines.

22 min

Running totals, rankings and per-group analytics without collapsing rows.

0 / 2 done

31 min

Cohorts, retention, funnels and month-over-month growth.

0 / 3 done

17 min

Indexes, query plans and the rewrites that make slow queries fast.

0 / 2 done