For working with data yourself
5 chapters · 10 lessons
Go from reading a database to shaping it. Build the queries day-to-day analysis needs, then create tables, indexes, and views of your own.
This course continues from SQL Introduction
You could read the database after the introduction. Now you shape it.
Every lesson starts from a situation you will meet at work: sales by month, customers who never ordered, this month against last. Solving it is what makes the new syntax necessary.
The database is a simulation checked byte for byte against real PostgreSQL 17, down to the query planner. When you add an index, it speeds things up (or does not) exactly as the real thing would.
CASE, dates, subqueries, CTEs, and window functions: the shapes real analysis is made of.
Types, constraints, and foreign keys keep bad data out from the start.
Read a query plan and see for yourself whether an index helped.
Beyond filter, summarize, and join: build the queries you will actually be asked for every day.
Group by month, rank rows, compare with the previous period. The everyday shapes of analysis, written by you.
Constraints, indexes, views. Build tables that cannot break, make them fast, and pin down the queries that matter.
5 chapters · 10 lessons
Join thousands of developers who've mastered the terminal. Your first lesson awaits.
Get Started →