Skip to main content

Course

Hierarchical and Recursive Queries in SQL Server

Advanced

4.7+

Updated 05/2025

Learn how to write recursive queries and query hierarchical data structures.

Start Course for Free

Included withPremium or Teams

SQLProgramming4 hours13 videos47 Exercises3,800 XP11,210Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Do you want to query complex data structures in an iterative way? Do you have access to hierarchical data structures that need to be queried? This course will teach you the tools required to solve these questions. You will learn how to write recursive queries and query hierarchical data structures. To do this, you will use Common Table Expressions (CTE) and the recursion principle on a wide variety of datasets. You will, for example, dig into a flight plan dataset and learn how to find the best and cheapest connection between two airports. After completing this course, you will understand the principle of recursion, and be able to identify and create hierarchical data models.

Prerequisites

Functions for Manipulating Data in SQL Server

1

Recursion and Common Table Expression (CTE)

Recap of Common Table Expressions (CTE)

What is a CTE?

A CTE for IT-positions

A CTE for high-paid IT-positions

Introduction to recursion

Facts about recursion

Calculate the factorial of 5

How to query the factorial of 6 recursively

Solve recursive maths problems

Counting numbers recursively

Calculate the sum of potencies

2

Hierarchical and Recursive Queries

Introduction to recursive CTE

Right or wrong?

Create the alphabet recursively

Create a time series of a year

Working with recursive queries

Who is your manager?

Get the hierarchy position

Which supervisor do I have?

Analyze the family tree

Get the number of generations?

Get all possible parents in one field?

3

Creating Data Models on Your Own

How to work with tables

Creating a table

Inserting and updating a table

Deleting data and dropping table

Changing a table structure

Working with relational data models

Defining primary and foreign keys

Inserting data to person and order history

Getting the number of orders & total costs

Working with hierarchical data models

Creating a hierarchical data model

Networked and hierarchical models

Creating a networked data model

4

Hierarchical Queries of Real-World Examples

Travel planning for flight data

Get the anchor & recursive member

Get all possible airports

All flight routes from Vienna

How to assemble a car?

Create the parts list

Create a car's bill of material

Build up a BMW?

Modeling a power grid

Create a power grid

Get power lines to maintain

Summary of the course

Hierarchical and Recursive Queries in SQL Server

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.7

from 23 reviews

78%

22%

0%

0%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Isaac

11 days

Ahmed

12 days

GREATE AS USUAL FRO DATACAMP

Anh

18 days

Jim

21 days

Fuad

25 days

Helpful, informative.

Bongiwe

26 days

Very informative course, l enjoyed it

Isaac

"GREATE AS USUAL FRO DATACAMP"

Ahmed

Anh

FAQs

Join over 16 million learners and start Hierarchical and Recursive Queries in SQL Server today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.