Database Integration using SQL Server Integration Services (SSIS) Training

Cybersecurity & Information Systems · 10 Days

Course Overview

Organizations across Africa collect data in spreadsheets, operational databases, cloud platforms, mobile data collection tools and legacy systems. Without robust integration, this data remains fragmented, inconsistent and difficult to trust for reporting and decision-making. SQL Server Integration Services (SSIS) is Microsoft's enterprise platform for extracting, transforming and loading data at scale. This ten-day, tool-intensive programme takes delegates from the fundamentals of ETL and the SSIS development environment through control flow, data flow, transformations, error handling, parameterization, deployment and scheduling. Participants work through practical labs and a realistic capstone project that mirrors the integration challenges of development agencies, NGOs, financial institutions, government bodies and corporate enterprises. By the end of the course, delegates will be able to build maintainable, secure and well-documented integration packages that improve data quality, reduce manual effort and provide a dependable foundation for business intelligence, monitoring and evaluation, and analytics.

Who Should Attend

  • Database administrators and database developers
  • Data engineers and ETL developers
  • Business intelligence and reporting analysts
  • IT officers and systems administrators
  • Data analysts and data managers
  • Monitoring and evaluation information systems officers
  • Software developers working with SQL Server
  • IT managers overseeing data warehousing and integration projects

Learning Objectives

  • Explain ETL concepts and the role of SSIS in enterprise data integration
  • Design and build SSIS packages using SQL Server Data Tools
  • Extract data from flat files, Excel, relational databases and other sources
  • Apply data flow transformations to clean, standardize, merge and enrich data
  • Orchestrate workflows using control flow tasks, containers and precedence constraints
  • Implement variables, parameters and expressions for dynamic, reusable packages
  • Handle errors, logging, checkpoints and transactions to make packages robust
  • Build incremental loads and slowly changing dimension processes for data warehouses
  • Deploy packages to the SSIS catalog and schedule them with SQL Server Agent
  • Secure, monitor and troubleshoot production integration solutions

Key Takeaways

Course Curriculum

1

Introduction to Data Integration and ETL

2

Setting Up the SSIS Development Environment

3

Control Flow Fundamentals

4

Data Flow Basics: Sources and Destinations

5

Data Transformations I: Cleansing and Shaping

6

Data Transformations II: Combining and Enriching Data

7

Variables, Parameters and Expressions

8

Error Handling, Logging and Package Robustness

9

Incremental Loads and Change Data Capture

10

Loading Data Warehouses and Slowly Changing Dimensions

11

Script Tasks, Custom Logic and Advanced Integration

12

Deployment, Security, Scheduling and Monitoring

13

Performance Tuning, Best Practices and Capstone Project

Requirements

Participants should have a basic understanding of relational databases and be comfortable writing simple SQL queries. Prior experience with SQL Server Management Studio is helpful but not essential. Delegates should bring a laptop capable of running the lab environment, or use the one provided.

Certification

Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Frequently Asked Questions

What background knowledge is expected before attending?

Participants should have a basic understanding of relational databases and be comfortable writing simple SQL queries. Prior experience with SQL Server Management Studio is helpful but not essential. Delegates should bring a laptop capable of running the lab environment, or use the one provided.

Is a certificate issued upon completion?

Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Can this course be delivered as an in-house programme for our organisation's team?

Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Database Integration using SQL Server Integration Services (SSIS), tailored to your organisation's context within Cybersecurity & Information Systems. Contact our training team to discuss customisation, scheduling and group pricing.

Can I attend this course virtually instead of in person?

Yes. Selected cohorts of this course are available as live virtual sessions delivered over video conferencing by an experienced facilitator, with the same certificate issued on completion as the in-person format.

What are the key learning outcomes of this course?

By the end of this course, you will be able to explain ETL concepts and the role of SSIS in enterprise data integration, design and build SSIS packages using SQL Server Data Tools, extract data from flat files, Excel, relational databases and other sources, apply data flow transformations to clean, standardize, merge and enrich data, orchestrate workflows using control flow tasks, containers and precedence constraints, implement variables, parameters and expressions for dynamic, reusable packages, handle errors, logging, checkpoints and transactions to make packages robust, build incremental loads and slowly changing dimension processes for data warehouses, deploy packages to the SSIS catalog and schedule them with SQL Server Agent, and secure, monitor and troubleshoot production integration solutions. The programme is designed to be immediately applicable to your day-to-day role.

Upcoming Sessions

LocationDatesMode
Cairo, Egypt 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Accra, Ghana 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Zanzibar, Tanzania 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Mombasa, Kenya 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Live Virtual 09 Nov 2026 – 18 Nov 2026 Online Register →
Pretoria, South Africa 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kampala, Uganda 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Nairobi, Kenya 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Johannesburg, South Africa 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Kigali, Rwanda 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Dubai, United Arab Emirates 23 Nov 2026 – 02 Dec 2026 Classroom Register →

Ready to Register for Database Integration using SQL Server Integration Services (SSIS) Training?

See full pricing, exact upcoming dates across Egypt, Tanzania, Ghana, and secure your seat online in minutes.

Book This Training →