Implementing a SQL Data Warehouse

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)


Download PDF of Course Details

Course Description

This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure as well as installing from new and migrating from an existing install. The primary audience for this course is database professionals who need to fulfill 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.

Course Objectives

  • 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

Audience

  • For individuals who administer and maintain SQL Server databases