Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Job-ready SQL and database skills
·
Module 11
Advanced Analysis with Window Functions
1
Window Functions: Mastering `OVER()` with Aggregates
Use the `OVER()` clause with aggregate functions to perform calculations across a set of rows.
2
Window Functions: Partitioning Data
Define a data window using `PARTITION BY` to perform calculations on specific groups.
3
Window Functions for Ranking Data
Apply `ROW_NUMBER()`, `RANK()`, and `DENSE_RANK()` to assign ranks to rows within a partition.
4
Window Functions: Running Totals and Moving Averages
Calculate running totals and moving averages using window frames (`ROWS BETWEEN`).
5
Window Functions: LAG() and LEAD()
Use `LAG()` and `LEAD()` to access data from preceding or succeeding rows within a partition.
Previous module
Query Performance and Optimization
Next module
Introduction to NoSQL Databases