Learn SQL the way it’s actually used in modern data teams. This course teaches Presto and Trino SQL from the ground up — starting with your first SELECT statement and building all the way to production-scale performance engineering.
You’ll work through real business problems in every section: filtering and aggregating data, joining tables without the classic pitfalls, computing running totals and rankings with window functions, structuring complex analysis with CTEs, and querying JSON and semi-structured data. The final chapters take you into production territory — percentiles and sketches for memory-efficient aggregation, partition pruning, join strategies for skewed data, and byte-parity validation with CHECKSUM to prove your pipelines are correct.
Every concept is demonstrated with hands-on examples drawn from 20 years of experience in financial services and big tech. No fluff, no toy datasets — just the SQL patterns that answer real questions at scale. The course follows the same material as the companion book Presto SQL for Business Analytics: A Practitioner’s Guide from Query to Production.
