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
Constructing Data Flows
- An overview of data flow tasks and transformation components
- Managing data sources and destinations
- Applying standard data transformations
- Resolving data quality challenges
SSIS Control Flow Mechanics
- Comprehending control flow tasks
- Utilizing containers to regulate control flow
- Incorporating loops and conditional logic
- Directing the overall package execution sequence
Sophisticated Data Transformation Strategies
- Deploying advanced transformation tools
- Techniques for data cleansing, validation, and enrichment
- Methods for aggregation and summarization
- Detailed implementation of Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Fundamentals of variables and parameters
- Leveraging variables to dictate package behavior
- Configuring package properties dynamically
Overseeing SSIS Package Execution
- Setting up package execution options
- Strategies for error handling and logging
- Employing event handlers to address runtime events
- Automating and scheduling execution via SQL Server Agent
Deploying and Administering SSIS Packages
- Exploring deployment models in SQL Server 2022
- Installing packages into the SSIS catalog
- Tracking performance and debugging deployed packages
Performance Tuning and Optimization
- Detecting and mitigating performance bottlenecks
- Best practices for refining data and control flows
- Leveraging parallelism and batch processing in SSIS
Conclusion and Future Directions
Requirements
- A foundational grasp of SQL and relational database principles
- Experience with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Developers
- Database administrators