Advanced SQL Server 2005/2008/2008 R2 Integration Services (SSIS) & Performance

Course Code: SQSAIS
Duration: 4 days
Level: Advanced
Audience: SQL Server developers and DBAs.
Prerequisites: Completion of our course SQL Server 2005/2008/2008 R2 Integration Services Fundamentals or equivalent knowledge.
Summary: As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more common and complex requirements, including:
  • Source-to-destination mapping
  • Change Data Capture (CDC)
  • Extraction (e.g., incremental)
  • Staging tables
  • Slowly Changing Dimensions
  • Late arriving (inferred) dimensions
  • Late arriving facts
  • Fact aggregation
  • Data profiling
  • Advanced transformations (synchronous vs. asynchronous)
  • Pipeline (data flow) performance & tuning
  • Partitioned tables (in data warehouses)
  • Partition maintenance
Objectives: Upon completion of this course, the delegate should be able to use a variety of SSIS control and data flow facilities to design, develop, maintain and tune a diverse mix of complex SSIS package solutions.
Format: Lecture and hands-on.
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page