Course Details
Course Outline
1 - Introduction to Data Warehousing
Gain an Introduction to Data WarehousingConsider Factors Involved in a Data Warehouse SolutionLab: Exploring a Data Warehouse Solution
2 - Planning Data Warehouse Infrastructure
Review Considerations for Building a Data WarehousePlan Data Warehouse HardwareLab: Planning Data Warehouse Infrastructure
3 - Designing and Implementing a Data Warehouse
Design Dimension Tables and Fact TablesDetermine Physical Design for a Data WarehouseLab: Implementing a Data Warehouse Schema
4 - ColumnStore Indexes
Review Columnstore IndexesCreate and Work with Columnstore IndexesLab: Using Columnstore Indexes
5 - Implementing an Azure SQL Data Warehouse
Understand the Advantages of Azure SQL Data WarehouseImplement an Azure SQL Data WarehouseDevelop an Azure SQL Data WarehouseMigrate to an Azure SQL Data WarehouseCopy Data with the Azure Data FactoryLab: Implementing an Azure SQL Data Warehouse
6 - Creating an ETL Solution
Gain an Introduction to ETL with SSISExplore Source DataImplement Data FlowLab: Implementing Data Flow in an SSIS Package
7 - Implementing Control Flow in an SSIS Package
Introduce Control FlowCreate Dynamic PackagesAdopt ContainersLab: Implementing Control Flow in an SSIS PackageLab: Using Transactions and Checkpoints
8 - Debugging & Troubleshooting SSIS Packages
Debug an SSIS PackageLog SSIS Package EventsHandle Errors in an SSIS PackageLab: Debugging and Troubleshooting an SSIS Package
9 - Implementing a Data Extraction Solution
Navigate Incremental ETLExtract and Load Modified DataManage Temporal TablesLab: Extracting Modified DataLab: Loading Incremental Changes
10 - Enforcing Data Quality
Apply Data Quality Services to Cleanse DataUse Data Quality Services to Match DataLab: Cleansing DataLab: De-Duplicating Data
11 - Using Master Data Services
Become Familiar with Master Data Services Execute a Master Data Services ModelCreate a Master Data HubLab: Implementing Master Data Services
12 - Extending SQL Server Integration Services (SSIS)
Utilize Custom Components in SSISPerform Scripting in SSISLab: Using Scripts and Custom Components
13 - Deploying and Configuring SSIS Packages
Review SSIS DeploymentDeploy SSIS ProjectsPlan SSIS Package ExecutionLab: Deploying and Configuring SSIS Packages
14 - Consuming Data in a Data Warehouse
Understand Basic Concepts of Business Intelligence, Reporting and Data AnalysisAnalyze Data with Azure SQL Data WarehouseLab: Using Business Intelligence Tools
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
If you are a database professional looking to further your career in business intelligence development, this course is ideal for you. It will also benefit you if you’re responsible for data warehouse implementation, ETL or data cleansing in your day-to-day role.
Other Prerequisites
Your success is our top priority. To ensure you’re fully prepared for the course material, you should have at least two years of professional experience working with relational databases. You should also have basic knowledge of the Windows operating system and foundational database design skills.