Direkt zum Inhalt

Kurs

Hierarchical and Recursive Queries in SQL Server

Fortgeschritten

Aktualisierte 01.2025

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

Kurs kostenlos starten

Kostenlos inbegriffenPremium or Teams

SQLProgramming4 Stunden13 Videos47 Übungen3,800 XP10,872Leistungsnachweis

Kostenloses Konto erstellen

Google LinkedIn Facebook

oder

Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.

Trainierst du 2 oder mehr?

Versuchen DataCamp for Business

Beliebt bei Lernenden in Tausenden Unternehmen

Kursbeschreibung

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.

Voraussetzungen

Functions for Manipulating Data in SQL Server

1

Recursion and Common Table Expression (CTE)

Kapitel starten

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

Kapitel starten

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

Kapitel starten

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

Kapitel starten

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

Kurs
abgeschlossen

Leistungsnachweis verdienen

Fügen Sie diese Anmeldeinformationen zu Ihrem LinkedIn-Profil, Lebenslauf oder Lebenslauf hinzu
Teilen Sie es in den sozialen Medien und in Ihrer Leistungsbeurteilung

Im Lieferumfang enthaltenPremium or Teams

Machen Sie mit 15 Millionen Lernende und starten Sie Hierarchical and Recursive Queries in SQL Server Heute!

Kostenloses Konto erstellen

Google LinkedIn Facebook

oder

Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.