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 28 hours
Course Outline
Introduction to SQL Server Integration Services (SSIS)
- Overview of SSIS and its function within data integration
- Notable features and improvements in SQL Server 2022
- SSIS architecture and constituent components
- Concepts behind ETL processes
Beginner’s Guide to SSIS
- Installation and configuration of SSIS
- Overview of SQL Server Data Tools (SSDT)
- Building your initial SSIS project and package
- Interacting with the SSIS designer interface
Designing Data Flows
- Introduction to data flow tasks and transformations
- Managing data sources and destinations
- Applying standard data transformations
- Addressing data quality concerns
Managing Control Flow in SSIS
- Exploring control flow tasks
- Utilizing containers for control flow management
- Implementing loops and conditional logic
- Directing the execution flow of packages
Sophisticated Data Transformation Methods
- Application of advanced transformations
- Executing data cleansing and validation routines
- Performing data enrichment and aggregation
- Employing fuzzy matching and grouping techniques
Utilizing Variables and Parameters
- Introduction to variables and parameters
- Using variables to regulate package behavior
- Transferring parameters into and out of packages
- Dynamic adjustment of package properties
Administering SSIS Package Execution
- Setting up package execution options
- Integrating error handling and logging mechanisms
- Leveraging event handlers for runtime event management
- Automating and scheduling package execution via SQL Server Agent
Deployment and Management of SSIS Packages
- Survey of SSIS deployment models
- Deploying packages to the SSIS catalog
- Overseeing package configurations and environments
- Monitoring and troubleshooting deployed packages
Performance Tuning and Optimization
- Detecting performance bottlenecks within SSIS packages
- Best practices for streamlining data and control flows
- Leveraging SSIS logs and performance counters
- Implementing parallelism and batch processing strategies
Advanced Concepts and Future Prospects
- Introduction to SSIS scripting using C# and VB.NET
- Integration with additional SQL Server components
- Exploration of upcoming features in future SSIS releases
- Resources for continued learning and community engagement
Conclusion and Recommendations
Requirements
- A foundational grasp of SQL and relational database principles
- Comfortable working with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Developers
- Database administrators
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 5800 € + VAT*
Contact us for an exact quote and to hear our latest promotions