Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Fundamentals of data flow tasks and transformation components
  • Integrating various data sources and destinations
  • Applying standard data transformation techniques
  • Addressing and resolving data quality concerns

Control Flow in SSIS

  • Grasping the concepts behind control flow tasks
  • Leveraging containers to organize control flow
  • Building loops and implementing conditional logic
  • Orchestrating the execution flow of packages

Advanced Data Transformation Techniques

  • Utilizing sophisticated transformation tools
  • Performing data cleansing, validation, and enrichment
  • Employing methods for aggregation and summarization
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • Foundations of variables and parameters
  • Utilizing variables to dictate package behavior
  • Dynamically configuring package properties

Managing SSIS Package Execution

  • Setting execution options for packages
  • Developing error handling and logging strategies
  • Utilizing event handlers for runtime event management
  • Scheduling and automating runs via SQL Server Agent

Deploying and Managing SSIS Packages

  • Exploring deployment models in SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring and diagnosing issues with deployed packages

Performance Tuning and Optimization

  • Pinpointing and resolving performance bottlenecks
  • Adopting best practices for data and control flow optimization
  • Leveraging parallelism and batch processing in SSIS

Summary and Next Steps

Requirements

  • Fundamental knowledge of SQL and relational database principles
  • Working proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories