We are happy to advise you!
0845 470 1000     Contact

Instructor-Led Online Training (ILO)
Live Online Classes in the Virtual Classroom

Find out more and view dates

Implementing a Data Warehouse with Microsoft SQL Server (20463)

 

Course Overview

This course covers implementation of a data warehouse platform to support a BI solution. Topics covered include creating a data warehouse with Microsoft SQL Server 2014, implementing ETL with SQL Server Integration Services, and validating and cleansing data with SQL Server Data Quality Services and SQL Server Master Data Services.

Who should attend

Database professionals who need to create and support a data warehousing solution. Primary responsibilities include:

  • Implementing a data warehouse.
  • Developing SSIS packages for data extraction, transformation, and loading.
  • Enforcing data integrity by using Master Data Services.
  • Cleansing data by using Data Quality Services.

Certifications

Prerequisites

  • At least 2 years of experience working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Course Objectives

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.
Online Training

Duration 5 days

Price (excl. VAT)
  • £ 2,590.-
  • SA Voucher: 5
    hardcoded default SA
Classroom Training

Duration 5 days

Price (excl. VAT)
  • United Kingdom: £ 2,590.-
  • SA Voucher: 5
    hardcoded default SA

Schedule

This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
English
Time zone BST
23/11/2020 ― 27/11/2020 Online Training Time zone: GMT
18/01/2021 ― 22/01/2021 Online Training Time zone: GMT
22/03/2021 ― 26/03/2021 Online Training Time zone: GMT
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
United Kingdom
23/11/2020 ― 27/11/2020 Virtual This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
18/01/2021 ― 22/01/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
22/03/2021 ― 26/03/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training