SQL Server: Transact-SQL Common Table Expressions
Pluralsight
Course Summary
Learn how to create and use common table expressions (CTEs) correctly, for developers and DBAs from SQL Server 2005 onward
-
+
Course 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.
-
+
Course Syllabus
Course Introduction- 1m 55s
—Course Introduction 1m 12s
—Course Structure 0m 43sCTE Fundamentals- 30m 34s
—Module Introduction 0m 43s
—What are CTEs and Why Use Them? 1m 0s
—CTE Syntax 1m 10s
—Demo: Non-Recursive CTE Example 3m 4s
—Demo: Semicolon Requirements 1m 7s
—Demo: When Column Names Must Be Specified 1m 50s
—Demo: Execution Scope 2m 30s
—Demo: Multiple CTE Query Definitions 1m 22s
—Demo: Defining and Referencing Multiple CTEs 1m 24s
—Demo: Multiple References To the Same CTE 3m 2s
—Demo: CTEs with Data Modification Statements 2m 25s
—Demo: CTEs and Views 1m 10s
—Demo: CTEs and Stored Procedures 0m 55s
—Demo: CTEs and Triggers 1m 37s
—Demo: CTEs and User-Defined Functions 3m 5s
—Demo: Recursive CTE Example 3m 43s
—Module Summary 0m 21sCTE Restrictions- 24m 29sCTE Usage Scenarios- 23m 52s