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
- Integrating various data sources and destinations
- Applying standard data transformation methods
- Mitigating data quality challenges
SSIS Control Flow Management
- Exploring control flow task functionalities
- Leveraging containers to organize control flow logic
- Creating loops and conditional branching structures
- Directing the overall package execution sequence
Sophisticated Data Transformation Strategies
- Utilizing advanced transformation tools
- Performing data cleansing, validation, and enrichment
- Applying aggregation and summarization methods
- Detailed implementation of Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Core concepts of variables and parameters
- Modulating package behavior through variable control
- Implementing dynamic configuration of package properties
Supervising SSIS Package Execution
- Setting up package execution configurations
- Developing error handling and logging protocols
- Employing event handlers for runtime event management
- Automating scheduling and execution via SQL Server Agent
Deployment and Administration of SSIS Packages
- Reviewing deployment models in SQL Server 2022
- Deploying packages to the SSIS catalog
- Monitoring performance and resolving issues in deployed packages
Performance Tuning and Optimization
- Detecting and resolving performance bottlenecks
- Best practices for optimizing both data and control flows
- Utilizing parallelism and batch processing in SSIS
Recap and Future Directions
Requirements
- Fundamental grasp of SQL and relational database principles
- Proficiency with SQL Server Management Studio (SSMS)
Target Learners
- Data professionals
- Developers
- Database administrators
