SQL Server Common Table Expressions
Buy now
Learn more
Discussions
Lesson 1 – Introduction
Lesson 2 – What is a CTE?
Lesson 3 – A CTE Query: Structure and First Examples
Lesson 4 – CTE versus CURSOR
Lesson 5 – CTEs and VIEWS
Lesson 6 – CTEs and DELETE Commands
Lesson 7 – Passing Tables to Functions (with a CTE Inside)
Lesson 8 – CTEs and UPDATE Commands
Lesson 9 – CTEs and Table-Valued Functions (TVFs)
Lesson 10 – CURSORS and NESTED CURSORS
Lesson 11 – Summary and Wrap-Up
Homework
INTERMEDIATE TSQL - MODULE 05 - CTE 12-08-2025.sql
M5 Lesson Homework Assignments.sql
M5 HOMEWORK TEMPLATES.sql
M5 HOMEWORK SOLUTIONS.sql
INTERMEDIATE TSQL - MODULE 05 - CREATE SALESORDER DATABASE.SQL
INTERMEDIATE TSQL - MODULE 05 - CREATE SALESORDER TABLES.SQL
Products
Course
Section
Section
Section
SQL Server Common Table Expressions
Buy now
Learn more
Discussions
Lesson 1 – Introduction
Lesson 2 – What is a CTE?
Lesson 3 – A CTE Query: Structure and First Examples
Lesson 4 – CTE versus CURSOR
Lesson 5 – CTEs and VIEWS
Lesson 6 – CTEs and DELETE Commands
Lesson 7 – Passing Tables to Functions (with a CTE Inside)
Lesson 8 – CTEs and UPDATE Commands
Lesson 9 – CTEs and Table-Valued Functions (TVFs)
Lesson 10 – CURSORS and NESTED CURSORS
Lesson 11 – Summary and Wrap-Up
Homework
INTERMEDIATE TSQL - MODULE 05 - CTE 12-08-2025.sql
M5 Lesson Homework Assignments.sql
M5 HOMEWORK TEMPLATES.sql
M5 HOMEWORK SOLUTIONS.sql
INTERMEDIATE TSQL - MODULE 05 - CREATE SALESORDER DATABASE.SQL
INTERMEDIATE TSQL - MODULE 05 - CREATE SALESORDER TABLES.SQL
11 Lessons
Lesson 1 – Introduction
Lesson 2 – What is a CTE?
Lesson 3 – A CTE Query: Structure and First Examples
Lesson 4 – CTE versus CURSOR
Lesson 5 – CTEs and VIEWS
Lesson 6 – CTEs and DELETE Commands
Lesson 7 – Passing Tables to Functions (with a CTE Inside)
Lesson 8 – CTEs and UPDATE Commands
Lesson 9 – CTEs and Table-Valued Functions (TVFs)
Lesson 10 – CURSORS and NESTED CURSORS
Lesson 11 – Summary and Wrap-Up