MySQL Database Fundamentals Course in Uganda

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

• Explain relational database and MySQL concepts
• Install and connect to a MySQL server
• Create databases, tables and relationships
• Choose suitable MySQL data types
• Insert, update, delete and retrieve records
• Filter, sort, group and summarise data
• Combine related tables with joins
• Design and present a small working database

Modules

1. 1

   MySQL and relational database foundations

   Understand databases, DBMS concepts and how MySQL supports digital services

   Relational databasesTables, rows and columnsPrimary and foreign keysMySQL ecosystem
2. 2

   Installing and using MySQL tools

   Set up a safe learning environment and connect to a local MySQL server

   MySQL Community ServerMySQL WorkbenchConnectionsSchemas
3. 3

   Creating databases and tables

   Build structured databases with suitable data types and constraints

   CREATE DATABASECREATE TABLEData typesNULL valuesDefault values
4. 4

   Working with data using SQL

   Create, read, update and delete reliable business records

   INSERTSELECTUPDATEDELETESafe update practices
5. 5

   Filtering and summarising records

   Turn raw records into useful information for everyday decisions

   WHEREORDER BYLIMITAggregate functionsGROUP BYHAVING
6. 6

   Relationships and joins

   Connect customers, products, bookings and transactions across related tables

   One-to-many relationshipsINNER JOINLEFT JOINAliasesMulti-table queries
7. 7

   Data quality and practical database design

   Reduce duplication and protect data accuracy

   ConstraintsNormalization basicsUnique valuesReferential integrityNaming conventions
8. 8

   Uganda-focused database capstone

   Design and demonstrate a complete database for a local organisation or enterprise

   Requirements gatheringER diagramSchema implementationTest dataBusiness queriesProject presentation