お問い合わせを送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
コース概要
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
要求
- Basic understanding of SQL and relational database concepts
- Familiarity with SQL Server Management Studio (SSMS)
Audience
- Data professionals
- Developers
- Database administrators
28 時間
お客様の声 (1)
The thorough / hands-on knowledge the trainer has.
