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
Building Data Flows
- Introduction to data flow tasks and transformation types
- Integration with various data sources and destinations
- Application of standard data transformations
- Strategies for resolving data quality challenges
SSIS Control Flow Management
- Exploring control flow task functionalities
- Leveraging containers to structure control flow
- Implementing loops and conditional branching
- Directing package execution sequences
Sophisticated Transformation Methods
- Utilizing advanced transformation features
- Performing data cleansing, validation, and enrichment
- Applying aggregation and summarization strategies
- Detailed implementation of Slowly Changing Dimensions (SCD)
Leveraging Variables and Parameters
- Foundations of variables and parameters
- Utilizing variables to direct package operations
- Dynamically configuring package attributes
Overseeing SSIS Package Execution
- Setting execution configurations
- Implementing error management and logging protocols
- Employing event handlers for runtime monitoring
- Scheduling and automating tasks via SQL Server Agent
Deployment and Administration of SSIS Packages
- Deployment models specific to SQL Server 2022
- Publishing packages to the SSIS catalog
- Monitoring performance and resolving issues in live packages
Optimizing Performance
- Detecting and mitigating performance constraints
- Best practices for streamlining data and control flows
- Managing parallelism and batch processing within SSIS
Wrap-Up and Future Directions
Requirements
- Fundamental grasp of SQL and relational database principles
- Proficiency with SQL Server Management Studio (SSMS)
Target Audience
- Data specialists
- Software developers
- Database administrators