Practical MySQL Development Course East Africa

Course outline and learning expectations

This is a tutor-led course. The outline shows what your tutor will cover; teaching materials and examinations are provided directly to enrolled students.

What you will learn

• Translate application requirements into a normalized schema
• Write complex joins, subqueries and common table expressions
• Use window functions for reporting and analytics
• Apply transactions to protect multi-step operations
• Create views, stored procedures, functions and triggers
• Design effective indexes and interpret EXPLAIN output
• Manage users, roles and least-privilege access
• Connect MySQL securely to a web or data application

Modules

1. 1

   Requirements analysis and schema modelling

   Convert real operational needs into scalable relational database designs

   Business rulesEntity relationship modellingCardinalityNaming standardsSchema documentation
2. 2

   Normalization and data integrity

   Improve data quality while balancing practical application needs

   First to third normal formCandidate keysConstraintsGenerated columnsDenormalization decisions
3. 3

   Advanced SQL queries

   Solve complex reporting and data retrieval problems efficiently

   Multi-table joinsSubqueriesCommon table expressionsSet operationsConditional expressions
4. 4

   Analytics with MySQL functions

   Produce decision-ready reports for regional organisations

   Date and string functionsJSON functionsWindow functionsRankingRunning totals
5. 5

   Transactions and concurrency

   Protect payments, bookings and inventory processes from partial updates

   ACID principlesSTART TRANSACTIONCOMMITROLLBACKIsolation levelsConcurrency risks
6. 6

   Database programmability

   Place reusable data logic inside MySQL when appropriate

   ViewsStored proceduresStored functionsTriggersScheduled eventsError handling
7. 7

   Indexes, EXPLAIN and query improvement

   Diagnose slow queries and select effective indexing strategies

   B-tree indexesComposite indexesCovering indexesEXPLAINQuery rewritesStatistics
8. 8

   Secure application database capstone

   Build and connect a multi-user MySQL database for an East African digital service

   Users and rolesPrepared statementsApplication connectionSeed dataTestingDocumentationProject demonstration