Simple play icon Course
Skills

Getting Started with Hierarchical Data in SQL Server

by JS Padoan

Explore the world of hierarchical data in SQL Server! This course will teach you how to understand, manage, and query hierarchical structures effectively, using common table expressions and recursive queries for real-world applications.

What you'll learn

Managing hierarchical data in SQL Server can be a complex task, often leading to inefficiencies in data retrieval and organization, especially in businesses with intricate structures or nested data categories. In this course, Getting Started with Hierarchical Data in SQL Server, you’ll learn to effectively manage and query hierarchical data. First, you’ll explore the basics of hierarchical structures and their importance in database design, helping you understand the foundational concepts of tree and graph structures.

Next, you’ll discover how to manage these structures using Common Table Expressions (CTEs) in SQL Server, a crucial skill for maintaining organized and accessible data.

Finally, you’ll learn how to write and understand recursive queries, enabling efficient data retrieval and manipulation in complex hierarchical systems.

When you’re finished with this course, you’ll have the skills and knowledge of hierarchical data management in SQL Server needed to handle real-world data challenges effectively.

About the author

With 20 years of experience in the Microsoft eco-system, Jean-Sébastien assists clients in designing, building, developing and deploying Microsoft solutions in on-premise or Azure / Office365 environments. JS has skills, experience and certifications in Windows Server / .NET / SharePoint / SqlServer / Office365 / PowerPlatform. He also teaches these subjects as a Microsoft certified trainer for 13 years. He is also a Microsoft power-seller in the area of data and analysis and is therefore able t... more

Ready to upskill? Get started