4.2 Read 5 reviews
Overview
Context
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 Hierarchical and Recursive Queries in SQL Server course offered by Data Camp will teach you the tools required to solve these questions.
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.
Programme Structure
Chapters
- Recursion and Common Table Expression (CTE)
- Hierarchical and Recursive Queries
- Creating Data Models on Your Own
- Hierarchical Queries of Real-World Examples
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
Campus Location
- New York City, United States
Disciplines
Data Science & Big Data Software Engineering View 342 other Short Courses in Software Engineering in United StatesWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
PREREQUISITES
- Functions for Manipulating Data in SQL Server
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions
Funding
Improve page content