Skip to content

Course outline

Fifteen practical chapters, starting from zero and progressing to workplace and interview-level SQL. Chapter 1 needs no account; from Chapter 2 on, an email saves your progress. All fifteen are free.

The essentials — chapters 1 to 10

Everything you need to pull real answers out of a real database.

  1. 1SELECT queries 101
  2. 2Queries with constraints
  3. 3Constraints on text
  4. 4Filtering and sorting results
  5. 5Multi-table queries with JOINs
  6. 6OUTER JOINs and NULLs
  7. 7Queries with expressions
  8. 8Aggregates, GROUP BY and HAVING
  9. 9Order of execution
  10. 10Changing data and schema

Going further — chapters 11 to 15

The parts that come up in interviews and in real work.

  1. 11Window functions: ranking
  2. 12Window functions: running totals and frames
  3. 13Window functions: comparing across rows
  4. 14EXISTS, NOT EXISTS and correlated subqueries
  5. 15Indexes and reading a query plan
Start chapter 1 — free