SQL Server: Transact-SQL Common Table Expressions
Offered By: Pluralsight
Course Description
Overview
Learn how to create and use common table expressions (CTEs) correctly, for developers and DBAs from SQL Server 2005 onward
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.
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.
Syllabus
- Course Introduction 1min
- CTE Fundamentals 30mins
- CTE Restrictions 24mins
- CTE Usage Scenarios 23mins
Taught by
Joe Sack
Related Courses
Advanced MySQL TopicsMeta via Coursera موضوعات MySQL المتقدمة
Meta via Coursera Temas avanzados de MySQL
Meta via Coursera Advanced Relational Database and SQL
Coursera Project Network via Coursera Intermediate SQL
Cybrary