Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Mastering Recursive Queries in SQL Server

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.

Jared Westover - Pluralsight course - Mastering Recursive Queries in SQL Server
by Jared Westover

What you'll learn

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.

Table of contents

About the author

Jared Westover - Pluralsight course - Mastering Recursive Queries in SQL Server
Jared Westover

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.

More Courses by Jared