1. Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
2. Planning Data Warehouse Infrastructure
- Considerations for Building a Data Warehouse
- Planning data warehouse hardware
3. Designing and Implementing a Data Warehouse
- Data warehouse design overview
- Designing dimension tables
- Designing fact tables
- Physical Design for a Data Warehouse
4. Columnstore Indexes
- Introduction to Columnstore Indexes
- Creating Columnstore Indexes
- Working with Columnstore Indexes
5. 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
- Copying data with Azue data factory
6. Creating an ETL Solution
- Introduction ETL with SSIS
- Exploring Source Data
- Implementing Data Flow
7. Implementing Control Flow in an SSIS Package
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
- Managing consistency
8. Debugging and Troubleshooting SSIS Packages
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in Data Flow
9. Implementing a Data Extraction Solution
- Introduction to Incremental ETL
- Extracting Modified Data
- Loading Modified Data
- Temporal Tables
10. Enforcing Data Quality
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
11. Using Master Data Services
- Introduction to Master Data Services Concepts
- Implementing a Master Data Services Model
- Hierarchies and Collections
- Creating a Master Data Hub
12. Extending SQL Server Integration Services (SSIS)
- Using Custom Components in SSIS
- Using Scripting in SSIS
13. Deploying and Configuring SSIS Packages
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
14. Consuming Data in a Data Warehouse
- Introduction to Business Intelligence
- An Introduction to Data Analysis
- Introduction to Reporting
- Analyzing Data with Azure SQL Data Warehouse