About Course
Course Objectives
-
Design and implement a data warehouse solution using Microsoft SQL Server.
-
Plan and build data warehouse infrastructure to support Business Intelligence (BI) solutions.
-
Implement ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS).
-
Validate, cleanse, and manage data using Data Quality Services (DQS) and Master Data Services (MDS).
-
Implement Azure SQL Data Warehouse and integrate it with BI solutions.
-
Deploy and configure SSIS packages and manage data extraction processes.
-
Optimize data warehouse performance using techniques such as Columnstore indexes.
Course Outline
Module 1: Introduction to Data Warehousing
-
Data warehouse concepts and architecture
Module 2: Planning Data Warehouse Infrastructure
-
Planning and designing infrastructure for data warehousing
Module 3: Designing and Implementing a Data Warehouse
-
Data warehouse schema and implementation
Module 4: Column store Indexes
-
Performance optimization using columnstore indexes
Module 5: Implementing Azure SQL Data Warehouse
-
Deploying and configuring Azure-based data warehouse solutions
Module 6: Creating an ETL Solution
-
Designing ETL processes using SSIS
Module 7: Implementing Control Flow in SSIS
-
Creating control flow and workflow logic in SSIS packages
Module 8: Debugging and Troubleshooting SSIS Packages
-
Identifying and resolving issues in ETL processes
Module 9: Implementing Data Extraction Solutions
-
Extracting and transforming data from multiple sources
Module 10: Enforcing Data Quality
-
Using Data Quality Services (DQS)
Module 11: Using Master Data Services
-
Managing master data and maintaining data consistency
Module 12: Extending SQL Server Integration Services
-
Customizing SSIS functionality
Module 13: Deploying and Configuring SSIS Packages
-
Managing deployment and configuration
Module 14: Consuming Data in a Data Warehouse
-
Accessing and using data for reporting and BI solutions
