CMU 15-445 #02: Modern SQL — Window Functions, CTEs & Bag Semantics
Associate Professor of Databaseology
1:15:50·2023·undergraduate level
Moves far beyond SELECT-FROM-WHERE into modern declarative SQL-99+: window functions, recursive CTEs, lateral joins, and aggregation edge cases.
Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)
Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/02-modernsql.pdf
Notes: https://15445.courses.cs.cmu.edu/fall2023/notes/02-modernsql.pdf
Previous · Lecture 2
CMU 15-445 #01: The Relational Model & Relational Algebra
Next · Lecture 4CMU 15-445 #03: Database Storage I — Volatile vs. Non-Volatile Hierarchy & Slotted Pages
Comments
Add a comment...Sign in