Windowing Functions for Database Analytics

on YouTube ↗01m

" summary

Demos windowing functions available in mysql and other relational databases that make per-group analytics feasible inside SQL, including partition by department_id and date-range partitioning for year-to-date calculations. Shows concrete functions used (row_number, rank, lag, lead, sum over) to build running totals and moving averages, explains minimal statistics needed, and proves these queries run directly in the database without external aggregation tools.

AI-written summary · about

" related talks

• 01h 06mPostgres Window MagicBruce Momjian · PostgresOpen Silicon Valley 2017
• 51mUnderstanding window functions in DAXMarco Russo · SQLBits 2024
• 34mCommon Table Expressions and Window Functions simple, maintainable, fast queriesVicentiu-Marian Ciorbaru · Percona Live Open Source Database Conference 2017
• 44mBeyond WHERE and GROUP BYSergey Golubchik · HighLoad++ 2017
• 33mMaking Data DanceClark Barrett · PGConf Silicon Valley 2016
• 46mT-SQL Window Function PerformanceKathi Kellenberger · Women Data Summit 2021
• 49mModern T SQL for Better PerformanceKathi Kellenberger · SQL Server Virtual Conference 2021
• 01h 00mComplex Queries with Modern SQLHolger Jakobs · FrOSCon 2016