TorBT - Torrents and Magnet Links Search Engine
Advanced Querying Techniques in SQL Server
- Date: 2025-09-02
- Size: 174 MB
- Files: 75
File Name
Size
01. Course Overview/01. Course Overview.mp4
3.4 MB
01. Course Overview/01. Course Overview.srt
2.2 kB
02. Navigating Data Hierarchies Using Recursive Queries/01. Introduction to Recursive Queries.mp4
4.7 MB
02. Navigating Data Hierarchies Using Recursive Queries/01. Introduction to Recursive Queries.srt
2.5 kB
02. Navigating Data Hierarchies Using Recursive Queries/02. Using the WITH Statement.mp4
4.1 MB
02. Navigating Data Hierarchies Using Recursive Queries/02. Using the WITH Statement.srt
4.0 kB
02. Navigating Data Hierarchies Using Recursive Queries/03. Demo- Iterative Queries Using the WITH Statement.mp4
6.5 MB
02. Navigating Data Hierarchies Using Recursive Queries/03. Demo- Iterative Queries Using the WITH Statement.srt
3.8 kB
02. Navigating Data Hierarchies Using Recursive Queries/04. Writing Recursive Transact-SQL.mp4
7.0 MB
02. Navigating Data Hierarchies Using Recursive Queries/04. Writing Recursive Transact-SQL.srt
5.8 kB
02. Navigating Data Hierarchies Using Recursive Queries/05. Demo- Simple Recursive Queries.mp4
9.0 MB
02. Navigating Data Hierarchies Using Recursive Queries/05. Demo- Simple Recursive Queries.srt
6.9 kB
02. Navigating Data Hierarchies Using Recursive Queries/06. T-SQL Restrictions for Recursive Queries.mp4
1.2 MB
02. Navigating Data Hierarchies Using Recursive Queries/06. T-SQL Restrictions for Recursive Queries.srt
990 B
02. Navigating Data Hierarchies Using Recursive Queries/07. Demo- Navigating a Data Hierarchy Using Recursion in T-SQL.mp4
10 MB
02. Navigating Data Hierarchies Using Recursive Queries/07. Demo- Navigating a Data Hierarchy Using Recursion in T-SQL.srt
5.6 kB
02. Navigating Data Hierarchies Using Recursive Queries/08. Module Summary.mp4
3.0 MB
02. Navigating Data Hierarchies Using Recursive Queries/08. Module Summary.srt
2.7 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/01. Introduction to PIVOT and UNPIVOT.mp4
3.0 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/01. Introduction to PIVOT and UNPIVOT.srt
2.1 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/02. Demo- Pivoting in a Spreadsheet.mp4
5.4 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/02. Demo- Pivoting in a Spreadsheet.srt
3.2 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/03. Demo- Pivoting in Transact-SQL Using Cross-tabulation.mp4
3.9 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/03. Demo- Pivoting in Transact-SQL Using Cross-tabulation.srt
2.3 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/04. Understanding PIVOT Syntax.mp4
4.2 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/04. Understanding PIVOT Syntax.srt
3.4 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/05. Demo- Using PIVOT in Transact-SQL.mp4
4.1 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/05. Demo- Using PIVOT in Transact-SQL.srt
2.8 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/06. Demo- Pivoting on Multiple Columns.mp4
5.0 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/06. Demo- Pivoting on Multiple Columns.srt
3.3 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/07. Demo- Building a Dynamic PIVOT Query.mp4
8.2 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/07. Demo- Building a Dynamic PIVOT Query.srt
4.4 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/08. Understanding UNPIVOT Syntax.mp4
2.8 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/08. Understanding UNPIVOT Syntax.srt
2.9 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/09. Demo- Using UNPIVOT and CROSS APPLY.mp4
7.1 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/09. Demo- Using UNPIVOT and CROSS APPLY.srt
4.1 kB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/10. Module Summary.mp4
1.7 MB
03. Aggregating Data Using the PIVOT and UNPIVOT Clauses/10. Module Summary.srt
1.6 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/01. Introduction to the EAV Model.mp4
2.7 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/01. Introduction to the EAV Model.srt
2.1 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/02. Demo- Handling Sparse Data Using a Traditional Approach.mp4
4.4 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/02. Demo- Handling Sparse Data Using a Traditional Approach.srt
2.7 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/03. Demo- Refactoring into an EAV Model.mp4
5.2 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/03. Demo- Refactoring into an EAV Model.srt
3.5 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/04. Demo- Factoring out Attributes Using Foreign Keys.mp4
7.1 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/04. Demo- Factoring out Attributes Using Foreign Keys.srt
3.6 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/05. Recapping Progress and Issues.mp4
2.5 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/05. Recapping Progress and Issues.srt
2.7 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/06. Demo- Handling Types and Constraints.mp4
8.5 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/06. Demo- Handling Types and Constraints.srt
4.3 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/07. Demo- Implementing Dynamic Constraints.mp4
6.1 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/07. Demo- Implementing Dynamic Constraints.srt
3.3 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/08. Demo- Exploring Sparse Columns.mp4
4.0 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/08. Demo- Exploring Sparse Columns.srt
2.6 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/09. Demo- Using XML as an Alternative.mp4
2.6 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/09. Demo- Using XML as an Alternative.srt
1.7 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/10. Demo- From XML to JSON.mp4
2.5 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/10. Demo- From XML to JSON.srt
1.1 kB
04. Storing Data as Entities, Attributes, and Values (EAV)/11. Module Summary.mp4
3.0 MB
04. Storing Data as Entities, Attributes, and Values (EAV)/11. Module Summary.srt
2.8 kB
05. Sampling Data in SQL Server/01. Introducing Data Sampling.mp4
1.7 MB
05. Sampling Data in SQL Server/01. Introducing Data Sampling.srt
1.5 kB
05. Sampling Data in SQL Server/02. Understanding Data Sampling Terminology.mp4
2.1 MB
05. Sampling Data in SQL Server/02. Understanding Data Sampling Terminology.srt
2.8 kB
05. Sampling Data in SQL Server/03. The Syntax of the TABLESAMPLE Option.mp4
2.7 MB
05. Sampling Data in SQL Server/03. The Syntax of the TABLESAMPLE Option.srt
3.1 kB
05. Sampling Data in SQL Server/04. Demo- Using the TABLESAMPLE Option.mp4
4.9 MB
05. Sampling Data in SQL Server/04. Demo- Using the TABLESAMPLE Option.srt
3.7 kB
05. Sampling Data in SQL Server/05. Demo- Stratified Sampling.mp4
2.0 MB
05. Sampling Data in SQL Server/05. Demo- Stratified Sampling.srt
1.1 kB
05. Sampling Data in SQL Server/06. Demo- Cluster Sampling.mp4
2.6 MB
05. Sampling Data in SQL Server/06. Demo- Cluster Sampling.srt
1.9 kB
05. Sampling Data in SQL Server/07. Module Summary.mp4
1.3 MB
05. Sampling Data in SQL Server/07. Module Summary.srt
1.3 kB
advanced-querying-techniques-sql-server.zip
14 MB