Implementing A SQL Data Warehouse M20767

Introduction to Data Warehousing: Overview of Data Warehousing - Considerations for a Data Warehouse Solution

Planning Data Warehouse Infrastructure: Considerations for Building a Data Warehouse - Data Warehouse Reference Architectures and Appliances

Designing and Implementing a Data Warehouse: Logical Design for a Data Warehouse - Physical Design for a Data Warehouse

Columnstore Indexes: Introduction to Columnstore Indexes - Creating Columnstore Indexes - Working with Columnstore Indexes

Implementing an Azure SQL Data Warehouse: Advantages of Azure SQL Data Warehouse - Implementing an Azure SQL Data Warehouse - Developing an Azure SQL Data Warehouse - Migrating to an Azure SQ Data Warehouse

Creating an ETL Solution: Introduction to ETL with SSIS - Exploring Source Data - Implementing Data Flow

Implementing Control Flow in an SSIS Package: Introduction to Control Flow - Creating Dynamic Packages - Using Containers

Debugging and Troubleshooting SSIS Packages: Debugging an SSIS Package - Logging SSIS Package Events - Handling Errors in an SSIS Package

Implementing an Incremental ETL Process: Introduction to Incremental ETL - Extracting Modified Data - Temporal Tables

Enforcing Data Quality: Introduction to Data Quality - Using Data Quality Services to Cleanse Data - Using Data Quality Services to Match Data

Using Master Data Services: Master Data Services Concepts - Implementing a Master Data Services Model - Managing Master Data - Creating a Master Data Hub

Extending SQL Server Integration Services (SSIS): Using Custom Components in SSIS - Using Scripting in SSIS

Deploying and Configuring SSIS Packages: Overview of SSIS Deployment - Deploying SSIS Projects - Planning SSIS Package Execution

Consuming Data in a Data Warehouse: Introduction to Business Intelligence - Introduction to Reporting - An Introduction to Data Analysis - Analyzing Data with Azure SQL Data Warehouse