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
Overview of SQL Server Integration Services (SSIS)
- Role of SSIS in enterprise data integration
- Key capabilities and updates in SQL Server 2022
- Architecture and core components of SSIS
- Principles of Extract, Transform, Load (ETL) workflows
Initializing SSIS Environments
- Installation procedures and configuration requirements
- Overview of SQL Server Data Tools (SSDT)
- Establishing initial SSIS projects and packages
- Navigating the SSIS design interface
Constructing Data Flows
- Fundamentals of data flow tasks and transformation operators
- Utilizing source and destination connectors
- Applying standard data transformation techniques
- Addressing data quality concerns
Managing Control Flow in SSIS
- Overview of control flow tasks
- Utilizing containers to structure control logic
- Implementing iteration and conditional execution paths
- Controlling package execution sequences
Advanced Data Transformation Methods
- Employing sophisticated transformation operators
- Executing data cleansing and validation routines
- Conducting data enrichment and aggregation processes
- Applying fuzzy matching and grouping algorithms
Configuring Variables and Parameters
- Fundamentals of variables and parameters
- Using variables to modulate package behavior
- Transmitting parameters into and out of packages
- Implementing dynamic configuration of package properties
Orchestrating SSIS Package Execution
- Configuring execution options for packages
- Establishing error handling protocols and logging mechanisms
- Utilizing event handlers to address runtime events
- Scheduling and automating package runs via SQL Server Agent
Deploying and Administering SSIS Packages
- Overview of deployment models for SSIS packages
- Deploying packages to the SSIS catalog
- Managing configurations and environments
- Monitoring and resolving issues in deployed packages
Performance Tuning and Optimization
- Identifying performance constraints within SSIS packages
- Established practices for optimizing data and control flows
- Leveraging SSIS logging and performance counters
- Implementing parallelism and batch processing strategies
Advanced Concepts and Emerging Developments
- Introduction to scripting in C# and VB.NET within SSIS
- Integration with complementary SQL Server components
- Reviewing upcoming features and enhancements for future SSIS versions
- Resources for continued education and community engagement
Summary and Next Steps
Requirements
- Foundational knowledge of Structured Query Language (SQL) and relational database principles
- Operational experience with SQL Server Management Studio (SSMS)
Target Audience
- Data specialists
- Software developers
- Database administrators
28 Hours
