Data Science, Digital M&E & AI · 10 Days
MySQL remains one of the world's most widely deployed open-source relational database systems, powering web platforms, enterprise applications, government information systems and data-driven programmes across Africa. Developers who understand how to model data properly, write efficient SQL and manage database behaviour build faster, safer and more reliable applications. This ten-day programme takes participants from the foundations of relational databases through to advanced development topics. Delegates install and configure MySQL, design normalised schemas, write complex queries with joins, subqueries and window functions, and build stored procedures, functions, triggers and views. They also learn to manage transactions, indexing, query optimisation, security, backup and recovery. The programme is highly practical. Each module combines concise concept sessions with guided labs using realistic datasets drawn from sectors such as health, agriculture, finance and programme monitoring. The course concludes with a capstone project in which participants design and deliver a complete database back end integrated with an application, ready to apply in their organisations.
Participants should have basic computer literacy and some exposure to programming or scripting in any language. Prior knowledge of databases is helpful but not required. Participants should bring a laptop on which they have permission to install software.
Participants who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).
Participants should have basic computer literacy and some exposure to programming or scripting in any language. Prior knowledge of databases is helpful but not required. Participants should bring a laptop on which they have permission to install software.
Participants 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 MySQL for Developers, 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 install, configure and navigate a MySQL server and its client tools, design normalised relational schemas using entity-relationship modelling, write SQL statements for creating, retrieving, updating and deleting data, combine data using joins, subqueries, set operations and window functions, build views, stored procedures, functions, triggers and events, apply transactions and locking to maintain data integrity under concurrent use, create indexes and analyse execution plans to optimise query performance, implement user management, privileges and security best practices, plan and execute backup, restore and basic replication strategies, and integrate MySQL with application code using secure, parameterised connections. The programme is designed to be immediately applicable to your day-to-day role.
| Location | Dates | Mode | |
|---|---|---|---|
| Mombasa, Kenya | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Dar es Salaam, Tanzania | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Cairo, Egypt | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Accra, Ghana | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Pretoria, South Africa | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Zanzibar, Tanzania | 09 Nov 2026 – 18 Nov 2026 | Classroom | Register → |
| Live Virtual | 09 Nov 2026 – 18 Nov 2026 | Online | Register → |
| Johannesburg, South Africa | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Kampala, Uganda | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Nairobi, Kenya | 16 Nov 2026 – 25 Nov 2026 | Classroom | Register → |
| Kigali, Rwanda | 23 Nov 2026 – 02 Dec 2026 | Classroom | Register → |
| Cape Town, South Africa | 23 Nov 2026 – 02 Dec 2026 | Classroom | Register → |
See full pricing, exact upcoming dates across Kenya, Tanzania, Egypt, and secure your seat online in minutes.
Book This Training →