Cybersecurity & Information Systems · 10 Days
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.
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.
Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).
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.
Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).
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.
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.
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.
| Location | Dates | Mode | |
|---|---|---|---|
| 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 → |
See full pricing, exact upcoming dates across Egypt, Tanzania, Ghana, and secure your seat online in minutes.
Book This Training →