Managing large hierarchical structures in SQL Server can be a daunting task, often leading to performance issues and complex queries that are difficult to write and maintain. In this course, Advanced Hierarchical Data Management in SQL Server, you’ll gain the ability to efficiently query, navigate, and optimize complex hierarchical data. First, you’ll explore various strategies and approaches for solving the challenges associated with hierarchical data management, such as path enumeration methods, nested set models, and materialized path methods. Next, you’ll discover how to implement these techniques through practical demonstrations, including using recursive queries, designing nested set models, and applying materialized path structures. Finally, you’ll learn how to design efficient and scalable hierarchical data models, considering factors like denormalization, partitioning, and performance optimization. When you’re finished with this course, you’ll have the skills and knowledge of advanced hierarchical data management in SQL Server needed to effectively handle large hierarchical structures and optimize your database performance.
Author Name: Pinal Dave
Author Description:
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Table of Contents

• Course Overview
  1min
• Advanced Techniques for Managing Hierarchical Data
  30mins