Database management systems notes
Views, CTEs & Window Functions
Naming things, and the one feature that computes across rows without collapsing them. Every section is a drawn page beside a clear written explanation, about 21 minutes in all.
- Chapter 12 of 34
- About 21 minutes
- 8 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- Views: a query with a name
- Updatable and materialized views
- Common table expressions
- Recursive CTEs: walking a hierarchy
- Window functions: aggregate without collapsing
- Ranking, and the top-N-per-group problem
- Running totals, and comparing with the previous row
- What Part B built
Next chapters
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.