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

File Name

Size

0. Course Overview/0. Course Overview.mp4

4.5 MB

0. Course Overview/0. Course Overview.srt

3.4 kB

1. Managing Data Warehouse with Best Practices/0. Introduction.mp4

4.9 MB

1. Managing Data Warehouse with Best Practices/0. Introduction.srt

4.7 kB

1. Managing Data Warehouse with Best Practices/1. Demo- Course Resource ZIP File and Restoring a Database.mp4

3.7 MB

1. Managing Data Warehouse with Best Practices/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.3 MB

2. Partitioning Data Warehouse Fact Tables/0. Table Partitioning in SQL Server.srt

8.8 kB

2. Partitioning Data Warehouse Fact Tables/1. Demo- Table Partitioning in SQL Server.mp4

11 MB

2. Partitioning Data Warehouse Fact Tables/1. Demo- Table Partitioning in SQL Server.srt

5.4 kB

2. Partitioning Data Warehouse Fact Tables/10. Summary.mp4

917 kB

2. Partitioning Data Warehouse Fact Tables/10. Summary.srt

1.1 kB

2. Partitioning Data Warehouse Fact Tables/2. Implementing Partitioning on a Fact Table for Faster Querying.mp4

10 MB

2. Partitioning Data Warehouse Fact Tables/2. Implementing Partitioning on a Fact Table for Faster Querying.srt

8.3 kB

2. Partitioning Data Warehouse Fact Tables/3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.mp4

16 MB

2. Partitioning Data Warehouse Fact Tables/3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.srt

5.2 kB

2. Partitioning Data Warehouse Fact Tables/4. Implementing Partition Switching on a Fact Table for Faster Loading.mp4

4.1 MB

2. Partitioning Data Warehouse Fact Tables/4. Implementing Partition Switching on a Fact Table for Faster Loading.srt

4.1 kB

2. Partitioning Data Warehouse Fact Tables/5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.mp4

16 MB

2. Partitioning Data Warehouse Fact Tables/5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.srt

5.9 kB

2. Partitioning Data Warehouse Fact Tables/6. Using Integration Services for Loading a Fact Table.mp4

4.3 MB

2. Partitioning Data Warehouse Fact Tables/6. Using Integration Services for Loading a Fact Table.srt

4.2 kB

2. Partitioning Data Warehouse Fact Tables/7. Demo- Using Integration Services for Loading a Fact Table.mp4

28 MB

2. Partitioning Data Warehouse Fact Tables/7. Demo- Using Integration Services for Loading a Fact Table.srt

8.9 kB

2. Partitioning Data Warehouse Fact Tables/8. Preparing Data and Tables for Bulk Insert.mp4

6.6 MB

2. Partitioning Data Warehouse Fact Tables/8. Preparing Data and Tables for Bulk Insert.srt

7.6 kB

2. Partitioning Data Warehouse Fact Tables/9. Demo- Database Recovery Modes.mp4

15 MB

2. Partitioning Data Warehouse Fact Tables/9. Demo- Database Recovery Modes.srt

4.5 kB

3. Indexing Data Warehouse Tables/0. Indexing in a Data Warehouse.mp4

17 MB

3. Indexing Data Warehouse Tables/0. Indexing in a Data Warehouse.srt

16 kB

3. Indexing Data Warehouse Tables/1. Demo- Indexing in a Data Warehouse.mp4

44 MB

3. Indexing Data Warehouse Tables/1. Demo- Indexing in a Data Warehouse.srt

14 kB

3. Indexing Data Warehouse Tables/2. Building a Clustered Index on the Date Key of a Fact Table.mp4

6.8 MB

3. Indexing Data Warehouse Tables/2. Building a Clustered Index on the Date Key of a Fact Table.srt

6.4 kB

3. Indexing Data Warehouse Tables/3. Demo- Building a Clustered Index on the Date Key of a Fact Table.mp4

14 MB

3. Indexing Data Warehouse Tables/3. Demo- Building a Clustered Index on the Date Key of a Fact Table.srt

4.6 kB

3. Indexing Data Warehouse Tables/4. Creating and Working with Columnstore Indexes.mp4

5.5 MB

3. Indexing Data Warehouse Tables/4. Creating and Working with Columnstore Indexes.srt

