Get in Touch
 Duration 14 hours

Course Outline

Data Flow Design

  • Overview of data flow tasks and transformations
  • Managing data sources and destinations
  • Applying standard data transformations
  • Addressing data quality challenges

SSIS Control Flow

  • Comprehending control flow tasks
  • Utilizing containers to organize control flow
  • Implementing loops and conditional logic
  • Regulating package execution flow

Advanced Data Transformation Methods

  • Applying advanced transformations
  • Data cleansing, validation, and enrichment
  • Techniques for aggregation and summarization
  • In-depth implementation of Slowly Changing Dimensions (SCD)

Managing Variables and Parameters

  • Introduction to variables and parameters
  • Controlling package behavior through variables
  • Dynamic configuration of package properties

SSIS Package Execution Management

  • Setting up package execution options
  • Error handling and logging methodologies
  • Managing runtime events with event handlers
  • Scheduling and automating execution via SQL Server Agent

SSIS Package Deployment and Administration

  • Deployment models in SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring and troubleshooting deployed packages

Performance Tuning and Optimization

  • Identifying and resolving performance bottlenecks
  • Best practices for optimizing data and control flows
  • Parallelism and batch processing in SSIS

Summary and Future Steps

Requirements

  • A foundational understanding of SQL and relational database concepts
  • Proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 3200 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories