Get in Touch
 Duration 14 hours

Course Outline

Architecting Data Flows

  • Foundations of data flow tasks and transformation logic
  • Connecting to diverse data sources and destinations
  • Applying standard data transformation methods
  • Mitigating common data quality challenges

SSIS Control Flow Mechanics

  • Decoding control flow tasks and their functions
  • Utilizing containers to structure execution paths
  • Implementing iterative loops and conditional branching
  • Orchestrating the overall package execution sequence

Advanced Transformation Strategies

  • Leveraging specialized transformation components
  • Techniques for data cleansing, validation, and enrichment
  • Methods for aggregation and data summarization
  • In-depth implementation of Slowly Changing Dimensions (SCD)

Leveraging Variables and Parameters

  • Core concepts of variables and parameters in SSIS
  • Using variables to dynamically control package behavior
  • Achieving dynamic configuration of package properties

Governing Package Execution

  • Tuning package execution settings for optimal performance
  • Strategies for error handling and comprehensive logging
  • Employing event handlers to respond to runtime events
  • Automating schedules via SQL Server Agent

Deployment and Lifecycle Management

  • Exploring deployment models in SQL Server 2022
  • Installing packages into the SSIS catalog
  • Techniques for monitoring and resolving issues in deployed packages

Optimizing Performance

  • Diagnosing and resolving performance bottlenecks
  • Best practices for enhancing data and control flow efficiency
  • Utilizing parallelism and batch processing for scale

Conclusion and Future Pathways

Requirements

  • Foundational knowledge of SQL and relational database principles
  • Practical familiarity with SQL Server Management Studio (SSMS)

Target Audience

  • Data specialists
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories