Get in Touch
 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.
Investment

Price per private group, online live training, starting from 5800 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Upcoming Courses

Related Categories