0345 4506120

Accelerated SQL Server 2016 Integration Services

This 4-day instructor led training focuses on developing and managing SSIS 2012 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS solutions—this involves ETL solutions (extraction, transformation, and loading) from source systems extractions, data integration, SSIS server administration and package execution.

Who should attend?

This course is intended for database professionals that are responsible for ETL or DBA activities related to data processing, data architecture planning, or SSIS administration.

The target audience for this session is IT professionals, DBAs and developers who want to learn the details of how to use SSIS to accomplish data integration, data warehouse loading, and how to administer SSIS through the development lifecycle to production.

Learning Objectives

Delegates will learn how to                    

  •   Create and develop new SSIS projects and packages
  •   Determine when to use project mode versus package mode
  •   Apply SSIS to file and data management
  •   Understand and Apply ETL Concepts in SSIS including dimensions and fact table ETL and loading SSAS dimens on and cubes
  •   Administer SSIS for server deployment and production execution

Pre-Requisites

This course is targeted at database professionals and developers with some experience in business intelligence solutions and SQL Server.

  •   This workshop requires no prior experience with SQL Server SSIS.

Course Content

Day 1

Section A: SSIS Overview and Core Features

Module 01 - SSIS Overview and Core Features

  •   How SSIS fits into the corporate data network and infrastructure
  •   Introduction to data integration, BI, and dimensional modeling
  •   SSIS features overview
  •   SQL Server 2012 tools
  •   Control flow and data flow principles
  •   Control flow features
  •   Containers
  •   SSIS expression language
  •   Tasks and constraints
  •   Data flow introduction and design environment
  •   Connecting the data flow to sources and destinations
  •   Transformations and paths

Lab 03: Working with Data in the Data Flow

Day 2

Section B: Applying SSIS to Common Operations

Module 04 - Working With and Importing Files

  •   File-handling requirements and management
  •   Working with binary data
  •   Excel and 64-bit considerations
  •   Third-party custom components
  •   Extraction optimization
  •   Incremental extraction and Change Data Capture
  •   Data loading optimization
  •   Data profiling and cleansing basics
  •   Fuzzy operations
  •   Fuzzy Lookup
  •   Fuzzy Grouping
  •   Text mining
  •   Script component
  •   Data Quality Services
  •   Fact table ETL theory
  •   Fact loading concepts, columns, and mappings
  •   Workflow, precedence, and staging
  •   Identifying dimension surrogate keys
  •   Data preparation for fact tables
  •   Advanced concepts

Lab 07: Dimension Table ETL

Day 3

Module 08 - Fact ETL with SSIS

  •   Fact types and theory, Aspects of the fact table processing, Dimension lookups with the Lookup transformation, Missing Dimension Members, Measures and Calculations, Handling fact inserts and updates, Changing data grain, Processing Analysis Services Measure Group Partitions

Lab 08: Fact Table ETL

Module 09 - Processing Tabular and Multidimensional SSAS Objects in SSIS

  •   SSAS tabular and multidimensional
  •   Processing methods in SSIS
  •   Dynamic processing and partition creation Lab 09: Analysis Services Processing Section D: Project Deployment Model

Module 10 - Project Deployment Model: Configuration, Deployment & Security

  •   Project Deployment Model
  •   SSIS catalog features
  •   Project and package connections
  •   Project and package parameters
  •   Project Deployment Wizard
  •   SSIS environments
  •   Security and encryption

Lab 10: SSIS Catalog Configurations and Project Deployment

Module 11 - Project Deployment Model: Execution and Reporting

  •   Project deployment model utilities
  •   Package execution with T-SQL and DTExec
  •   Server reporting and logging

Lab 11: Executing Packages in the SSIS Catalog

Day 4

Section E: Package Deployment Model

Module 12 - Package Deployment Model: Configuration and Deployment

  •   Package deployment model
  •   Package configurations
  •   Deploying packages

Lab 12: Working with Package Configurations

Module 13 - Package Deployment Model: Execution, Security & Logging

  •   Package deployment model utilities
  •   Package execution
  •   Package security and encryption
  •   Package logging
  •   SSIS transactions
  •   SQL Server database snapshots
  •   Restartability with checkpoints
  •   Debugging with breakpoints
  •   SQL code versus SSIS pipeline
  •   Data flow engine internals
  •   General optimization techniques
  •   Performance root-cause analysis

Lab 15: Identifying and Resolving SSIS Performance Issues

Module 16 - Solution Approach and Team Development

  •   Modular and parent package design
  •   Team development considerations Lab 16: Creating a Parent Package

We reserve the right to improve the specification and format of our courses for the benefit of our customers without notice to the customer.

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include