Hierarchical and Recursive Queries in SQL Server

Course Cover

5

(3)

compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

Do you want to automate complex data queries? Are you able to query hierarchical data structures? This course will equip you with the knowledge and skills to answer these kinds of questions. This course will show you how to query hierarchical data structures and create recursive questions. Common Table Expressions (CTE) and the recursion principle are used to achieve this. You will, for example, be able search flight plan data to find the most economical connection between two airports. This course will show you how to create hierarchical data structures and the principles behind recursion.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

Functions for Manipulating Data in SQL Server

What You Will Learn

check-card-img

Learn how to write recursive queries and query hierarchical data structures

check-card-img

You will, for example, dig into a flight plan dataset and learn how to find the best and cheapest connection between two airports

check-card-img

After completing this course, you will understand the principle of recursion, and be able to identify and create hierarchical data models

Course Instructors

Author Image

Dominik Egarter

Data Engineering Enthusiast

Dominik Egarter is IT architecture manager data engineering enthusiast at Kelag, a power utility company in Austria. He is responsible for the data and information architecture and leads several data...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover