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
- Insight into data flow tasks and transformation mechanisms
- Managing data sources and destinations
- Applying standard data transformation techniques
- Mitigating data quality challenges
SSIS Control Flow
- Comprehending control flow tasks
- Leveraging containers to regulate control flow
- Integrating loops and conditional logic
- Orchestrating package execution sequences
Advanced Transformation Strategies
- Utilizing advanced transformation capabilities
- Data cleansing, validation, and enrichment processes
- Techniques for aggregation and summarization
- Detailed implementation of Slowly Changing Dimensions (SCD)
Variables and Parameters in Practice
- Foundations of variables and parameters
- Controlling package behavior via variables
- Dynamically configuring package properties
Executing SSIS Packages
- Setting package execution parameters
- Strategies for error handling and logging
- Employing event handlers for runtime event management
- Automation and scheduling via SQL Server Agent
Deployment and Administration
- Deployment architectures in SQL Server 2022
- Installing packages into the SSIS catalog
- Oversight and troubleshooting of deployed packages
Performance Optimization
- Diagnosing and resolving performance bottlenecks
- Best practices for enhancing data and control flows
- Implementing parallelism and batch processing in SSIS
Recap and Future Pathways
Requirements
- Fundamental knowledge of SQL and relational database principles
- Proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data specialists
- Software developers
- Database administrators
