Implementing a Server 2016 SQL Data Warehouse

  • Course Code: MS20767
  • Course Location: Columbia, SC
  • $2500
  • Get Started

Schedule

Sorry No Events

Audience

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.

Objective

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.

Outline

Module 1: Introduction to Data Warehousing Module 2: Planning Data Warehouse Infrastructure Module 3: Designing and Implementing a Data Warehouse Module 4: Columnstore Indexes Module 5: Implementing an Azure SQL Data Warehouse Module 6: Creating an ETL Solution Module 7: Implementing Control Flow in an SSIS Package Module 8: Debugging and Troubleshooting SSIS Packages Module 9: Implementing a Data Extraction Solution Module 10: Enforcing Data Quality Module 11: Using Master Data Services Module 12: Extending SQL Server Integration Services (SSIS) Module 13: Deploying and Configuring SSIS Packages Module 14: Consuming Data in a Data Warehouse