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

Exciting News
We’re merging with Access Training!

We're excited to announce that MTC Training is now merging with Access Training, to create a more powerful, innovative, and accessible training experience. For updates on this exciting next chapter follow @Access Training

From the 1st April 2025 this website will no longer be managed, please use the Access Training website

MTC Training
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.