Pluralsight Optimizing Data Warehouse on the Microsoft SQL Server Platform by Thomas LeBlanc

Pluralsight Optimizing Data Warehouse on the Microsoft SQL Server Platform by Thomas LeBlanc

Name	Pluralsight - Optimizing a Data Warehouse on the Microsoft SQL Server Platform by Thomas LeBlanc	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	656.0 MB
Total Files	118
Hash	FA6A5CA7435246FBE87C3AD79A429B824C971224

/0. Course Overview/
0. Course Overview.mp4	4.8 MB
0. Course Overview.srt	3.5 KB
/1. Managing Data Warehouse with Best Practices/
0. Introduction.mp4	5.1 MB
0. Introduction.srt	4.9 KB
1. Demo- Course Resource ZIP File and Restoring a Database.mp4	3.9 MB
1. Demo- Course Resource ZIP File and Restoring a Database.srt	2.5 KB
/2. Partitioning Data Warehouse Fact Tables/
0. Table Partitioning in SQL Server.mp4	8.8 MB
0. Table Partitioning in SQL Server.srt	9.0 KB
1. Demo- Table Partitioning in SQL Server.mp4	11.1 MB
1. Demo- Table Partitioning in SQL Server.srt	5.5 KB
10. Summary.mp4	939.5 KB
10. Summary.srt	1.1 KB
2. Implementing Partitioning on a Fact Table for Faster Querying.mp4	10.7 MB
2. Implementing Partitioning on a Fact Table for Faster Querying.srt	8.4 KB
3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.mp4	17.0 MB
3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.srt	5.3 KB
4. Implementing Partition Switching on a Fact Table for Faster Loading.mp4	4.3 MB
4. Implementing Partition Switching on a Fact Table for Faster Loading.srt	4.2 KB
5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.mp4	16.8 MB
5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.srt	6.1 KB
6. Using Integration Services for Loading a Fact Table.mp4	4.6 MB
6. Using Integration Services for Loading a Fact Table.srt	4.3 KB
7. Demo- Using Integration Services for Loading a Fact Table.mp4	29.0 MB
7. Demo- Using Integration Services for Loading a Fact Table.srt	9.1 KB
8. Preparing Data and Tables for Bulk Insert.mp4	6.9 MB
8. Preparing Data and Tables for Bulk Insert.srt	7.8 KB
9. Demo- Database Recovery Modes.mp4	15.8 MB
9. Demo- Database Recovery Modes.srt	4.6 KB
/3. Indexing Data Warehouse Tables/
0. Indexing in a Data Warehouse.mp4	17.8 MB
0. Indexing in a Data Warehouse.srt	16.6 KB
1. Demo- Indexing in a Data Warehouse.mp4	46.2 MB
1. Demo- Indexing in a Data Warehouse.srt	14.6 KB
2. Building a Clustered Index on the Date Key of a Fact Table.mp4	7.1 MB
2. Building a Clustered Index on the Date Key of a Fact Table.srt	6.6 KB
3. Demo- Building a Clustered Index on the Date Key of a Fact Table.mp4	14.8 MB
3. Demo- Building a Clustered Index on the Date Key of a Fact Table.srt	4.7 KB
4. Creating and Working with Columnstore Indexes.mp4	5.7 MB
4. Creating and Working with Columnstore Indexes.srt	5.0 KB
5. Demo- Creating and Working with Columnstore Indexes.mp4	12.6 MB
5. Demo- Creating and Working with Columnstore Indexes.srt	4.3 KB
6. Maintenance Plans for Indexes.mp4	3.7 MB
6. Maintenance Plans for Indexes.srt	5.0 KB
7. Demo- Maintenance Plans for Indexes.mp4	8.2 MB
7. Demo- Maintenance Plans for Indexes.srt	4.3 KB
8. Summary.mp4	2.0 MB
8. Summary.srt	2.3 KB
/4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/
0. Creating an SSIS Package Template for Reuse.mp4	4.0 MB
0. Creating an SSIS Package Template for Reuse.srt	4.4 KB
1. Demo- Creating an SSIS Package Template for Reuse.mp4	22.1 MB
1. Demo- Creating an SSIS Package Template for Reuse.srt	7.9 KB
2. Creating a SSIS Solution and Project Template for Reuse.mp4	3.6 MB
2. Creating a SSIS Solution and Project Template for Reuse.srt	3.8 KB
3. Demo- Creating a SSIS Solution and Project Template for Reuse.mp4	23.5 MB
3. Demo- Creating a SSIS Solution and Project Template for Reuse.srt	9.4 KB
4. Creating Reusable Units of SSIS Package Workflow.mp4	2.0 MB
4. Creating Reusable Units of SSIS Package Workflow.srt	1.8 KB
5. Demo- Creating Reusable Units of SSIS Package Workflow.mp4	12.6 MB
5. Demo- Creating Reusable Units of SSIS Package Workflow.srt	5.5 KB
6. Implementing Parallelism for Faster Loading in SSIS.mp4	5.6 MB
6. Implementing Parallelism for Faster Loading in SSIS.srt	4.7 KB
7. Demo- Implementing Parallelism for Faster Loading in SSIS.mp4	15.0 MB
7. Demo- Implementing Parallelism for Faster Loading in SSIS.srt	7.1 KB
8. Summary.mp4	1.4 MB
8. Summary.srt	1.6 KB
/5. Cleansing Data in a Data Warehouse/
0. Data Quality Domains.mp4	4.3 MB
0. Data Quality Domains.srt	4.5 KB
1. Demo- Data Quality Domains.mp4	11.0 MB
1. Demo- Data Quality Domains.srt	7.3 KB
2. Creating a Project in Data Quality Services (DQS).mp4	2.8 MB
2. Creating a Project in Data Quality Services (DQS).srt	3.1 KB
3. Demo- Creating a Project in Data Quality Services (DQS).mp4	6.7 MB
3. Demo- Creating a Project in Data Quality Services (DQS).srt	4.6 KB
4. Cleaning Data in SSIS with a DQS Component.mp4	5.1 MB
4. Cleaning Data in SSIS with a DQS Component.srt	4.7 KB
5. Demo- Cleaning Data in SSIS with a DQS Component.mp4	27.4 MB
5. Demo- Cleaning Data in SSIS with a DQS Component.srt	9.9 KB
6. Summary.mp4	1.2 MB
6. Summary.srt	1.4 KB
/6. Centralizing Data with Master Data Management Processes/
0. Introduction to Master Data Services.mp4	1.5 MB
0. Introduction to Master Data Services.srt	1.3 KB
1. Creating Projects with Master Data Services.mp4	5.3 MB
1. Creating Projects with Master Data Services.srt	5.2 KB
2. Demo- Creating Projects with Master Data Services.mp4	13.6 MB
2. Demo- Creating Projects with Master Data Services.srt	8.7 KB
3. Using Master Data Services for Common Data.mp4	5.6 MB
3. Using Master Data Services for Common Data.srt	5.8 KB
4. Demo- Using Master Data Services for Common Data.mp4	20.4 MB
4. Demo- Using Master Data Services for Common Data.srt	8.6 KB
5. Implementing a Master Data Services Model.mp4	3.5 MB
5. Implementing a Master Data Services Model.srt	3.4 KB
6. Demo- Implementing a Master Data Services Model.mp4	16.3 MB
6. Demo- Implementing a Master Data Services Model.srt	9.2 KB
7. Using Excel, SSMS, and SSDT for Managing MDM Data.mp4	3.5 MB
7. Using Excel, SSMS, and SSDT for Managing MDM Data.srt	3.5 KB
8. Demo- Using Views in SSIS and Staging Data with SSMS.mp4	22.9 MB
8. Demo- Using Views in SSIS and Staging Data with SSMS.srt	8.8 KB
9. Security and Sharing.mp4	7.8 MB
9. Security and Sharing.srt	8.9 KB
/7. Documenting a Data Warehouse/
0. Documenting a Data Warehouse.mp4	1.6 MB
0. Documenting a Data Warehouse.srt	1.7 KB
1. Building a Data Dictionary through Data Profiling.mp4	4.1 MB
1. Building a Data Dictionary through Data Profiling.srt	4.0 KB
2. Demo- Building a Data Dictionary through Data Profiling.mp4	17.6 MB
2. Demo- Building a Data Dictionary through Data Profiling.srt	8.4 KB
3. Automating DDL SQL Production.mp4	2.2 MB
3. Automating DDL SQL Production.srt	2.2 KB
4. Demo- Automating DDL for a New Database.mp4	12.2 MB
4. Demo- Automating DDL for a New Database.srt	4.7 KB
5. Demo- Automating DDL for a Change.mp4	18.0 MB
5. Demo- Automating DDL for a Change.srt	8.2 KB
6. Document Data Flows.mp4	2.5 MB
6. Document Data Flows.srt	2.6 KB
7. Demo- Document Data Flows.mp4	9.9 MB
7. Demo- Document Data Flows.srt	3.5 KB
8. Summary.mp4	1.2 MB
8. Summary.srt	1.5 KB
/
content.txt	3.6 KB
optimizing-data-warehouse-microsoft-sql-server-platform.zip	80.0 MB
Total files 118