Advanced level · Module 6 of 6 · 30 guided hours
Database Capstone
Design, secure, tune and operate the production database for a multi-site health programme, and hand it over with a runbook.
Learning objectives
- Deliver a secure, well-designed production database
- Prove performance and recovery with measurements
- Document operations so others can run the system
Topics
- requirements and design
- security implementation
- performance evidence
- backup, replication and recovery
- runbook
- presentation
Lessons
-
Lesson 1 Capstone Requirements and Design
Gather requirements for the multi-site health programme and design the schema, roles and targets.
multi-site requirementsschema designrole designservice targets
-
Lesson 2 Implementing Schema and Security
Build the database with roles, row-level security, encryption and auditing.
schema scriptsroles and RLSTLS and auditingsecurity tests
-
Lesson 3 Performance Evidence
Load realistic volumes, measure the main queries and tune them to meet the targets.
data generationworkloadEXPLAIN ANALYZEperformance report
-
Lesson 4 Backup, Replication and Recovery
Automate backups, add a standby, and prove recovery against the agreed RPO and RTO.
automated backupsstandby replicafailoverrecovery drill
-
Lesson 5 Runbook and Presentation
Document how to operate the database and present the project to technical and non-technical audiences.
runbookmonitoring checklisthandoverpresentation
Practical activity
Deliver the capstone through five reviewed milestones: design, security, performance, recovery and runbook with presentation.
Expected outcomes
- A portfolio-quality database project
- Experience of production database responsibilities
Assessment
The level project assessed against its criteria, with live demonstrations of access control, failover and restore.
Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.