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

  1. Joins, set operations and NULL logic 1 tests · 14 questions
  2. Aggregation, GROUP BY and HAVING 1 tests · 12 questions
  3. Window functions 1 tests · 12 questions
  4. CTEs, subqueries and lateral 1 tests · 12 questions
  5. Indexes and query planning 1 tests · 13 questions
  6. Transactions, MVCC and locking 1 tests · 12 questions
  7. jsonb, UPSERT, partitions and maintenance 1 tests · 14 questions
  8. 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

and 26 more sources

Start SQL/PostgreSQL for free

Free, with tests and doomscrolling-style videos. All you need is your Google account.

Report a Bug

Please review the form.

Max 5MB. Supported formats: PNG, JPG, GIF, WebP.