4.9 kB

3. Indexing Data Warehouse Tables/5. Demo- Creating and Working with Columnstore Indexes.mp4

12 MB

3. Indexing Data Warehouse Tables/5. Demo- Creating and Working with Columnstore Indexes.srt

4.2 kB

3. Indexing Data Warehouse Tables/6. Maintenance Plans for Indexes.mp4

3.5 MB

3. Indexing Data Warehouse Tables/6. Maintenance Plans for Indexes.srt

4.9 kB

3. Indexing Data Warehouse Tables/7. Demo- Maintenance Plans for Indexes.mp4

7.8 MB

3. Indexing Data Warehouse Tables/7. Demo- Maintenance Plans for Indexes.srt

4.2 kB

3. Indexing Data Warehouse Tables/8. Summary.mp4

1.9 MB

3. Indexing Data Warehouse Tables/8. Summary.srt

2.3 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/0. Creating an SSIS Package Template for Reuse.mp4

3.8 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/0. Creating an SSIS Package Template for Reuse.srt

4.3 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/1. Demo- Creating an SSIS Package Template for Reuse.mp4

21 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/1. Demo- Creating an SSIS Package Template for Reuse.srt

7.7 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/2. Creating a SSIS Solution and Project Template for Reuse.mp4

3.4 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/2. Creating a SSIS Solution and Project Template for Reuse.srt

3.7 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/3. Demo- Creating a SSIS Solution and Project Template for Reuse.mp4

22 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/3. Demo- Creating a SSIS Solution and Project Template for Reuse.srt

9.2 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/4. Creating Reusable Units of SSIS Package Workflow.mp4

1.9 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/4. Creating Reusable Units of SSIS Package Workflow.srt

1.8 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/5. Demo- Creating Reusable Units of SSIS Package Workflow.mp4

12 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/5. Demo- Creating Reusable Units of SSIS Package Workflow.srt

5.4 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/6. Implementing Parallelism for Faster Loading in SSIS.mp4

5.3 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/6. Implementing Parallelism for Faster Loading in SSIS.srt

4.6 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/7. Demo- Implementing Parallelism for Faster Loading in SSIS.mp4

14 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/7. Demo- Implementing Parallelism for Faster Loading in SSIS.srt

7.0 kB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/8. Summary.mp4

1.3 MB

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse/8. Summary.srt

1.6 kB

5. Cleansing Data in a Data Warehouse/0. Data Quality Domains.mp4

4.1 MB

5. Cleansing Data in a Data Warehouse/0. Data Quality Domains.srt

4.3 kB

5. Cleansing Data in a Data Warehouse/1. Demo- Data Quality Domains.mp4

10 MB

5. Cleansing Data in a Data Warehouse/1. Demo- Data Quality Domains.srt

7.1 kB

5. Cleansing Data in a Data Warehouse/2. Creating a Project in Data Quality Services (DQS).mp4

2.6 MB

5. Cleansing Data in a Data Warehouse/2. Creating a Project in Data Quality Services (DQS).srt

3.1 kB

5. Cleansing Data in a Data Warehouse/3. Demo- Creating a Project in Data Quality Services (DQS).mp4

6.4 MB

5. Cleansing Data in a Data Warehouse/3. Demo- Creating a Project in Data Quality Services (DQS).srt

4.5 kB

5. Cleansing Data in a Data Warehouse/4. Cleaning Data in SSIS with a DQS Component.mp4

4.8 MB

5. Cleansing Data in a Data Warehouse/4. Cleaning Data in SSIS with a DQS Component.srt

4.6 kB

5. Cleansing Data in a Data Warehouse/5. Demo- Cleaning Data in SSIS with a DQS Component.mp4

26 MB

5. Cleansing Data in a Data Warehouse/5. Demo- Cleaning Data in SSIS with a DQS Component.srt

9.7 kB

5. Cleansing Data in a Data Warehouse/6. Summary.mp4

1.1 MB

5. Cleansing Data in a Data Warehouse/6. Summary.srt

1.4 kB

6. Centralizing Data with Master Data Management Processes/0. Introduction to Master Data Services.mp4

1.4 MB

6. Centralizing Data with Master Data Management Processes/0. Introduction to Master Data Services.srt

