20767C – Implementing a SQL Data Warehouse

20767C

Overview

About the course

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, and covers installing from new and migrating from an existing install.

Audience Profile

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.

Course Details

  • Course Ref: 20767C
  • Course Duration: 5 days
  • Course Location: Sunderland
  • Course Dates: TBC
  • Course Price: £1,995 (Excl VAT)

Modules

  • Introduction to Data Warehousing
  • Planning Data Warehouse Infrastructure
  • Designing and Implementing a Data Warehouse
  • Columnstore Indexes
  • Implementing an Azure SQL Data Warehouse
  • Creating an ETL Solution
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing a Data Extraction Solution
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services (SSIS)
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Course Outline