Advanced Querying Techniques in SQL Server

سرفصل های دوره

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).

1. Course Overview

1. Course Overview

2. Navigating Data Hierarchies Using Recursive Queries

1. Introduction to Recursive Queries

2. Using the WITH Statement

3. Demo - Iterative Queries Using the WITH Statement

4. Writing Recursive Transact-SQL

5. Demo - Simple Recursive Queries

6. T-SQL Restrictions for Recursive Queries

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

8. Module Summary

03. Aggregating Data Using the PIVOT and UNPIVOT Clauses

01. Introduction to PIVOT and UNPIVOT

02. Demo - Pivoting in a Spreadsheet

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

04. Understanding PIVOT Syntax

05. Demo - Using PIVOT in Transact-SQL

06. Demo - Pivoting on Multiple Columns

07. Demo - Building a Dynamic PIVOT Query

08. Understanding UNPIVOT Syntax

09. Demo - Using UNPIVOT and CROSS APPLY

10. Module Summary

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

01. Introduction to the EAV Model

02. Demo - Handling Sparse Data Using a Traditional Approach

03. Demo - Refactoring into an EAV Model

04. Demo - Factoring out Attributes Using Foreign Keys

05. Recapping Progress and Issues

06. Demo - Handling Types and Constraints

07. Demo - Implementing Dynamic Constraints

08. Demo - Exploring Sparse Columns

09. Demo - Using XML as an Alternative

10. Demo - From XML to JSON

11. Module Summary

5. Sampling Data in SQL Server

1. Introducing Data Sampling

2. Understanding Data Sampling Terminology

3. The Syntax of the TABLESAMPLE Option

4. Demo - Using the TABLESAMPLE Option

5. Demo - Stratified Sampling

6. Demo - Cluster Sampling

7. Module Summary

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight