Practice

Hands-on lessons on the features real Postgres has beyond standard SQL - JSONB, arrays, RETURNING, upsert, CTEs, window functions, and recursive queries - against a real Postgres running in your browser.

Lessons

1. JSONB: read fields out of a JSON column
2. JSONB: filter rows with @>
3. Arrays: a column that holds a list
4. RETURNING: get the row back from an INSERT
5. UUID primary keys with gen_random_uuid()
6. Upsert: ON CONFLICT DO UPDATE
7. Fix the bug: Postgres's strict GROUP BY
8. CTEs: naming a step with WITH
9. Chaining CTEs
10. Window functions: RANK with PARTITION BY
11. LAG: comparing to the previous row
12. Recursive CTEs (capstone)