Common Table Expressions - Advanced

This course builds on familiarity with CTEs and the WITH syntax to explore recursive queries, hierarchical data, data changes through CTEs, common use cases, and performance tradeoffs. It also demonstrates classic recursive algorithms in T-SQL.

Syllabus

Intro
Technical Assistance
SUMMIT 2015
Advanced Common Table Expressions
Recursion Overview
Recursive Terminology
Demo: Recursive CTE
Recursive Demo
Recursive CTE Notes
Hierarchy with multiple recursive queries is possible
Hierarchy with advanced formatting
Recursive Heirarchy Demo
Manipulating Data
Deleting From a CTE
Inserting to a CTE
Updating a CTE
INSERT, UPDATE, DELETE Notes
CTE Common Use Case 2
CTE Performance Considerations
Nested CTES
Recursive Performance
Deep Recursion
Classic Recursive Algorithms