Software and technology · Data engineering and analytics
Advanced SQL and PostgreSQL
Master advanced SQL and PostgreSQL specifics: deep joins, window functions, CTEs, indexing, query planning, transactions, MVCC and jsonb, for data engineering and analytics.
- Free
- Tests that teach
- Doomscrolling-style videos
100% free course. You learn with practice tests and short vertical doomscrolling-style videos.
- Sections
- 8
- Tests
- 8
- Questions
- 101
Truly free
No card, no expiring trial and no locked content: the whole course is yours.
Tests that teach
Every question explains why the answer is right and reviews your mistakes until you master them.
Doomscrolling-style videos
Short vertical videos explain each topic before its questions: you swipe and you learn.
What you will learn
- Joins, set operations and NULL logic 1 tests · 14 questions
- Aggregation, GROUP BY and HAVING 1 tests · 12 questions
- Window functions 1 tests · 12 questions
- CTEs, subqueries and lateral 1 tests · 12 questions
- Indexes and query planning 1 tests · 13 questions
- Transactions, MVCC and locking 1 tests · 12 questions
- jsonb, UPSERT, partitions and maintenance 1 tests · 14 questions
- Common mistakes 1 tests · 12 questions
This is what a test looks like
Pick an answer to try it.
Tienes `clientes` (10 filas) y `pedidos`. Tres clientes no tienen ningún pedido. ¿Qué devuelve `SELECT c.id FROM clientes c LEFT JOIN pedidos p ON p.cliente_id = c.id`?
Correct! Inside the course every question comes with its explanation. Not that one. Inside the course every question explains why.
Based on expert sources
- The SQL Language — SQL Syntax — Lexical Structure (operator precedence) — The PostgreSQL Global Development Group (2025)
- The SQL Language — SQL Syntax — Value Expressions (aggregate expressions, window function calls, scalar subqueries) — The PostgreSQL Global Development Group (2025)
- The SQL Language — Queries — Table Expressions (joins, GROUP BY, HAVING, GROUPING SETS, LATERAL) — The PostgreSQL Global Development Group (2025)
- Functions and Operators — Subquery Expressions (IN, NOT IN, EXISTS, ANY/SOME, ALL) — The PostgreSQL Global Development Group (2025)
- The SQL Language — Queries — Combining Queries (UNION, INTERSECT, EXCEPT) — The PostgreSQL Global Development Group (2025)
and 26 more sources
Start SQL/PostgreSQL for free
Free, with tests and doomscrolling-style videos. All you need is your Google account.