Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.
Interactive Course
Master the most challenging type of T-SQL queries. Learn how to process trees and graphs in T-SQL, and how to effectively organize long SQL queries.
About the Common Table Expressions in T-SQL Course
This course will cover simple CTEs, nested CTEs, and recursive CTEs. You will learn how to manage your T-SQL queries with CTEs, how and when to nest CTEs, and how to use recursive CTEs to move through hierarchical data models.
This course is intended for intermediate users. We assume the user knows the basics of T-SQL, including:
Course progress
Exercises completed
Test your knowledge of T-SQL
Exercises completed
Congratulations
Your first encounter with Common Table Expressions
Exercises completed
Introduction
Basic CTEs
Summary
You'll learn how to use nested CTEs
Exercises completed
You'll learn what recursion is and how to use it in T-SQL queries
Exercises completed
The very basics
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes
You'll learn how to use INSERT, DELETE, and UPDATE statements with CTEs
Exercises completed
Introduction
CTEs with data modifying statements
Test your knowledge in this final quiz
Exercises completed