1.2 kB

6. Centralizing Data with Master Data Management Processes/1. Creating Projects with Master Data Services.mp4

5.1 MB

6. Centralizing Data with Master Data Management Processes/1. Creating Projects with Master Data Services.srt

5.0 kB

6. Centralizing Data with Master Data Management Processes/2. Demo- Creating Projects with Master Data Services.mp4

13 MB

6. Centralizing Data with Master Data Management Processes/2. Demo- Creating Projects with Master Data Services.srt

8.5 kB

6. Centralizing Data with Master Data Management Processes/3. Using Master Data Services for Common Data.mp4

5.3 MB

6. Centralizing Data with Master Data Management Processes/3. Using Master Data Services for Common Data.srt

5.7 kB

6. Centralizing Data with Master Data Management Processes/4. Demo- Using Master Data Services for Common Data.mp4

19 MB

6. Centralizing Data with Master Data Management Processes/4. Demo- Using Master Data Services for Common Data.srt

8.4 kB

6. Centralizing Data with Master Data Management Processes/5. Implementing a Master Data Services Model.mp4

3.4 MB

6. Centralizing Data with Master Data Management Processes/5. Implementing a Master Data Services Model.srt

3.4 kB

6. Centralizing Data with Master Data Management Processes/6. Demo- Implementing a Master Data Services Model.mp4

16 MB

6. Centralizing Data with Master Data Management Processes/6. Demo- Implementing a Master Data Services Model.srt

9.0 kB

6. Centralizing Data with Master Data Management Processes/7. Using Excel, SSMS, and SSDT for Managing MDM Data.mp4

3.4 MB

6. Centralizing Data with Master Data Management Processes/7. Using Excel, SSMS, and SSDT for Managing MDM Data.srt

3.4 kB

6. Centralizing Data with Master Data Management Processes/8. Demo- Using Views in SSIS and Staging Data with SSMS.mp4

22 MB

6. Centralizing Data with Master Data Management Processes/8. Demo- Using Views in SSIS and Staging Data with SSMS.srt

8.6 kB

6. Centralizing Data with Master Data Management Processes/9. Security and Sharing.mp4

7.4 MB

6. Centralizing Data with Master Data Management Processes/9. Security and Sharing.srt

8.7 kB

7. Documenting a Data Warehouse/0. Documenting a Data Warehouse.mp4

1.5 MB

7. Documenting a Data Warehouse/0. Documenting a Data Warehouse.srt

1.7 kB

7. Documenting a Data Warehouse/1. Building a Data Dictionary through Data Profiling.mp4

3.9 MB

7. Documenting a Data Warehouse/1. Building a Data Dictionary through Data Profiling.srt

3.9 kB

7. Documenting a Data Warehouse/2. Demo- Building a Data Dictionary through Data Profiling.mp4

17 MB

7. Documenting a Data Warehouse/2. Demo- Building a Data Dictionary through Data Profiling.srt

8.2 kB

7. Documenting a Data Warehouse/3. Automating DDL SQL Production.mp4

2.1 MB

7. Documenting a Data Warehouse/3. Automating DDL SQL Production.srt

2.1 kB

7. Documenting a Data Warehouse/4. Demo- Automating DDL for a New Database.mp4

12 MB

7. Documenting a Data Warehouse/4. Demo- Automating DDL for a New Database.srt

4.6 kB

7. Documenting a Data Warehouse/5. Demo- Automating DDL for a Change.mp4

17 MB

7. Documenting a Data Warehouse/5. Demo- Automating DDL for a Change.srt

8.0 kB

7. Documenting a Data Warehouse/6. Document Data Flows.mp4

2.4 MB

7. Documenting a Data Warehouse/6. Document Data Flows.srt

2.5 kB

7. Documenting a Data Warehouse/7. Demo- Document Data Flows.mp4

9.5 MB

7. Documenting a Data Warehouse/7. Demo- Document Data Flows.srt

3.4 kB

7. Documenting a Data Warehouse/8. Summary.mp4

1.1 MB

7. Documenting a Data Warehouse/8. Summary.srt

1.5 kB

content.txt

3.6 kB

optimizing-data-warehouse-microsoft-sql-server-platform.zip

76 MB