Data Science, Digital M&E & AI · 10 Days
Structured Query Language remains the backbone of data work in government agencies, development organizations, financial institutions and enterprises across Africa. As datasets grow in size and complexity, basic SELECT statements are no longer enough. Analysts and developers need advanced techniques to extract, reshape and summarize data accurately and efficiently. This ten-day, hands-on programme takes delegates from a solid foundation to advanced proficiency. Through practical labs built on realistic programme, finance, health and survey datasets, participants learn multi-table joins, subqueries, common table expressions, window functions, recursive queries, data transformation, indexing and performance tuning. The course also covers procedural logic, views, stored procedures, transactions and data quality practices, so delegates can build reusable, secure and production-ready database solutions. By the end, participants will be able to design analytical queries that support dashboards, M&E reporting, audits and strategic planning with confidence.
Participants should have a working knowledge of basic SQL, including SELECT, WHERE, GROUP BY and simple joins. Familiarity with relational database concepts is recommended. Delegates should bring a laptop with administrative rights for installing the course software.
Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).
Participants should have a working knowledge of basic SQL, including SELECT, WHERE, GROUP BY and simple joins. Familiarity with relational database concepts is recommended. Delegates should bring a laptop with administrative rights for installing the course software.
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 Advanced SQL Querying, tailored to your organisation's context within Data Science, Digital M&E & AI. 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 write complex multi-table queries using all join types and set operations, apply subqueries and common table expressions to solve layered analytical problems, use window functions for ranking, running totals, moving averages and period comparisons, transform, clean and reshape data using string, date and conditional functions, diagnose slow queries using execution plans and improve them through indexing and rewriting, create views, stored procedures and functions for reusable logic, manage transactions and enforce data integrity and security, and build analytical queries that feed dashboards and operational reports. The programme is designed to be immediately applicable to your day-to-day role.
| Location | Dates | Mode | |
|---|---|---|---|
| Pretoria, South Africa | 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 → |
| Kampala, Uganda | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Johannesburg, South Africa | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Live Virtual | 09 Nov 2026 – 18 Nov 2026 | Online | Register → |
| Nairobi, Kenya | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Kigali, Rwanda | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Cape Town, South Africa | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Dubai, United Arab Emirates | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Dar es Salaam, Tanzania | 23 Nov 2026 – 02 Dec 2026 | Classroom | Register → |
| Cairo, Egypt | 23 Nov 2026 – 02 Dec 2026 | Classroom | Register → |
See full pricing, exact upcoming dates across South Africa, Tanzania, Kenya, and secure your seat online in minutes.
Book This Training →