Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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