Skip to content

Curriculum / SQL

SQL.

Four keywords get you surprisingly far. This track is about asking better questions, not memorising every join type in existence.

status
Outlined, not written
file
lesson-01.sql
first project
One query, one answer

Why this one

Almost every application you’ll ever build has a database behind it.

It’s also the rare skill that makes you useful to people who don’t write code at all.

Honest status

Planned. The sample database exists; the lessons don’t.

What it looks like

example.sqldraft snippet
1select step, count(*) as done
2from lessons
3where finished = true
4group by step;

The first eight lessons

outline · will change
  1. 01select, from — and a table to poke at
  2. 02where, and being specific
  3. 03order by, limit
  4. 04count and group by
  5. 05Joins, drawn before they’re typed
  6. 06Nulls, and why your numbers are wrong
  7. 07Writing data, carefully
  8. 08Answering a real question end to end

Project at the end

One query, one answer

You’ll be given a small messy database and a question a manager would actually ask, and you’ll answer it in a single query you understand line by line.

Want SQL sooner?

Join the waitlist and vote for it on the curriculum page. We do actually read the tally.

Join the waitlist