PIVOT in SQL: How to Turn Rows into Columns
Building pivot tables with pure SQL
How to turn rows into columns using CASE+GROUP BY and FILTER. Step-by-step examples on a real database
Articles & Tutorials
Additional educational materials on SQL, not included in the main course
SQL SEQUENCE in PostgreSQL: one ID generator for multiple tables
Solving the shared document numbering problem
Need shared numbering for invoices and delivery notes, but SERIAL creates duplicates across different tables? SEQUENCE solves this elegantly. We will explore real scenarios, gotchas (number gaps!), and explain why in 90% of cases simple SERIAL is all you need ✨