Introduction
1. Welcome
The very basics
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes
Summary

Instruction

Hello and welcome to the fourth part of our course. Today, we're going to introduce the concepts of recursion and recursive CTEs; this is probably the most difficult part of our entire course. Don't worry if you can't understand something at first – take your time and read the instructions carefully again and again.

Recursive CTEs make it possible to process "hierarchical structures" – trees and graphs – using T-SQL. For instance, such structures are used when talking about superior and inferior employees, railway connections, application menus, etc.

If you're ready for the challenge, let's move on.

Exercise

Click Next exercise to continue.