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
- Introduction to data flow tasks and transformation components
- Managing data sources and destinations
- Applying standard data transformations
- Mitigating data quality challenges
Control Flow Mechanics in SSIS
- Analyzing control flow tasks
- Leveraging containers to orchestrate control flow
- Constructing loops and conditional logic structures
- Overseeing package execution sequences
Advanced Data Transformation Methods
- Utilizing specialized transformation tools
- Performing data cleansing, validation, and enrichment
- Techniques for aggregation and summarization
- In-depth implementation of Slowly Changing Dimensions (SCD)
Leveraging Variables and Parameters
- Concepts of variables and parameters
- Directing package behavior through variables
- Dynamically configuring package properties
Orchestrating SSIS Package Execution
- Configuring execution parameters
- Strategies for error handling and logging
- Managing runtime events via event handlers
- Automating scheduling with SQL Server Agent
Deployment and Administration of SSIS Packages
- Deployment strategies in SQL Server 2022
- Integrating packages into the SSIS catalog
- Monitoring and diagnosing deployed solutions
Performance Optimization and Tuning
- Diagnosing and resolving performance constraints
- Best practices for optimizing data and control flows
- Implementing parallelism and batch processing
Wrap-up and Future Pathways
Requirements
- Fundamental grasp of SQL and relational database principles
- Proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data specialists
- Software developers
- Database administrators