Hierarchical structures are among the most challenging datasets to query in SQL Server. Recursive common table expressions make the job easier, but they scare even the most skilled developers. In this course, Mastering Recursive Queries in SQL Server, you’ll gain the ability to create and optimize recursive queries. First, you’ll discover the two essential parts of a recursive query and an easy recipe to remember them. Next, you’ll learn to traverse some of the most common hierarchical datasets, including organizational structures and bills of material. Finally, you’ll learn how to optimize recursive queries for larger datasets by adding proper indexes and identifying when to skip recursive queries altogether. When you’re finished with this course, you’ll have the skills and knowledge to query even the most complex hierarchical data and stand out in our data-driven world.
Author Name: Jared Westover
Author Description:
Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv… more