Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
1. Welcome
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes


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.


Click Next exercise to continue.