Hierarchical and Recursive Queries in SQL Server

Yes! This course is suitable for beginners looking to learn about how to query hierarchical and recursive data structures. It starts from the basics of Common Table Expressions and recursion principle, so no prior experience is required.

Yes! You will be awarded a certificate of completion upon completion of the course.

Any job that requires querying data structures or working with hierarchical or recursive data would be a great fit for this course. This could include roles such as data analyst, software engineer, database administrator, etc.

Common Table Expressions (CTEs) are statements that let you define a temporary result set that can be referenced further in the same statement. It can be used in other parts of a larger SQL query to make it easier to read.

The recursion principle is the idea of breaking down a complex problem into smaller, simpler problems that can then be used in a recursive fashion to solve the larger problem. It is a useful approach for solving hierarchical or recursive data problems.

In this chapter, you will learn how to create and modify database tables. You will also refresh your knowledge about relational and hierarchical data models, and learn when each model should be used.

In this chapter, you will be presented with real-world problems such as finding possible flight routes, assembling a car, and modeling a power grid, and you will be taught how to apply recursive CTEs on hierarchical data to solve these problems.