Accelerated SQL Server 2012 Integration Services

  • Duration: 4 days
  • Our price: from £2,123 per person

Course overview:

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.

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.

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.

Training Course Overview/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
Lab 01: SSIS Development Environment Introduction

Module 02 - SSIS Control Flow Objects and Features

Control flow and data flow principles
Control flow features
Containers
SSIS expression language
Tasks and constraints
Lab 02: Workflow Management in the Control Flow

Module 03 - Applying Data Flow Transformations and Adapters

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
Lab 04: Importing and Processing FTP Sourced Files

Module 05 - Data Source Extraction and Destination Optimization

Extraction optimization
Incremental extraction and Change Data Capture
Data loading optimization
Lab 05: Incremental Extraction and ODBC Sources

Module 06 - Data Quality and Cleansing

Data profiling and cleansing basics
Fuzzy operations
Fuzzy Lookup
Fuzzy Grouping
Text mining
Script component
Data Quality Services
Lab 06: Comparing the Fuzzy Lookup and DQS Cleansing Transformations

Section C: Applying SSIS in BI and Data Warehouse Solutions

Module 07 - Dimension ETL with SSIS

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
Lab 13: Package Logging and Execution

Section F: SSIS Solution and Performance Considerations

Module 14 - Transactions and Restartability

SSIS transactions
SQL Server database snapshots
Restartability with checkpoints
Debugging with breakpoints
Lab 14: Working with Transactions and Checkpoints

Module 15 - Optimization and Scalability

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 developm

This course is running at the following venues:

3rd Floor, International House, London, E1W 1UN

Can’t find your perfect course? Contact us for help