Standard Professional Development – Professional Certificates
Standalone course
Database Administration & Management
Databases underpin most modern office systems, from staff records to inventory and case management. This course introduces the practical skills to design, build and manage a small database for an office or project, using general concepts that transfer across common tools. It is designed for staff who need to organise structured information reliably in the national and regional context. You will learn how to model data, design tables and relationships, build queries and simple forms, control data entry quality, and back up and secure the database. You will work with an invented membership records scenario and leave with a simple database design template and a backup checklist.
Course overview
The course begins with what a database is and how it differs from a spreadsheet, then moves to data modelling and designing tables and relationships. You build queries to answer real questions and simple forms to make data entry easier and cleaner.
The second half covers data quality, user management, backup and basic security, so the database stays reliable and protected. Each module uses the membership records scenario and ends with a practical task.
Learning outcomes
By the end of this course you will be able to:
- 1Explain what a database is and when to use one instead of a spreadsheet.
- 2Model simple data and design tables and relationships.
- 3Build basic queries to answer office questions.
- 4Create simple forms for cleaner data entry.
- 5Control data entry quality with validation and rules.
- 6Back up a database and keep it secure.
- 7Document a small database for handover.
Tools, templates & materials provided
Database design template, query reference sheet, backup checklist.
At a glance
Total learning hours
24 hours (14h lessons · 6h practice · 4h assessment)
Delivery format
Blended: short video lessons and hands-on exercises with a sample database tool.
Assessment method
Applied work-product (a small database design with tables, a query and a backup plan) plus an 8-question application quiz.
Pass mark
70%
Credential awarded
Certificate of Completion
Stacks toward
Certificate of Completion. Stacks toward the Professional Certificate in Data & Digital Skills.
Who should attend
IT-literate staff, M&E and records officers, and anyone who needs to build or manage a small database for an office.
Entry requirements
Computer literacy equivalent to Microsoft Office Productivity.
Facilitator
Practitioner with database or IT management experience.
Curriculum
Tap any module to see the full detail: objectives, topics, practical case study and assessment.
Who it is for
IT-literate staff, M&E and records officers, and anyone who needs to build or manage a small database for an office.
For organizations
Enroll a team, assign this offering by county or department, and track completion in the organization dashboard.
Request a Quote