T-SQL Window Functions
Pluralsight
Course Summary
Learn to use the versatile T-SQL functions called "window functions" to solve complex queries.
-
+
Course Description
With the 2005 and 2012 releases of SQL Server, Microsoft gave us several new functions with amazing capabilities. These functions are part of the ANSI standards, and have nothing to do with the Windows OS. Some of these functions are well known, for example ROW_NUMBER is used by many people. In addition to ROW_NUMBER, we now have the ability to calculate summaries without changing a query to an aggregate query, calculate running totals, pull values from other rows, and perform statistical calculations. This course covers all of the available window functions including syntax, real world examples, and performance considerations.
-
+
Course Syllabus
Getting Started- 10m 48s
—Introduction to Window Functions 3m 54s
—Demo 1: The Stock Market Problem 1m 56s
—Tools to Measure Performance 0m 22s
—Demo 2: Measuring Performance 3m 54s
—Course Overview 0m 41sUnderstanding the OVER Clause- 11m 11s
—The Parts of the OVER Clause 4m 35s
—Demonstration: OVER Clause 6m 20s
—What's Next? 0m 15sUsing Ranking Functions- 25m 34sUsing Window Aggregate Functions- 26m 34sUnderstanding Framing- 13m 58sUsing Accumulating Window Aggregates- 20m 3sRetrieving Data from Other Rows- 25m 41sUsing Statistical Functions- 17m 36s