Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) Training Course

Learn How To Implement A Data Warehouse Platform To Support A BI Solution

Introduction

The five day Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course will show you how to implement a data warehouse platform to support a BI solution. The training course is designed for those who are interested in learning SQL Server 2012 or SQL Server 2014 and covers the new features in SQL Server 2014 but also the important capabilities across the SQL Server data platform.

Please Note

You can book this course and hold it in credit until you have decided on a specific course date. Alternatively, please view our other course dates.
Exam Not Included
5 Days
£2345Excl. VAT

Course Outline

Module 1: Introduction To Data Warehousing

Overview Of Data Warehousing

Considerations For A Data Warehouse Solution

Lab: Exploring A Data Warehousing Solution

Module 2: Data Warehouse Hardware Considerations

Considerations For Building A Data Warehouse

Data Warehouse Reference Architectures And Appliances

Lab: Planning Data Warehouse Infrastructure

Module 3: Designing And Implementing A Data Warehouse

Logical Design For A Data Warehouse

Physical design For A Data warehouse

Lab: Implementing A Data Warehouse Schema

Module 4: 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

Module 5: 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

Module 6: 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

Module 7: Implementing An Incremental ETL Process

Introduction To Incremental ETL

Extracting Modified Data

Loading Modified Data

Lab: Extracting Modified

DataLab: Loading Incremental Changes

Module 8: Enforcing Data Quality

Introduction To Data Quality

Using Data Quality Services To Cleanse Data

Using Data Quality Services To Match Data

Lab: Cleansing

DataLab: De-Duplicating Data

Module 9: Using Master Data Services

Master Data Services Concepts

Implementing A Master Data Services Model

Managing Master Data

Creating A Master Data Hub

Lab: Implementing Master Data Services

Module 10: Extending SQL Server Integration Services

Using Scripts In SSIS

Using Custom Components In SSIS

Lab: Using Custom Components And Scripts

Module 11: Deploying And Configuring SSIS Packages

Overview Of SSIS Deployment

Deploying SSIS Projects

Planning SSIS Package Execution

Lab: Deploying And Configuring SSIS Packages

Module 12: Consuming Data In A Data Warehouse

Introduction To Business Intelligence

Introduction To Reporting

An Introduction To Data Analysis

Lab: Using Business Intelligence Tools

Description

You 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.

  • 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 A 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

About the Course

This interactive training session can be taken from any location, your office or home and is delivered virtually by a tutor. Virtual students do not need to travel for the training course and Purple Griffon will send you all of the information needed before the start of the training course so you can test your login details.

Who Should Attend

The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course is intended for 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. 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

Materials Provided

  • Full Materials Including Comprehensive Course Workbook
  • Highly Skilled And Knowledgeable Tutors
  • Refreshments

Organisational Benefits

Security: SQL Server provides two security models including integration with Windows Authentication to provide robust security platform for managing your organisations information. Security can be managed across all database objects including tables, views, stored procedures and at a very granular level, to provide complete information security. Database encryption is now available as well to secure SQL Server database at rest.

Scalability: SQL Server is a highly scalable enterprise database platform capable of managing petabytes of data while delivery high performance. This allows organisations to deploy SQL Server databases with the confidence that SQL Server can continue to deliver superior performance even as their needs and businesses grow.

High Availability/Failover: SQL Server provides a variety of high availability features including fail over clustering available on the Standard and Enterprise editions, database mirroring, log shipping, and database snapshots to meet your organisations' needs.

Business Intelligence: SQL Server Standard and Enterprise Editions come with extensive business intelligence capabilities through SQL Server Analysis Services. Analytical models can be developed to breakdown business information to provide business insights for managing and forecasting business needs. SQL Server also comes with integrated reporting capabilities from SQL Server Reporting Services which allows organisations to access business critical information across the organisation. In more recent versions of SQL Server, PowerPivot for Microsoft Excel has been added to allow users another familiar tool for analysing business data.

Integration: SQL Server provides a robust set of integration tools call SQL Server Integration Services (SSIS) which can be used consolidate data from multiple heterogenous data sources for holistic data view and comprehensive data analysis. SSIS can also be used to migrate data from other database formats (Oracle, DBase, Paradox, legacy formats, Microsoft Access) to SQL Server.

Individual Benefits

The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course will keep your personal or professional skills up to date.

Prerequisites

The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course requires you to have at least two years’ experience of working with relational databases, including:

  • Designing A Normalised Database
  • Creating Tables And Relationships
  • Querying With Transact-SQL
  • Some Exposure To Basic Programming Constructs (Such As Looping/Branching)
  • An Awareness Of Key Business Priorities Such As Revenue, Profitability And Financial Accounting Is Desirable

Prereading

There is no official prereading with the Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training session.

Exam Overview

The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course helps you prepare for the Microsoft Implementing a Data Warehouse With Microsoft SQL Server 2012/2014 examination. The examination measures your ability to accomplish the technical tasks listed below:

  • Design And Implement A Data Warehouse
  • Extract And Transform Data
  • Load Data
  • Configure And Deploy SSIS Solutions
  • Build Data Quality Solutions

Exam Type

Classroom Exam

Professional Development Units - PDUs

The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course will give you credit towards the MCP, MCSA, MCSE certifications.

Qualifications

Data Warehouse With Microsoft SQL Server 2012/2014 Certification

Next Steps

The five day Implementing Data Models & Reports With SQL Server 2014 training course focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

Conclusion

The Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) training course is part of the Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification or MCSD Certification.

Implementing A Data Warehouse With Microsoft SQL Server® (SSIS) Course Dates

Course Filter


DD/MM/YYY - e.g. 31/12/2015
Showing 0 to 0 of 0 Total Course Dates.

Oops!

There are currently no course dates that match your selected filter options. Please try another filter or contact one of our dedicated account managers on +44(0)1539 736 828 to discuss your requirements. Thanks.

Scroll Table to View Content