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.

3 days (24 hours)Blended6 lessonsWorks on low data

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

University Graduates & StudentsProfessionals in Nonprofit & Development Agencies

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