For working with data yourself
5 chapters · 10 lessonsAbout 1.5 h
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
The introductory course taught you to read a database with SQL. Now you shape one.
Every lesson starts from a situation you will meet at work: sales by month, customers who never ordered, month-over-month change. 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 give the queries you use a name.
5 chapters · 10 lessons
Join thousands of developers who've mastered the terminal. Your first lesson awaits.
Get Started →