Overview
-
Create a long-term data storage solution using SQL Server 2019 and Azure SQL Data Warehouse.
Syllabus
-
Introduction
- Store information in a data warehouse
- What you should know
- Set up the example databases
- Data warehouse core concepts
- Transactional databases vs. data warehouses
- Dimensions and facts
- Star and snowflake schemas
- Hardware and infrastructure
- Create a data warehouse in SQL Server
- Design dimension tables
- Design fact tables
- Create an indexed view
- Advantages of columnstore indexes
- Memory-optimized columnstore table
- Rebuild columnstore indexes
- Hosting a data warehouse in the cloud
- Create an Azure SQL Data Warehouse project
- Develop tables in Azure SQL Data Warehouse
- The Data Warehouse Migration Utility
- Migrate a data warehouse to Azure
- Pause and remove an Azure data warehouse
- What is ETL and SQL Server Integration Services (SSIS)?
- Understand data flow
- Establish control flow
- SQL Server Data Quality Services (DQS)
- Cleanse data with DQS
- Create a custom knowledge base
- Introduction to Master Data Services (MDS)
- Install MDS and IIS
- Configure Master Data Services
- Deploy a sample MDS model
- Install the MDS Excel add-in
- Update master data in Excel
- Business intelligence applications
- Next steps
