Overview
This course covers the learning outcomes and goals of understanding windowing functions in databases. Students will learn about general windowing functions, row number, aggregate functions, framing, new windowing functions like Lag, Lead, and distribution functions. The course teaches skills such as using count(*) as a windowed function and partitioning data. The teaching method includes theoretical explanations and practical examples. The intended audience for this course is database administrators and individuals interested in enhancing their SQL skills.
Syllabus
Introduction
What are Windowing Functions
Row Number
Aggregate Functions
Windowing Functions
Framing
New Windowing Functions
Lag Lag Lead
Lag by Days
Lag by Offset
No Previous Orders
First Last Value
Last Order Date
Distribution Functions
Cumulative vs Percent Rank
Percent Continuous vs Distribution
Partitioning by Postal Code
Finding the Gaps
Recommended Books
Ben Gann
Taught by
PASS Data Community Summit