Knowing how to form clear results from hierarchical data is vital for any SQL developer's career. This course will teach you how to create and optimize recursive queries that transform raw data into valuable insights.
Knowing how to form clear results from hierarchical data is vital for any SQL developer's career. This course will teach you how to create and optimize recursive queries that transform raw data into valuable insights.
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.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.