Overview
Context
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 Hierarchical and Recursive Queries in SQL Server course at Data Camp, 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
Language
Delivered
Disciplines
Software Engineering View 550 other Short Courses in Software Engineering in United StatesAcademic 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 Fee
-
International
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 1 days. -
National
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 1 days.
Basic Access: Free; Premium (for individuals): $12.42 per month billed annually; Teams: $25 per month billed annually; Enterprise: Contact sales for pricing