$5.98

SQL Server Common Table Expressions

Course
17 Lessons

Welcome to the Common Table Expressions (CTEs) Module, an essential part of becoming a proficient SQL Server developer. This module guides you step-by-step through the concepts, capabilities, and practical uses of CTEs—one of the most powerful tools available in Transact-SQL for writing clean, readable, and efficient code.

Buy now

Lesson 1 – Introduction

Preview

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

Preview

Homework

This section contains homework solutions and a template to get you started with the homework. You'll need to use the homework template first. If you get stuck, please take a look at the lesson and, if necessary, look at the solution.

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