MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Transact-SQL Common Table Expressions

Course Summary

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

  • +

    Course Syllabus

    Course Introduction
    - 1m 55s

    —Course Introduction 1m 12s
    —Course Structure 0m 43s
    CTE 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 21s
    CTE Restrictions
    - 24m 29s
    CTE Usage Scenarios
    - 23m 52s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url