Advanced level · Module 6: Database Capstone · Lesson 5 of 5
Runbook and Presentation
Document how to operate the database and present the project to technical and non-technical audiences.
In this lesson you will
- Write an operations runbook
- Present the database's design, security and recoverability
Key concepts
runbookmonitoring checklisthandoverpresentation
The lesson
The runbook covers daily and weekly checks, monitoring queries, user management, backups, failover, restore and who to contact. Another administrator should be able to follow it without you.
Include the data dictionary, access model and the reasons for key decisions.
Present to a mixed audience: explain to managers what is protected and how quickly the system recovers, and show technical reviewers the evidence.
Step by step
- Write the runbook.
- Have a classmate follow one procedure from it.
- Prepare demonstrations of access control and recovery.
- Rehearse and present.
Practice activity
Complete milestone 5 and present the health programme database.
Expected result: A classmate can perform a procedure from the runbook and the presentation shows the evidence for each criterion.
Check your understanding
-
What is the test of a good runbook?
Show answer
Another administrator can follow it without the author's help.
-
How should recovery be explained to managers?
Show answer
In terms of how much data could be lost and how long the system would be unavailable.
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.