Includes the book
Registration includes The Art of PostgreSQL complete download package (PDF, EPUB, and companion materials), valued at $89.
Limited to 45 seats
Seats are limited to 45 attendees per session. They fill up quickly. See below to register now to the next session.
Turn complex analytics into elegant SQL by mastering ranking, moving averages, and advanced reporting patterns.
Build powerful summary queries and reporting datasets without fragile or slow SQL.
Design schemas that scale by aligning data structures with real-world workloads.
Master complex joins, lateral joins, and set operations to simplify sophisticated data retrieval.
Discover practical techniques to rewrite inefficient SQL into fast, production-grade queries.
Learn to read query plans like a performance engineer and instantly spot why queries are slow.
Choose the workshop that matches your learning goals. Each session is a focused 3-hour live webinar with practical instruction, demonstrations, and live Q&A.
Build Reliable Reports with Correct and Fast GROUP BY Queries
Fix incorrect reports and fragile GROUP BY queries—gain confidence in producing accurate data outputs fast.
| Duration | 3h with Q&A |
|---|---|
| Format | Webinar |
| Seats | 60 |
| Audience | Builder |
| Level | Foundations |
| Next Sessions | PDT | CEST |
|---|---|---|
| May 13th, 2026 | 8am — 11am | 5pm — 8pm |
| June 4th, 2026 | 8am — 11am | 5pm — 8pm |
| July 2nd, 2026 | 8am — 11am | 5pm — 8pm |
Write Advanced Analytical Queries with Window Functions
Unlock advanced analytics directly in SQL and eliminate complex post-processing logic.
| Duration | 3h with Q&A |
|---|---|
| Format | Webinar |
| Seats | 45 |
| Audience | Builder |
| Level | Foundations |
| Next Sessions | PDT | CEST |
|---|---|---|
| May 12th, 2026 | 8am — 11am | 5pm — 8pm |
| June 2nd, 2026 | 8am — 11am | 5pm — 8pm |
| June 30th, 2026 | 8am — 11am | 5pm — 8pm |
Design Schemas That Make Queries Faster and Simpler
Design schemas that prevent performance issues before they happen—high leverage, long-term impact.
| Duration | 3h with Q&A |
|---|---|
| Format | Webinar |
| Seats | 30 |
| Audience | Engineer |
| Level | Advanced |
| Next Sessions | PDT | CEST |
|---|---|---|
| May 19th, 2026 | 8am — 11am | 5pm — 8pm |
| June 9th, 2026 | 8am — 11am | 5pm — 8pm |
| July 7th, 2026 | 8am — 11am | 5pm — 8pm |
Simplify Complex Queries with Advanced JOIN Patterns
Simplify complex queries and reduce technical debt with powerful, production-grade JOIN strategies.
| Duration | 3h with Q&A |
|---|---|
| Format | Webinar |
| Seats | 45 |
| Audience | Engineer |
| Level | Advanced |
| Next Sessions | PDT | CEST |
|---|---|---|
| May 21st, 2026 | 8am — 11am | 5pm — 8pm |
| June 10th, 2026 | 8am — 11am | 5pm — 8pm |
| July 9th, 2026 | 8am — 11am | 5pm — 8pm |
Turn Slow SQL into Fast, Production-Ready Queries
Systematically turn slow production queries into fast, scalable SQL with expert-level techniques.
| Duration | 3h with Q&A |
|---|---|
| Format | Webinar |
| Seats | 30 |
| Audience | Architect |
| Level | Mastery |
| Next Sessions | PDT | CEST |
|---|---|---|
| May 26th, 2026 | 8am — 11am | 5pm — 8pm |
| June 23rd, 2026 | 8am — 11am | 5pm — 8pm |
| July 15th, 2026 | 8am — 11am | 5pm — 8pm |
Read EXPLAIN Plans and Fix Performance Issues with Confidence
Stop guessing: understand exactly why queries are slow and how PostgreSQL executes them.
| Duration | 3h with Q&A |
|---|---|
| Format | Webinar |
| Seats | 45 |
| Audience | Engineer |
| Level | Advanced |
| Next Sessions | PDT | CEST |
|---|---|---|
| May 28th, 2026 | 8am — 11am | 5pm — 8pm |
| June 25th, 2026 | 8am — 11am | 5pm — 8pm |
| July 16th, 2026 | 8am — 11am | 5pm — 8pm |
The content is drawn from years of real-world PostgreSQL consulting, operations, and performance tuning. Instead of theoretical SQL, you'll learn the methods professionals use in production systems.
Registration includes the full edition of The Art of PostgreSQL — a comprehensive reference you can continue to use long after the workshop ends.
Each session delivers focused expertise that would normally require days of trial and error to acquire. Participants leave with practical SQL patterns, performance techniques, and a deeper understanding of how PostgreSQL really works.
Learn how to express complex analytical queries—ranking, moving averages, cohort analysis—using PostgreSQL window functions. This workshop turns what often feels like “advanced SQL magic” into clear, repeatable techniques you can apply immediately.
Go beyond basic joins and learn patterns that simplify complex data retrieval. From lateral joins to efficient multi-table strategies, you’ll gain tools that dramatically improve both query clarity and performance.
Transform raw data into meaningful insights with robust aggregation techniques. This session focuses on practical reporting queries, reliable GROUP BY patterns, and ways to avoid common performance traps.
Good performance starts with good schema design. Learn how to model data structures that align with query workloads, reducing complexity and ensuring PostgreSQL can scale efficiently with your application.
Understand what PostgreSQL actually does when executing your queries. This workshop teaches you how to read EXPLAIN and EXPLAIN ANALYZE output so you can diagnose slow queries with confidence.
Discover practical methods to rewrite inefficient SQL into fast, production-ready queries. You’ll learn a systematic approach to identifying bottlenecks and improving performance without guesswork.
Each workshop is delivered as a concentrated 3-hour online session designed for maximum signal and minimal time commitment. Expect practical demonstrations, clear explanations, and techniques you can apply immediately.
Every session includes time for live questions, allowing participants to clarify concepts and connect the material to their own real-world database challenges.
Workshops are led by the author of The Art of PostgreSQL, a well-known PostgreSQL practitioner and international conference speaker who has taught these techniques to developers and teams worldwide.
Includes the book
Registration includes The Art of PostgreSQL complete download package (PDF, EPUB, and companion materials), valued at $89.
Limited to 45 seats
Seats are limited to 45 attendees per session. They fill up quickly. See below to register now to the next session.
Not convinced yet? Get a FREE chapter including the full Table of Contents!