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.

Advanced
## Recursive Queries in MS SQL Server

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.

112

Interactive courses

18 h

Estimated time

0

Users enrolled

☆☆☆☆☆

★★★★★

2 ratings

**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

- A web browser
- Knowledge of basic SQL, including JOINs and GROUP BY clauses

- 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

- 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

Trial

0%

Completed

0/112

Exercises done

Congratulations

Introduction

Basic CTEs

Summary

You'll learn what recursion is and how to use it in T-SQL queries

Exercises done

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 done

Introduction

CTEs with data modifying statements

Average rating

5.00 / 5

☆☆☆☆☆

★★★★★

2 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%