课程

Hierarchical and Recursive Queries in SQL Server

高级技能水平

更新时间 2023年3月

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

免费开始课程

SQLProgramming4 小时13 视频47 练习3,800 经验值12,558成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

培训2人或更多？

试用DataCamp for Business

课程描述

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.

先决条件

Functions for Manipulating Data in SQL Server

1

Recursion and Common Table Expression (CTE)

In this chapter, you will learn about recursion and why it is beneficial to apply this technique. You will also refresh your knowledge about Common Expression Tables (CTE).

Recap of Common Table Expressions (CTE)

50 经验值

What is a CTE?

50 经验值

A CTE for IT-positions

100 经验值

A CTE for high-paid IT-positions

100 经验值

Introduction to recursion

50 经验值

Facts about recursion

50 经验值

Calculate the factorial of 5

100 经验值

How to query the factorial of 6 recursively

100 经验值

Solve recursive maths problems

50 经验值

Counting numbers recursively

100 经验值

Calculate the sum of potencies

100 经验值

2

Hierarchical and Recursive Queries

In this chapter, you will learn about recursive CTEs, how to query hierarchical datasets, and finally, how to apply recursive CTEs on hierarchical data.

Introduction to recursive CTE

50 经验值

Right or wrong?

50 经验值

Create the alphabet recursively

100 经验值

Create a time series of a year

100 经验值

Working with recursive queries

50 经验值

Who is your manager?

100 经验值

Get the hierarchy position

100 经验值

Which supervisor do I have?

100 经验值

Analyze the family tree

50 经验值

Get the number of generations?

100 经验值

Get all possible parents in one field?

100 经验值

3

Creating Data Models on Your Own

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

How to work with tables

50 经验值

Creating a table

100 经验值

Inserting and updating a table

100 经验值

Deleting data and dropping table

100 经验值

Changing a table structure

100 经验值

Working with relational data models

50 经验值

Defining primary and foreign keys

100 经验值

Inserting data to person and order history

100 经验值

Getting the number of orders & total costs

100 经验值

Working with hierarchical data models

50 经验值

Creating a hierarchical data model

100 经验值

Networked and hierarchical models

50 经验值

Creating a networked data model

100 经验值

4

Hierarchical Queries of Real-World Examples

In this chapter, you will practice your learnings about hierarchical and recursive querying on real-world problems, such as finding possible flight routes, assembling a car, and modeling a power grid.

Travel planning for flight data

50 经验值

Get the anchor & recursive member

50 经验值

Get all possible airports

100 经验值

All flight routes from Vienna

100 经验值

How to assemble a car?

50 经验值

Create the parts list

100 经验值

Create a car's bill of material

100 经验值

Build up a BMW?

100 经验值

Modeling a power grid

50 经验值

Create a power grid

100 经验值

Get power lines to maintain

100 经验值

Summary of the course

50 经验值

Hierarchical and Recursive Queries in SQL Server

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Hierarchical and Recursive Queries in SQL Server！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。