Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
2
WINDOW FUNCTIONS (ANALYTICS FOCUS)
RANK, ROW_NUMBER, DENSE_RANK, running totals, moving averages with PARTITION BY.
Module Progress0% Complete
90 min total
7 Lessons
0 Completed
Module Content
Window Functions for Analysts
Ranking, running totals, moving averages with OVER().
10 minVideo
Start
Window Functions - Difference between ROW_NUMBER(), RANK(), DENSE_RANK()
7 minVideo
Start
Window Functions - Lead & Lag
10 minVideo
Start
Bucketing with NTILE & Running Totals
A short reading covering the NTILE window function and the running-total frame default -- both required later in this module's quiz and coding exercises but not covered in the videos.
6 minArticle
Start
QUIZ: Window Functions
15 minTutorial
Start
CODING: Window Functions - I
Select correct frames and functions for given analytics asks.
15 minAssignment
Start
CODING - Window Functions - II
15 minAssignment
Start