Technology: SQL Server
Software Assurance Value:
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
After completing this course, students will be able to:
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
Module 1: Introduction to Data Warehousing
Describe data warehouse concepts and architecture considerations.
Lab: Exploring a Data Warehouse Solution
After completing this module, you will be able to:
Module 2: Planning Data Warehouse Infrastructure
This module describes the main hardware considerations for building a data warehouse.
Lab: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
This module describes how you go about designing and implementing a schema for a data warehouse.
Lab: Implementing a Data Warehouse Schema
Module 4: Columnstore Indexes
This module introduces Columnstore Indexes.
Lab: Using Columnstore Indexes
Module 5: Implementing an Azure SQL Data Warehouse
This module describes Azure SQL Data Warehouses and how to implement them.
Lab: Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
At the end of this module you will be able to implement data flow in a SSIS package.
Lab: Implementing Data Flow in an SSIS Package
Module 7: Implementing Control Flow in an SSIS Package
This module describes implementing control flow in an SSIS package.
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints
Module 8: Debugging and Troubleshooting SSIS Packages
This module describes how to debug and troubleshoot SSIS packages.
Lab: Debugging and Troubleshooting an SSIS Package
Module 9: Implementing an Incremental ETL Process
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.
Lab: Extracting Modified Data
Lab: Loading Incremental Changes
Module 10: Enforcing Data Quality
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lab: Cleansing Data
Lab: De-duplicating Data
Module 11: Using Master Data Services
This module describes how to implement master data services to enforce data integrity at source.
Lab: Implementing Master Data Services
Module 12: Extending SQL Server Integration Services (SSIS)
This module describes how to extend SSIS with custom scripts and components.
Lab: Using Scripts and Custom Components
Module 13: Deploying and Configuring SSIS Packages
This module describes how to deploy and configure SSIS packages.
Lab: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse
Lab: Using Business Intelligence Tools
This course requires that you meet the following prerequisites: