Grazie per aver inviato la tua richiesta! Uno dei nostri team membri ti contatterà a breve.
Grazie per aver inviato il tuo prenotazione! Uno dei nostri team membri ti contatterà a breve.
Struttura del corso
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
Requisiti
- Basic understanding of SQL and relational database concepts
- Familiarity with SQL Server Management Studio (SSMS)
Audience
- Data professionals
- Developers
- Database administrators
14 ore
Recensioni (1)
The thorough / hands-on knowledge the trainer has.
