Lesson 1 – Introduction | SQL Server Common Table Expressions | Products | Grumpy Old IT Guy

Lesson 1 – Introduction

Lesson 1 – Introduction

This opening lesson provides an overview of the module and sets expectations for what you will learn throughout the course. We introduce the purpose of Common Table Expressions (CTEs), discuss where they fit into modern SQL Server development, and outline how each subsequent lesson builds on the previous one to form a complete understanding of this powerful T-SQL construct.

SQL Server Common Table Expressions

Buy nowLearn more

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