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.
Course Outline
Introduction to SQL Server Integration Services (SSIS)
- Overview of SSIS and its role in data integration
- Key features and enhancements in SQL Server 2022
- SSIS architecture and components
- Understanding ETL processes
Getting Started with SSIS
- Installing and configuring SSIS
- Introduction to SQL Server Data Tools (SSDT)
- Creating your first SSIS project and package
- Navigating the SSIS designer interface
Designing Data Flows
- Introduction to data flow tasks and transformations
- Working with data sources and destinations
- Implementing common data transformations
- Handling data quality issues
Control Flow in SSIS
- Understanding control flow tasks
- Using containers to manage control flow
- Implementing loops and conditional logic
- Managing package execution flow
Advanced Data Transformation Techniques
- Using advanced transformations
- Implementing data cleansing and validation
- Performing data enrichment and aggregation
- Using fuzzy matching and grouping
Working with Variables and Parameters
- Introduction to variables and parameters
- Using variables to control package behavior
- Passing parameters to and from packages
- Dynamic configuration of package properties
Managing SSIS Package Execution
- Configuring package execution options
- Implementing error handling and logging
- Using event handlers to manage runtime events
- Scheduling and automating package execution with SQL Server Agent
Deploying and Managing SSIS Packages
- Overview of SSIS deployment models
- Deploying packages to the SSIS catalog
- Managing package configurations and environments
- Monitoring and troubleshooting deployed packages
Performance Tuning and Optimization
- Identifying performance bottlenecks in SSIS packages
- Best practices for optimizing data flows and control flows
- Using SSIS logging and performance counters
- Implementing parallelism and batch processing
Advanced Topics and Future Directions
- Introduction to SSIS scripting with C# and VB.NET
- Integration with other SQL Server components
- Exploring new features and enhancements in future SSIS releases
- Resources for further learning and community involvement
Summary and Next Steps
Requirements
- Basic understanding of SQL and relational database concepts
- Familiarity with SQL Server Management Studio (SSMS)
Audience
- Data professionals
- Developers
- Database administrators
28 Hours
Testimonials (1)
The thorough / hands-on knowledge the trainer has.