Database Management

Level 2 of 3

Intermediate Level

Prerequisites

Database Beginner level, or equivalent: SELECT with filters, joins, GROUP BY, basic table creation and backups.

Duration

8 weeks · 90 guided hours · 6 modules. Taught live by an instructor — online or in person.

By the end of this level you can

  • Design normalised databases from requirements using ER diagrams
  • Write advanced SQL with subqueries, CTEs and window functions
  • Protect data with constraints, views and transactions
  • Import, clean and export data, and use stored logic where it helps
  • Use databases safely from application code

Modules

  1. 1Module 1 · 16 h · 3 lessonsDatabase Design and Normalisation
  2. 2Module 2 · 16 h · 3 lessonsAdvanced SQL Queries
  3. 3Module 3 · 15 h · 3 lessonsViews, Constraints and Transactions
  4. 4Module 4 · 13 h · 3 lessonsStored Logic and Data Import
  5. 5Module 5 · 13 h · 3 lessonsUsing Databases from Applications
  6. 6Module 6 · 17 h · 3 lessonsIntermediate Database Project

Intermediate level project

NGO Beneficiary and Distribution Database

A PostgreSQL database for an NGO that registers households, plans distributions and records what each household received, with reports for programme managers and donors.

Deliverables

  • An ER diagram and a normalised schema with migrations or a versioned script
  • Imported, cleaned sample data from a provided messy spreadsheet (invented records)
  • Views and report queries for distributions per location, coverage and duplicates
  • A small script in Python or another language that adds records with parameterised queries

Assessed on

  • The schema is in third normal form unless a documented reason says otherwise
  • Constraints and transactions prevent duplicate registrations and partial distributions
  • Report queries are correct and documented
  • Application code is safe from SQL injection and handles errors

All levels are taught live by an instructor — online or in person — see registration options.