Accelerated SQL Server 2012-2016 Integration Services

Course Summary

Training levelBI Course
Duration2 days / 16 Hours
Delivery methodIn Class
List price550 Euro VAT Excl.

Click Tabs for Detailed info

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

  • 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 dimension and cubes
  • Module 1: SSIS Overview and Core Features
  • Module 2: SSIS Control Flow Objects and Features
  • Module 3: Applying Data Flow Transformations and Adapters
  • Module 4: Working with and Importing Files
  • Module 5: Data Source Extraction and Destination Optimization
  • Module 6: Data Quality and Cleansing
  • Module 7: Dimension ETL with SSIS
  • Module 8: Fact ETL with SSIS
  • Module 9: Processing Tabular and Multidimensional SSAS Objects in SSIS
  • Module 10: Project Deployment Model: Configuration, Deployment & Security
  • Module 11: Project Deployment Model: Execution and Reporting
  • Module 12: Package Deployment Model: Configuration and Deployment
  • Module 13: Package Deployment Model: Execution, Security & Logging
  • Module 14: Transactions and Restartability
  • Module 15: Optimization and Scalability
  • Module 16: Solution Approach and Team Development

Next planned dates

Trainer: Matija Lah


Reserve your seat

Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date