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
Crafting Data Flows
- An examination of data flow tasks and transformation components
- Interacting with various data sources and destinations
- Applying standard data transformation methods
- Addressing data quality challenges
Control Flow Mechanics in SSIS
- Comprehending control flow operations
- Leveraging containers to orchestrate control flow
- Integrating loops and conditional decision points
- Overseeing the overall execution sequence of packages
Sophisticated Transformation Strategies
- Utilizing higher-level transformation components
- Performing data cleansing, validation, and enrichment
- Techniques for data aggregation and summarization
- A detailed implementation of Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Foundations of variables and parameters in SSIS
- Employing variables to dictate package behavior
- Dynamically adjusting package properties
Supervising SSIS Package Execution
- Setting up execution options for packages
- Strategies for error management and logging
- Harnessing event handlers for runtime event management
- Automating schedules via SQL Server Agent
Deployment and Administration of SSIS Packages
- Exploring deployment models specific to SQL Server 2022
- Pushing packages to the SSIS catalog
- Monitoring health and troubleshooting live packages
Performance Tuning and Optimization
- Spotting and resolving performance bottlenecks
- Best practices for streamlining 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
- Working proficiency with SQL Server Management Studio (SSMS)
Intended Audience
- Data specialists
- Software developers
- Database administrators