Accelerated SQL Server 2012 / 2014 Integration Services (SQAIS)



This 4-day instructor led training focuses on developing and managing SSIS 2012/2014 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.


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.


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.


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

Module 05 - Data Source Extraction and Destination Optimization

  • Extraction optimization
  • Incremental extraction and Change Data Capture
  • Data loading optimization
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
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

Module 09 - Processing Tabular and Multidimensional SSAS Objects in SSIS

  • SSAS tabular and multidimensional
  • Processing methods in SSIS
  • Dynamic processing and partition creation
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

Module 11 - Project Deployment Model: Execution and Reporting

  • Project deployment model utilities
  • Package execution with T-SQL and DTExec
  • Server reporting and logging
Day 4
Section E: Package Deployment Model

Module 12 - Package Deployment Model: Configuration and Deployment

  • Package deployment model
  • Package configurations
  • Deploying packages

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

  • Package deployment model utilities
  • Package execution
  • Package security and encryption
  • Package logging
Section F: SSIS Solution and Performance Considerations

Module 14 - Transactions and Restartability

  • SSIS transactions
  • SQL Server database snapshots
  • Restartability with checkpoints
  • Debugging with breakpoints
  • Event Handlers

Module 15 – Optimization and Scalability

  • SQL code versus SSIS pipeline
  • Data flow engine internals
  • General optimization techniques
  • Performance root-cause analysis

Module 16 - Solution Approach and Team Development

  • Modular and parent package design
  • Team development considerations
Classroom Training

Dauer 4 Tage

Preis (exkl. MwSt.)

Sprache der Kursunterlagen: englisch


Derzeit gibt es keine Trainingstermine für diesen Kurs.  Termin anfragen