SQL Window Functions for Data

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Master the power of SQL window functions to unlock advanced analytical capabilities in your data engineering workflow. This course transforms beginners into confident practitioners who can compute rolling averages, assign rankings, and perform complex calculations while preserving row-level detail. This Short Course was created to help data engineering professionals accomplish sophisticated analytical queries that traditional GROUP BY statements simply cannot handle. By completing this course, you'll be able to define analytical windows using OVER() clauses, compute 7-day rolling sales metrics, create dynamic leaderboards with ranking functions, and build time-series analysis queries that you can deploy immediately in production environments. By the end of this course, you will be able to: Apply SQL window functions to compute rolling and rank-based metrics This course is unique because it focuses on hands-on application with real-world scenarios from data engineering practice, using the exact ROW_NUMBER() and AVG() OVER patterns that professionals use daily. To be successful in this course, you should have basic SQL knowledge and experience with data analysis concepts.

Syllabus

Module 1: Apply SQL Window Functions - Foundation

Learners will establish foundational understanding of SQL window functions, master the OVER() clause syntax, and implement basic window function queries for analytical calculations.

Module 2: Compute Rolling and Rank-Based Metrics - Application & Assessment

Learners will master advanced window function applications including rolling calculations, ranking functions, and comprehensive analytical implementations that mirror production data engineering workflows.