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

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 deve

  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Course Structure
    ● CTE Fundamentals
        ◦ Module Introduction
        ◦ What are CTEs and Why Use Them?
        ◦ CTE Syntax
        ◦ Demo: Non-Recursive CTE Example
        ◦ Demo: Semicolon Requirements
        ◦ Demo: When Column Names Must Be Specified
        ◦ Demo: Execution Scope
        ◦ Demo: Multiple CTE Query Definitions
        ◦ Demo: Defining and Referencing Multiple CTEs
        ◦ Demo: Multiple References To the Same CTE
        ◦ Demo: CTEs with Data Modification Statements
        ◦ Demo: CTEs and Views
        ◦ Demo: CTEs and Stored Procedures
        ◦ Demo: CTEs and Triggers
        ◦ Demo: CTEs and User-Defined Functions
        ◦ Demo: Recursive CTE Example
        ◦ Module Summary
    ● CTE Restrictions
        ◦ Module Introduction
        ◦ Demo: Forward Referencing Restrictions
        ◦ Demo: ORDER BY restrictions
        ◦ Demo: INTO and CTE Restriction
        ◦ Demo: CTE Nesting Restriction
        ◦ Demo: OPTION Clause with Query Hints Restriction
        ◦ Demo: Max Recursion Limitation
        ◦ Is it a Bug?
        ◦ Demo: Late Filtering
        ◦ Demo: Non-Recursive Self-Join
        ◦ Demo: CTEs and Non-Deterministic Functions
        ◦ Module Summary
    ● CTE Usage Scenarios
        ◦ Module Introduction
        ◦ Demo: CTEs vs. Derived Table Code Clarity
        ◦ Demo: Windowing Functions, Predicates and CTEs
        ◦ Demo: Return Lineage Information
        ◦ Demo: Multiple Anchors
        ◦ Demo: Sequence Generation
        ◦ Demo: CTEs as Reference Table Replacements
        ◦ Demo: Windowing Functions and Data Modifications
        ◦ Demo: Referencing a Scalar Subselect in a Predicate
        ◦ Summarizing CTE Usage Scenarios
        ◦ Module Summary
        ◦ Course Summary


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

Back to Top