Learn from Hands-On Examples


This training is packed with practical demos showing off how the APPLY operator works in SQL Server. With ten separate demos on a range of topics, you will get a good understanding of how everything works.



The Pitch


Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. Knowing how and when to use APPLY can take your T-SQL and query tuning skills to the next level.

Over the course of this training, we will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting child records for each parent record, simplifying calculations, and much more.


Course Curriculum


  Getting Started
Available in days
days after you enroll
  Working with Functions
Available in days
days after you enroll
  Pre-Aggregating Data
Available in days
days after you enroll
  Retrieving a Child Record
Available in days
days after you enroll
  Retrieving N Child Records
Available in days
days after you enroll
  Simplifying Calculations
Available in days
days after you enroll
  Reshaping Data Sets
Available in days
days after you enroll
  That's a Wrap!
Available in days
days after you enroll

Choose a Pricing Option

$40

Single Course

Full access to a single training course

What you get: access to this training, including free updates, for the life of the course. This includes free support if you have issues accessing the course or its materials.

Work on the Solution with Me



All of the T-SQL scripts used in demos are also available upon purchase of the course. Take the same code I use and learn at your own pace, taking apart and rebuilding examples.