01 Introduction to PIVOT and UNPIVOT.mp4 (3 MB)
MP4
02 Demo - Pivoting in a Spreadsheet.mp4 (5.4 MB)
MP4
03 Demo - Pivoting in Transact-SQL Using Cross-tabulation.mp4 (3.91 MB)
MP4
04 Understanding PIVOT Syntax.mp4 (4.17 MB)
MP4
05 Demo - Using PIVOT in Transact-SQL.mp4 (4.14 MB)
MP4
06 Demo - Pivoting on Multiple Columns.mp4 (5.01 MB)
MP4
07 Demo - Building a Dynamic PIVOT Query.mp4 (8.17 MB)
MP4
08 Understanding UNPIVOT Syntax.mp4 (2.8 MB)
MP4
09 Demo - Using UNPIVOT and CROSS APPLY.mp4 (7.12 MB)
MP4
10 Module Summary.mp4 (1.69 MB)
MP4
01 Introduction to the EAV Model.mp4 (2.69 MB)
MP4
02 Demo - Handling Sparse Data Using a Traditional Approach.mp4 (4.38 MB)
MP4
03 Demo - Refactoring into an EAV Model.mp4 (5.23 MB)
MP4
04 Demo - Factoring out Attributes Using Foreign Keys.mp4 (7.08 MB)
MP4
05 Recapping Progress and Issues.mp4 (2.48 MB)
MP4
06 Demo - Handling Types and Constraints.mp4 (8.48 MB)
MP4
07 Demo - Implementing Dynamic Constraints.mp4 (6.09 MB)
MP4
08 Demo - Exploring Sparse Columns.mp4 (3.96 MB)
MP4
09 Demo - Using XML as an Alternative.mp4 (2.63 MB)
MP4
10 Demo - From XML to JSON.mp4 (2.52 MB)
MP4
11 Module Summary.mp4 (3.04 MB)
MP4
1 Course Overview.mp4 (3.42 MB)
MP4
1 Introduction to Recursive Queries.mp4 (4.68 MB)
MP4
2 Using the WITH Statement.mp4 (4.07 MB)
MP4
3 Demo - Iterative Queries Using the WITH Statement.mp4 (6.52 MB)
MP4
4 Writing Recursive Transact-SQL.mp4 (7.01 MB)
MP4
5 Demo - Simple Recursive Queries.mp4 (9.04 MB)
MP4
6 T-SQL Restrictions for Recursive Queries.mp4 (1.17 MB)
MP4
7 Demo - Navigating a Data Hierarchy Using Recursion in T-SQL.mp4 (10.12 MB)
MP4
8 Module Summary.mp4 (2.99 MB)
MP4
1 Introducing Data Sampling.mp4 (1.67 MB)
MP4
2 Understanding Data Sampling Terminology.mp4 (2.12 MB)
MP4
3 The Syntax of the TABLESAMPLE Option.mp4 (2.71 MB)
MP4
4 Demo - Using the TABLESAMPLE Option.mp4 (4.91 MB)
MP4
5 Demo - Stratified Sampling.mp4 (2.01 MB)
MP4
6 Demo - Cluster Sampling.mp4 (2.62 MB)
MP4
7 Module Summary.mp4 (1.26 MB)
MP4