Advanced Course
Recursive Queries in MS SQL Server
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.
4.84
5,370 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 18 h
Coding challenges 112
Skills you will gain
- Understand and use basic Common Table Expressions
- Split long T-SQL queries with simple and nested CTEs
- Deploy recursive CTEs
- Write recursive CTEs that traverse a hierarchical data model
Last reviews
Description
Description
Common Table Expressions (CTEs), often simply called WITH clauses, are essentially just named subqueries. They are a fairly new feature of T-SQL; with CTEs, you can break a long query into smaller chunks, which makes it more readable. Unlike T-SQL subqueries, CTEs can be recursive, allowing the traversal of hierarchical models of enormous depth.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:
- How to select from a single table, including writing complex WHERE conditions
- How to JOIN tables
- How GROUP BY and HAVING work
- How T-SQL subqueries work
What Are the Requirements?
- A web browser
- Knowledge of basic SQL, including JOINs and GROUP BY clauses
What Am I Going To Get from This T-SQL Course?
You will discover how to:- Understand and use basic Common Table Expressions
- Split long T-SQL queries with simple and nested CTEs
- Deploy recursive CTEs
- Write recursive CTEs that traverse a hierarchical data model
Who Should Take This Course?
- Beginning database analysts
- Developers who want to keep their knowledge of T-SQL current
- Students taking classes in relational databases
- Anyone who wants to learn Common Table Expressions in T-SQL
Table of contents
Course progress 0%
Exercises completed 0/112
-
Test your knowledge of T-SQL
-
Your first encounter with Common Table Expressions
-
You'll learn how to use nested CTEs
-
You'll learn what recursion is and how to use it in T-SQL queries
-
You'll learn how to use INSERT, DELETE, and UPDATE statements with CTEs
-
Test your knowledge in this final quiz
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills