This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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?
Unpivoting Data Sets
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
