Get in Touch
 Duration 14 hours

Course Outline

Architecting Data Flows

  • An overview of data flow tasks and associated transformations
  • Configuring data sources and destinations
  • Applying standard data transformations
  • Mitigating data quality challenges

Control Flow Management in SSIS

  • Gaining insight into control flow tasks
  • Utilizing containers to regulate control flow
  • Constructing loops and conditional logic
  • Orchestrating package execution sequences

Advanced Transformation Methods

  • Leveraging advanced transformation features
  • Performing data cleansing, validation, and enrichment
  • Applying aggregation and summarization strategies
  • Deep-dive into implementing Slowly Changing Dimensions (SCD)

Managing Variables and Parameters

  • Foundations of variables and parameters
  • Directing package behavior through variables
  • Dynamic adjustment of package properties

Orchestrating SSIS Package Execution

  • Setting execution options for packages
  • Formulating error handling and logging protocols
  • Handling runtime events via event handlers
  • Automating and scheduling runs with SQL Server Agent

Deployment and Maintenance of SSIS Packages

  • Reviewing deployment models specific to SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring and diagnosing deployed packages

Performance Optimization and Tuning

  • Detecting and resolving performance bottlenecks
  • Adopting best practices for optimizing data and control flows
  • Leveraging parallelism and batch processing within SSIS

Recap and Future Directions

Requirements

  • A solid grasp of SQL and relational database principles
  • Comfort with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories