Hierarchical and Recursive Queries in SQL Server

Name: Hierarchical and Recursive Queries in SQL Server
Brand: Careervira
Price: 150 USD
Availability: InStock
Rating: 1 (1 reviews)

via

DataCamp

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

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

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Functions for Manipulating Data in SQL Server

What You Will Learn

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

Learn how to write recursive queries and query hierarchical data structures

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

Course Content

Expand all sections

Module 1: Recursion and Common Table Expression (CTE)

Module 2: Hierarchical and Recursive Queries

Module 3: Creating Data Models on Your Own

Module 4: Hierarchical Queries of Real-World Examples

Course Instructors

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...