MySQL for Developers Training

Data Science, Digital M&E & AI · 10 Days

Course Overview

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.

Who Should Attend

  • Software and web developers building database-driven applications
  • Backend engineers and full-stack developers
  • IT officers and systems analysts in public and private institutions
  • Database administrators seeking stronger development skills
  • Data analysts and M&E information systems staff who write SQL
  • Technical staff maintaining management information systems
  • Computer science graduates and ICT trainees preparing for professional practice

Learning Objectives

  • 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
  • Integrate MySQL with application code using secure, parameterised connections

Key Takeaways

Course Curriculum

1

Introduction to Relational Databases and MySQL

2

Data Modelling and Schema Design

3

Core SQL: Retrieving and Filtering Data

4

Manipulating Data and Enforcing Constraints

5

Joins and Multi-Table Queries

6

Aggregation, Grouping and Subqueries

7

Advanced Analytical SQL and Window Functions

8

Views and Stored Routines

9

Triggers, Events and Cursors

10

Transactions and Concurrency Control

11

Indexing and Query Performance Tuning

12

Security, Backup, Recovery and Replication

13

Application Integration and Capstone Project

Requirements

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.

Certification

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

Frequently Asked Questions

Do I need prior experience to attend this course?

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.

Will I receive a certificate upon completion?

Participants 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 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.

Is this course available online for remote participants?

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 practical skills will I gain from this course?

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.

Upcoming Sessions

LocationDatesMode
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 →

Ready to Register for MySQL for Developers Training?

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

Book This Training →