Complex Queries with Modern SQL
summary
ISO SQL features since 1999 are presented as practical tools: WITH common table expressions evaluated once for reusing expensive subqueries; recursive CTEs for hierarchies and generating sequences; grouping extensions (GROUPING SETS, ROLLUP, CUBE) to produce multiple aggregate views in one query; and window functions for running totals, ranks and per-partition min/max. Concrete examples shown include selecting top regions contributing >10% of revenue, a birthday-calendar join, and numeric handling of very large powers-of-two, all demonstrated on real sample data.
AI-written summary · about
chapters (6)
- 0:00Modern SQL features
- 10:42CTE benefits
- 15:58Recursive CTEs for hierarchies
- 27:33Grouping Sets and Rollup
- 39:15Window functions use cases
- 54:23Practical examples
related talks
41mModern SQL: Evolution of a dinosaur
45mMore Than a Query Language: SQL in the 21st Century
39mMore Than a Query Language: SQL in the 21st Century
50mJOIN "My Session" ON Modern = 'SQL'
31mFuturistic SQL: Making the impossible possible
54mBecoming a SQL Guru
47mModern SQL: Evolution of a Dinosaur
51mHow Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of