SQL Server: Transact-SQL Common Table Expressions

By Joe Sack

Learn how to create and use common table expressions (CTEs) correctly, for developers and DBAs from SQL Server 2005 onward

Start free trial now

Course info

Rating

(358)

Level

Intermediate

Updated

February 14, 2014

Duration

1h 20m

Table of contents

Course Introduction

1m 55s

CTE Fundamentals

30m 34s

CTE Restrictions

24m 29s

CTE Usage Scenarios

23m 52s

Description

Course info

Rating

(358)

Level

Intermediate

Updated

February 14, 2014

Duration

1h 20m

Description

Common table expressions are a useful and versatile T-SQL query construct and this demo-centric course shows how to correctly define and use CTEs, what restrictions there are for using them, and some common usage scenarios. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.

About the author

Joe Sack

About the author

Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.