Skip to content
AfriScienceGroup home
Cybersecurity and IT

Database Administration and Performance

A database is where an organisation's records actually live, which makes its administrator the person who can lose everything and the person expected to explain why a report is slow. This course covers both duties. Delegates work through database architecture, storage and the instance configuration that affects everything else, and user, role and privilege administration. Backup and recovery are treated as the core responsibility, including proving a restore rather than assuming one. Performance follows: reading an execution plan, indexing decisions and the trade offs they carry, and diagnosing contention and blocking. Maintenance, statistics and growth management are covered. The course closes on patching, upgrades and high availability arrangements.

5 day course

Course objectives

  • Describe database architecture, storage and instance configuration
  • Administer users, roles and privileges securely
  • Design backups and prove recovery by testing a restore
  • Read an execution plan and identify the cost
  • Make indexing decisions and understand their trade offs
  • Diagnose contention, blocking and resource limits
  • Manage maintenance, growth, patching and high availability

Who should attend

  • Database administrators and support staff
  • System administrators with database duties
  • Developers writing queries against production systems
  • IT managers responsible for data availability
  • Analysts investigating performance problems

Course outline

  1. 01Losing everything and explaining slowness
  2. 02Architecture, storage and instance configuration
  3. 03Users, roles and privileges
  4. 04Backup design
  5. 05Recovery and proving a restore
  6. 06Execution plans and query cost
  7. 07Indexing decisions and trade offs
  8. 08Contention, maintenance, patching and high availability

Scheduled sessions

Scheduled sessions for Database Administration and Performance
DatesVenueFormatPriceRegister
9 to 13 November 2026Lusaka, ZambiaClassroomUSD 1,325 per delegate
16 to 20 November 2026Maseru, LesothoClassroomR19,950 per delegate
11 to 15 January 2027Kigali, RwandaClassroomUSD 1,325 per delegate
18 to 22 January 2027Durban, South AfricaClassroomR19,950 per delegate
15 to 19 February 2027Port Louis, MauritiusClassroomUSD 1,325 per delegate

Database Administration and Performance

From R19,950

Ask