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
- Foundations of data flow tasks and transformations
- Integrating data sources and destinations
- Applying standard data transformation methods
- Mitigating data quality challenges
Control Flow Mechanics in SSIS
- Comprehending control flow tasks
- Leveraging containers to orchestrate control flow
- Incorporating loops and conditional logic
- Regulating the execution path of packages
Sophisticated Data Transformation Strategies
- Utilizing advanced transformation tools
- Data cleansing, validation, and enrichment processes
- Methods for aggregation and summarization
- Detailed implementation of Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Basics of variables and parameters
- Controlling package dynamics through variables
- Dynamic adjustment of package properties
Orchestrating SSIS Package Execution
- Setting execution configurations
- Implementing error handling and logging protocols
- Managing runtime events via event handlers
- Automating scheduling with SQL Server Agent
Deployment and Package Administration
- Deployment models specific to SQL Server 2022
- Publishing packages to the SSIS catalog
- Monitoring and diagnosing deployed solutions
Performance Tuning and Optimization
- Detecting and resolving performance bottlenecks
- Best practices for optimizing data and control flows
- Implementing parallelism and batch processing in SSIS
Wrap-Up and Future Directions
Requirements
- Fundamental knowledge of SQL and relational database concepts
- Proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Developers
- Database administrators
