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

0. Course Overview/0. Course Overview.mp4

4.55 MB

0. Course Overview/0. Course Overview.srt

3.37 KB

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

4.91 MB

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

4.74 KB

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

3.72 MB

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

2.47 KB

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

8.35 MB

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

8.78 KB

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

10.55 MB

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

5.39 KB

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

917.44 KB

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

1.06 KB

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

10.21 MB

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

8.25 KB

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

16.24 MB

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

5.16 KB

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

4.06 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

15.99 MB

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

5.92 KB

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

4.34 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

27.67 MB

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

8.93 KB

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

6.56 MB

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

7.62 KB

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

15.04 MB

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

4.48 KB

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

16.99 MB

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

16.2 KB

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

44.11 MB

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

14.22 KB

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

6.81 MB

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

6.43 KB

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

14.1 MB

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

4.55 KB

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

5.46 MB

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

4.93 KB

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

12.02 MB

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

4.15 KB

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

3.49 MB

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

4.86 KB

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

7.83 MB

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

4.19 KB

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

1.86 MB

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

2.26 KB

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

3.83 MB

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

4.28 KB

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

21.04 MB

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

7.73 KB

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

3.43 MB

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

3.73 KB

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

22.46 MB

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

9.21 KB

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

1.92 MB

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

1.75 KB

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

12.05 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.33 MB

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

4.59 KB

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

14.32 MB

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

6.96 KB

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

1.31 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.08 MB

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

4.35 KB

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

10.5 MB

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

7.11 KB

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

2.63 MB

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

3.07 KB

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

6.42 MB

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

4.49 KB

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

4.84 MB

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

4.63 KB

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

26.17 MB

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

9.69 KB

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

1.11 MB

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

1.38 KB

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

1.41 MB

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

1.23 KB

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

5.07 MB

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

5.05 KB

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

12.94 MB

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

8.49 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.66 KB

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

19.42 MB

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

8.36 KB

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

3.37 MB

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

3.37 KB

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

15.59 MB

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

9.01 KB

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

3.37 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

21.88 MB

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

8.57 KB

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

7.41 MB

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

8.65 KB

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

1.51 MB

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

1.69 KB

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

3.92 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

16.75 MB

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

8.21 KB

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

2.08 MB

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

2.14 KB

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

11.67 MB

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

4.63 KB

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

17.12 MB

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

8.01 KB

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

2.41 MB

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

2.53 KB

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

9.46 MB

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

3.39 KB

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

1.12 MB

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

1.46 KB

content.txt

3.55 KB

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

76.29 MB

资源详情

免责声明