Level 3 of 3
Advanced Level
Prerequisites
Database Intermediate level, or equivalent: database design, advanced SQL, transactions, data import and application access.
Duration
12 weeks · 140 guided hours · 6 modules. Taught live by an instructor — online or in person.
By the end of this level you can
- Install, configure, secure and maintain PostgreSQL servers
- Diagnose and fix performance problems with query plans and indexes
- Protect data with access control, encryption and privacy practices
- Plan backups, replication and disaster recovery to agreed targets
- Choose suitable data stores, including NoSQL, and justify the choice
Modules
- 1Module 1 · 22 h · 4 lessonsPostgreSQL Administration
- 2Module 2 · 24 h · 4 lessonsPerformance Tuning
- 3Module 3 · 20 h · 4 lessonsData Security and Privacy
- 4Module 4 · 22 h · 4 lessonsReplication, Availability and Recovery
- 5Module 5 · 22 h · 4 lessonsNoSQL and Choosing a Data Store
- 6Module 6 · 30 h · 5 lessonsDatabase Capstone
Advanced level project
Production Database Plan and Implementation for a Health Programme
Design, implement and operate the database for a multi-site health programme: secure roles, tuned queries, automated backups with tested restores, a replica and a documented recovery plan.
Deliverables
- A PostgreSQL database with schema, roles, row-level security and sample data (invented records)
- A performance report with query plans before and after tuning
- Automated backups, a timed restore drill and a standby replica
- An operations runbook covering monitoring, maintenance and disaster recovery
Assessed on
- Each role can access only the data its policy allows, demonstrated with tests
- Slow queries are improved with measured evidence
- Recovery meets the agreed recovery point and recovery time objectives in a drill
- The runbook lets another administrator operate the database
All levels are taught live by an instructor — online or in person — see registration options.