Merci d'avoir envoyé votre demande ! Un membre de notre équipe vous contactera sous peu.
Merci d'avoir envoyé votre réservation ! Un membre de notre équipe vous contactera sous peu.
Plan du cours
Designing Data Flows
- Overview of 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
- Data cleansing, validation, and enrichment
- Aggregation and summarization techniques
- Implementing Slowly Changing Dimensions (SCD) in detail
Working with Variables and Parameters
- Introduction to variables and parameters
- Using variables to control package behavior
- Dynamic configuration of package properties
Managing SSIS Package Execution
- Configuring package execution options
- Error handling and logging strategies
- Using event handlers to manage runtime events
- Scheduling and automating execution with SQL Server Agent
Deploying and Managing SSIS Packages
- Deployment models in SQL Server 2022
- Deploying packages to the SSIS catalog
- Monitoring and troubleshooting deployed packages
Performance Tuning and Optimization
- Identifying and addressing performance bottlenecks
- Best practices for optimizing data flows and control flows
- Parallelism and batch processing in SSIS
Summary and Next Steps
Pré requis
- Basic understanding of SQL and relational database concepts
- Familiarity with SQL Server Management Studio (SSMS)
Audience
- Data professionals
- Developers
- Database administrators
14 Heures
Nos clients témoignent (1)
The thorough / hands-on knowledge the trainer has.
Pieter Peirs
Formation - Introduction to SQL Server 2012 Integration Services (SSIS)
Traduction automatique
