Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Advanced Querying Techniques in SQL Server

via Pluralsight

Overview



SQL Server’s Transact-SQL language has the ability to transform relational data in a wide variety of ways. In this course, Advanced Querying Techniques in SQL Server, you’ll gain the ability to solve four important problems using SQL Server. First, you’ll learn how to navigate hierarchical data using recursive common table expressions (CTEs). Second, you’ll explore how to rotate tabular data while aggregating desired metrics using PIVOT. Next, you’ll discover how to transform cross tabulated data into relational data using UNPIVOT. Then, you’ll see how to use semantic data modeling and Entry, Attribute, and Value data structures when a purely relational model limits flexibility and attributes can change frequently. Finally, you'll learn how to sample SQL Server data for analysis and testing. When you’re finished with this course, you’ll have the skills and knowledge of advanced SQL Server querying techniques needed to quickly address the problems presented here.

Syllabus

  • Course Overview 1min
  • Navigating Data Hierarchies Using Recursive Queries 22mins
  • Aggregating Data Using the PIVOT and UNPIVOT Clauses 20mins
  • Storing Data as Entities, Attributes, and Values (EAV) 20mins
  • Sampling Data in SQL Server 9mins

Taught by

Pluralsight

Reviews

4.5 rating at Pluralsight based on 22 ratings

Start your review of Advanced Querying Techniques in SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.