Advanced Querying Techniques in SQL Server

Focused View

Chris Behrens

1:13:35

12 View

1. Course Overview

1. Course Overview.mp4

01:27

2. Navigating Data Hierarchies Using Recursive Queries

1. Introduction to Recursive Queries.mp4

02:29

2. Using the WITH Statement.mp4

02:42

3. Demo - Iterative Queries Using the WITH Statement.mp4

02:28

4. Writing Recursive Transact-SQL.mp4

03:59

5. Demo - Simple Recursive Queries.mp4

04:33

6. T-SQL Restrictions for Recursive Queries.mp4

00:44

7. Demo - Navigating a Data Hierarchy Using Recursion in T-SQL.mp4

03:25

8. Module Summary.mp4

01:43

03. Aggregating Data Using the PIVOT and UNPIVOT Clauses

01. Introduction to PIVOT and UNPIVOT.mp4

01:34

02. Demo - Pivoting in a Spreadsheet.mp4

02:11

03. Demo - Pivoting in Transact-SQL Using Cross-tabulation.mp4

01:32

04. Understanding PIVOT Syntax.mp4

02:10

05. Demo - Using PIVOT in Transact-SQL.mp4

01:53

06. Demo - Pivoting on Multiple Columns.mp4

02:15

07. Demo - Building a Dynamic PIVOT Query.mp4

02:52

08. Understanding UNPIVOT Syntax.mp4

01:49

09. Demo - Using UNPIVOT and CROSS APPLY.mp4

02:40

10. Module Summary.mp4

01:02

04. Storing Data as Entities, Attributes, and Values (EAV)

01. Introduction to the EAV Model.mp4

01:22

02. Demo - Handling Sparse Data Using a Traditional Approach.mp4

01:44

03. Demo - Refactoring into an EAV Model.mp4

02:21

04. Demo - Factoring out Attributes Using Foreign Keys.mp4

02:26

05. Recapping Progress and Issues.mp4

01:46

06. Demo - Handling Types and Constraints.mp4

02:49

07. Demo - Implementing Dynamic Constraints.mp4

02:12

08. Demo - Exploring Sparse Columns.mp4

01:46

09. Demo - Using XML as an Alternative.mp4

01:10

10. Demo - From XML to JSON.mp4

01:03

11. Module Summary.mp4

01:50

5. Sampling Data in SQL Server

1. Introducing Data Sampling.mp4

00:53

2. Understanding Data Sampling Terminology.mp4

01:48

3. The Syntax of the TABLESAMPLE Option.mp4

01:54

4. Demo - Using the TABLESAMPLE Option.mp4

02:24

5. Demo - Stratified Sampling.mp4

00:43

6. Demo - Cluster Sampling.mp4

01:10

7. Module Summary.mp4

00:46

Description

SQL Server’s data engine traditionally stores relational data but it can also be used to store data in non-relational schemas. You’ll learn about one example -- Entity, Attribute, Value (EAV).

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Chris Behrens

Instructor's Courses

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.