Autoplay
Autocomplete
Previous Lesson
Complete and Continue
APPLY Yourself
Getting Started
Introduction (0:38)
Getting Set Up
What is the APPLY Operator? (3:17)
Working with Functions
Working with Dynamic Management Functions (3:56)
Working with User-Defined Functions (4:50)
Working with Functions - Quiz
Pre-Aggregating Data
Aggregating Data in SQL Server (2:54)
Query Performance with Aggregations and Joins (3:22)
Ad Hoc Functions and APPLY (2:01)
Pre-Aggregating Data - Quiz
Retrieving a Child Record
Get the Latest Child Record (3:10)
Comparing the Competitors: Take One (9:57)
Comparing the Competitors: Take Two (3:29)
Retrieving a Child Record - Quiz
Retrieving N Child Records
Get the Last N Child Records (2:04)
Comparing the Competitors (8:22)
Simplifying Calculations
The True Power of APPLY (1:36)
Simplifying Calculations with APPLY (11:11)
Limitations and Alternatives to APPLY (2:55)
Simplifying Calculations - Quiz
Reshaping Data Sets
Unpivoting Data Sets (4:38)
Combining Values (2:41)
Splitting Strings (8:59)
Reshaping Data Sets - Quiz
That's a Wrap!
In Summary (1:55)
What Did You Think?
Teach online with
Ad Hoc Functions and APPLY
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
