[Pluralsight] Optimizing a Data Warehouse on the Microsoft SQL Server Platform [2020, ENG]

Содержание

Course Overview 2m 5s Course Overview 2m 5sManaging Data Warehouse with Best Practices 4m 9s Introduction 2m 50s Demo: Course Resource ZIP File and Restoring a Database 1m 19sPartitioning Data Warehouse Fact Tables 38m 35s Table Partitioning in SQL Server 5m 10s Demo: Table Partitioning in SQL Server 3m 17s Implementing Partitioning on a Fact Table for Faster Querying 5m 12s Demo: Implementing Partitioning on a Fact Table for Faster Querying 2m 58s Implementing Partition Switching on a Fact Table for Faster Loading 2m 25s Demo: Implementing Partition Switching on a Fact Table for Faster Loading 3m 37s Using Integration Services for Loading a Fact Table 2m 32s Demo: Using Integration Services for Loading a Fact Table 5m 31s Preparing Data and Tables for Bulk Insert 4m 19s Demo: Database Recovery Modes 2m 51s Summary 38sIndexing Data Warehouse Tables 35m 11s Indexing in a Data Warehouse 9m 1s Demo: Indexing in a Data Warehouse 8m 0s Building a Clustered Index on the Date Key of a Fact Table 3m 45s Demo: Building a Clustered Index on the Date Key of a Fact Table 2m 40s Creating and Working with Columnstore Indexes 2m 53s Demo: Creating and Working with Columnstore Indexes 2m 26s Maintenance Plans for Indexes 2m 41s Demo: Maintenance Plans for Indexes 2m 29s Summary 1m 13sExtracting, Transforming, and Loading (ETL) a Data Warehouse 26m 37s Creating an SSIS Package Template for Reuse 2m 27s Demo: Creating an SSIS Package Template for Reuse 4m 35s Creating a SSIS Solution and Project Template for Reuse 2m 11s Demo: Creating a SSIS Solution and Project Template for Reuse 5m 40s Creating Reusable Units of SSIS Package Workflow 1m 10s Demo: Creating Reusable Units of SSIS Package Workflow 3m 6s Implementing Parallelism for Faster Loading in SSIS 2m 40s Demo: Implementing Parallelism for Faster Loading in SSIS 3m 52s Summary 53sCleansing Data in a Data Warehouse 20m 12s Data Quality Domains 2m 38s Demo: Data Quality Domains 4m 7s Creating a Project in Data Quality Services (DQS) 1m 43s Demo: Creating a Project in Data Quality Services (DQS) 2m 27s Cleaning Data in SSIS with a DQS Component 2m 43s Demo: Cleaning Data in SSIS with a DQS Component 5m 46s Summary 45sCentralizing Data with Master Data Management Processes 36m 6s Introduction to Master Data Services 52s Creating Projects with Master Data Services 3m 4s Demo: Creating Projects with Master Data Services 5m 4s Using Master Data Services for Common Data 3m 13s Demo: Using Master Data Services for Common Data 4m 47s Implementing a Master Data Services Model 2m 0s Demo: Implementing a Master Data Services Model 5m 24s Using Excel, SSMS, and SSDT for Managing MDM Data 1m 54s Demo: Using Views in SSIS and Staging Data with SSMS 4m 47s Security and Sharing 4m 57sDocumenting a Data Warehouse 20m 52s Documenting a Data Warehouse 1m 0s Building a Data Dictionary through Data Profiling 2m 14s Demo: Building a Data Dictionary through Data Profiling 4m 35s Automating DDL SQL Production 1m 14s Demo: Automating DDL for a New Database 2m 52s Demo: Automating DDL for a Change 4m 39s Document Data Flows 1m 29s Demo: Document Data Flows 1m 57s Summary 49s

Скриншоты