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
Constructing Data Flows
- Introduction to data flow tasks and transformation components
- Managing data sources and output destinations
- Applying standard data transformation methods
- Addressing data quality concerns
SSIS Control Flow Mechanics
- Comprehending control flow tasks
- Leveraging containers for flow management
- Integrating loops and conditional logic structures
- Orchestrating package execution paths
Sophisticated Data Transformation Strategies
- Utilizing advanced transformation capabilities
- Performing data cleansing, validation, and enrichment
- Applying aggregation and summarization methods
- Detailed implementation of Slowly Changing Dimensions (SCD)
Leveraging Variables and Parameters
- Foundations of variables and parameters
- Using variables to direct package behavior
- Dynamic adjustment of package properties
Overseeing SSIS Package Execution
- Setting package execution preferences
- Strategies for error handling and logging
- Employing event handlers for runtime event management
- Scheduling and automating tasks via SQL Server Agent
Deployment and Package Administration
- Deployment models specific to SQL Server 2022
- Publishing packages to the SSIS catalog
- Monitoring and diagnosing deployed packages
Performance Optimization and Tuning
- Detecting and resolving performance constraints
- Best practices for enhancing data and control flows
- Implementing parallelism and batch processing in SSIS
Course Recap and Future Directions
Requirements
- A foundational grasp of SQL and relational database principles
- Proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Software developers
- Database administrators