Microsoft SQL Server 2012 Integration Services

4 days

Course Overview

This 4 day course is intended for IT professionals, business analysts, and developers who need to implement data transfer, or ETL (Extract, Transform, and Load), solutions by using Microsoft SQL Server 2012 Integration Services. Students will learn about the SQL Server Data Tools (SSDT) development environment to create SSIS projects and packages, work with Control Flow Tasks, and design Data Flows using a variety of transformations and data sources/destinations (including SQL Server databases, flat files, and Excel). Delegates will also learn about SSIS project and package management, deployment, debugging, error handling, and logging techniques. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises.

With the course structure being fully modularised, customised versions of this course can also be devised and delivered. For example, clients interested in only the essentials of SSIS could attend just the first 3 days of the course, omitting the Advanced SSIS Concepts ordinarily covered on day 4.

Course Objectives

Understand the Role SQL Server Integration Services Plays in Business Intelligence

Create and Develop Integration Services Projects and Packages in SSDT

Understand and Implement Control Flow Tasks

Understand and Implement Data Flow Transforms and Components

Implement Logging

Debug and Implement Error Handling

Implement Checkpoints and Transactions

Deploy Integration Services Projects

Manage and Secure Integration Services Projects and Packages

Understand Basic Data Warehousing Concepts

Manage Changing Data with the SSIS CDC Components

Understand the Role of Data Quality Services (DQS)

Understand the Role of Master Data Services (MDS)

Prerequisites

No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalization. Some prior working knowledge of SQL Server 2012, and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT, UPDATE, INSERT, and DELETE statements.