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
- Survey of data flow tasks and transformation components
- Integrating with various data sources and destinations
- Applying standard data transformation logic
- Mitigating data quality challenges
SSIS Control Flow Mechanisms
- Analyzing control flow task functionalities
- Utilizing containers to structure control flow
- Constructing loops and conditional branching logic
- Orchestrating the overall package execution sequence
Sophisticated Data Transformation Strategies
- Leveraging advanced transformation capabilities
- Executing data cleansing, validation, and enrichment processes
- Employing aggregation and summarization methods
- Deep dive into implementing Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Fundamentals of variables and parameter usage
- Directing package behavior through variable manipulation
- Configuring package properties dynamically
Orchestrating SSIS Package Execution
- Setting up package execution configurations
- Developing robust error handling and logging frameworks
- Responding to runtime events via event handlers
- Automating and scheduling tasks using SQL Server Agent
SSIS Package Deployment and Administration
- Reviewing deployment models specific to SQL Server 2022
- Pushing packages to the SSIS catalog
- Observing and debugging deployed packages
Performance Optimization and Tuning
- Diagnosing and resolving performance bottlenecks
- Adopting best practices for optimizing data and control flows
- Leveraging parallelism and batch processing in SSIS
Conclusion and Path Forward
Requirements
- Foundational knowledge of SQL and relational database principles
- Working familiarity with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Software developers
- Database administrators
