20463 Implementing a Data Warehouse with Microsoft® SQL Server®

Displaying courses for Great Britain [Change]
This course provides material for:
Microsoft Exam code: 70-463
Certificate: MCSA: SQL Server

Overview

Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Objectives

After completing this course, students will be able to:
  • 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.

Audience

This course is intended for 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.

Syllabus

Introduction to Data Warehousing

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Lab : Exploring a Data Warehousing Solution

Planning Data Warehouse Infrastructure

  • Considerations for Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware
  • Lab : Planning Data Warehouse Infrastructure

Designing and Implementing a Data Warehouse

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Designing Fact Tables
  • Physical Design for a Data Warehouse
  • Lab : Implementing a Data Warehouse

Creating an ETL Solution with SSIS

  • Introduction to ETL with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Lab : Implementing Data Flow in an SSIS Package

Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • Lab : Implementing Control Flow in an SSIS Package
  • Lab : Using Transactions and Checkpoints

Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Lab : Debugging and Troubleshooting an SSIS Package

Implementing a Data Extraction Solution

  • Planning Data Extraction
  • Extracting Modified Data
  • Lab : Extracting Modified Data

Loading Data into a Data Warehouse

  • Planning Data Loads
  • Using SSIS for Incremental Loads
  • Using Transact-SQL Loading Techniques
  • Lab : Loading a Data Warehouse

Enforcing Data Quality

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Cleanse Data
  • Lab : Cleansing Data

Master Data Services

  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab : Implementing Master Data Services

Extending SQL Server Integration Services

  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Lab : Using Custom Scripts

Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Lab : Deploying and Configuring SSIS Packages

Consuming Data in a Data Warehouse

  • Introduction to Business Intelligence
  • Enterprise Business Intelligence
  • Self-Service BI and Big Data
  • Lab : Using a Data Warehouse

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft SQL Server
Great Britain
This skill has an average salary of
£50,793
and is mentioned in
1.68%
of job ads in this area.
Data warehouse
Great Britain
This skill has an average salary of
£53,722
and is mentioned in
0.56%
of job ads in this area.
SQL
Great Britain
This skill has an average salary of
£50,207
and is mentioned in
4.87%
of job ads in this area.
Business intelligence
Great Britain
This skill has an average salary of
£51,927
and is mentioned in
1.15%
of job ads in this area.