Advanced SQL
Everything past SELECT: correlated subqueries, CTEs and recursion, window functions, materialized views, JSONB, indexes and query plans you can read, MVCC, the write ahead log, and triggers. All on real PostgreSQL.
Every lesson runs real code in your browser, checked the moment you submit. No installing anything, no setup, no waiting.
Start Advanced SQL freeWhat this course covers
- Subqueries: Scalar, Row and Correlated
- EXISTS, IN, ANY and ALL
- Common Table Expressions with WITH
- Recursive CTEs: Trees and Org Charts
- Window Functions and the Frame
- RANK, DENSE_RANK and ROW_NUMBER
- LAG, LEAD and Running Totals
- Views
- Materialized Views
- CASE, COALESCE and FILTER
- UNION, INTERSECT and EXCEPT
- JSONB: Documents Inside PostgreSQL
- How an Index Really Works
- Composite, Partial and Covering Indexes
- Reading a Real Query Plan
- Query Optimization in Practice
- Transactions and ACID in Depth
- Isolation Levels and the Anomalies They Prevent
- Concurrency Control: Locking versus MVCC
- Crash Recovery and the Write Ahead Log
- Functions and Triggers
- SQL Dialects, Side by Side
Other courses
Learn to think like a problem-solver before you write a single line of code. Break big …
Your first Python course, no experience needed. Learn variables, loops, functions, and …
Level up your Python with comprehensions, lambdas, error handling, files, modules, and …
Master OOP in Python: classes, objects, inheritance, polymorphism, encapsulation, abstr…
Go deeper in Python: decorators, generators, type hints, regex, JSON, SQLite, testing, …
Core CS: arrays, lists, stacks, queues, hash tables, trees, graphs, sorting, searching,…
Build your own 2D games from scratch: the game loop, sprites, movement, collisions, and…
Learn Java from zero, with no programming background needed. Write your first program, …
Learn C++ from zero, with no programming background needed. Start with your first progr…
Learn C from zero, with no programming background needed. The language that Unix, Linux…
Learn JavaScript from scratch: variables, types, loops, functions, arrays and objects, …
Build for the browser: structure pages with HTML, style them with CSS, then use live AP…