Live Masterclass
3-hour sessions with the author — SQL, query optimisation, and PostgreSQL internals. Pick one topic, or the full curriculum.
One live session on any topic, or the full 6-session curriculum — select either at checkout.
Sign in after checkout and register for whichever available date works for you, topic by topic.
Join the 3-hour live session with real-time Q&A — the recording is yours to rewatch anytime after.
Pick any one, or take the full curriculum — each session is a focused, standalone 3-hour deep dive with real datasets and live Q&A.
Build reliable reports with correct, fast GROUP BY queries. Master GROUPING SETS, ROLLUP, CUBE, HAVING, and advanced aggregate functions on real business datasets — turning raw data into meaningful insights while avoiding the traps that make reports slow or wrong.
Write advanced analytical queries with window functions — ranking, moving averages, and cohort analysis, directly in SQL. What often feels like "advanced SQL magic" becomes a clear, repeatable technique, eliminating complex post-processing logic in your application code.
Stop guessing why queries are slow. Learn to read EXPLAIN and EXPLAIN ANALYZE output like a performance engineer — understanding exactly what PostgreSQL does when executing your queries, so you can diagnose issues with confidence.
Simplify complex queries and reduce technical debt with production-grade JOIN strategies. Go beyond basic joins — lateral joins, set operations, and efficient multi-table strategies that dramatically improve both query clarity and performance.
Design schemas that prevent performance issues before they happen — a high-leverage, long-term investment. Learn to model data structures that align with real query workloads, reducing complexity and letting PostgreSQL scale efficiently with your application.
Systematically turn slow production queries into fast, scalable SQL. Learn a repeatable method for identifying bottlenecks and rewriting inefficient queries — expert-level techniques, without the guesswork.
Pick a single session or the full curriculum. Every session is a focused 3-hour live webinar taught live by Dimitri Fontaine, author of The Art of PostgreSQL.
All 6 sessions, one cohesive curriculum
The complete curriculum, Core to Architect: Reliable Aggregations, Master Window Functions, Read Query Plans, Advanced Join Patterns, Schema for Performance, and Optimize SQL Performance.
Six live sessions, all taught by Dimitri Fontaine — equivalent to five sessions' worth, the sixth is on us.
| 6 × live 3h sessions taught by Dimitri Fontaine | |
| Runs once per quarter — all 6 sessions as one cohort | |
| Recordings included, yours to keep | |
| Register for your dates from your dashboard, after checkout | |
| Digital edition of the book included |
No-questions-asked refund
One topic, one live session
Choose any one of the six Masterclass topics — a focused 3-hour live webinar with practical instruction, demonstrations, and live Q&A.
Taught live by Dimitri Fontaine, a PostgreSQL Major Contributor and the author of The Art of PostgreSQL — not a recording, not a teaching assistant.
| Live 3h session taught by Dimitri Fontaine | |
| Seats are limited per session — see each topic above | |
| Recording included, yours to keep | |
| Register for your date from your dashboard, after checkout | |
| Digital edition of the book included |
No-questions-asked refund
Proven techniques, not theory
Led by the author of The Art of PostgreSQL — a PostgreSQL Major Contributor and international conference speaker.
Drawn from years of real-world PostgreSQL consulting, operations, and performance tuning — not theoretical SQL.
Time for live questions in every session — clarify concepts and connect the material to your own database challenges.
No date to commit to at checkout. Sign in to your dashboard afterwards and register whenever works, topic by topic.
You don't need to at checkout. Sign in to your dashboard afterwards and register for whichever available date works for you. If you bought the curriculum, you register once per topic, each on its own schedule.
Same as the book and the course: a full, no-questions-asked refund. That's true all the way through — even after you've registered for a date and paid, you can still cancel for a full refund.
The recording is yours to keep, so you can catch up anytime — no need to rearrange your calendar around the live date.
A single session covers one of the six topics below. The curriculum is all six — priced at five, so the sixth session is effectively free.
These sessions assume you already write SQL in production — SELECT, JOIN, GROUP BY — and want to go further. They're not an introduction to SQL.
Yes — the digital edition of The Art of PostgreSQL (Second Edition, Updated 2026) is included with every Masterclass purchase.
One session or the full curriculum — choose at checkout.
Not convinced yet? Create a free account and connect to the app's dashboard — sample chapters, sample course modules, and the interactive book reader, free.