- Introduction to Data Warehousing
- Planning Data Warehouse Infrastructure
- Designing and Implementing a Data Warehouse
- Columnstore Indexes
- Implementing an Azure SQL Data Warehouse
- Creating an ETL Solution
- Implementing Control Flow in an SSIS Package
- Debugging and Troubleshooting SSIS Packages
- Implementing a Data Extraction Solution
- Enforcing Data Quality
- Master Data Services
- Extending SQL Server Integration Services
- Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse
Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
Planning Data Warehouse Infrastructure
- Considerations for Data Warehouse Infrastructure
- Planning Data Warehouse Hardware
Designing and Implementing a Data Warehouse
- Data Warehouse Design Overview
- Designing Dimension Tables
- Designing Fact Tables
- 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 Database
- Developing an Azure SQL Data Warehouse
- Migrating to an Azure SQL Data Warehouse
- Copying Data with the Azure Data Factory
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
- Managing Consistency
Debugging and Troubleshooting SSIS Packages
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
Implementing a Data Extraction Solution
- Introduction to Incremental ETL
- Extracting Modified Data
- Loading 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
Master Data Services
- Introduction to Master Data Services
- Implementing a Master Data Services Model
- Hierarchies and Collections
- Creating a Master Data Hub
Extending SQL Server Integration Services
- Using Scripts in SSIS
- Using Custom Components in SSIS
Deploying and Configuring SSIS Packages
- Overview of SSIS Development 13-2
- Deploying SSIS Projects 13-5
- Planning SSIS Package Execution 13-14
Consuming Data in a Data Warehouse
- Introduction to Business Intelligence
- Introduction to Data Analysis
- Introduction to Reporting
- Analyzing Data with Azure SQL Data Warehouse