Step 2 of 4 in Analytics Engineer

Window Functions in Depth

RANK, LAG, and rolling aggregates — the SQL that turns row-by-row data into answers about change over time.

• 2 lessons
• Intermediate
• ~1 h
• Updated August 2026

Everything in this course is free to read — no account needed. Sign in to track your progress.