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.

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
5 to 9 October 2026OnlineOnlineR8,500 per delegateRegister Now
19 to 23 October 2026Lusaka, ZambiaClassroomUSD 1,325 per delegateRegister Now
26 to 30 October 2026Kigali, RwandaClassroomUSD 1,325 per delegateRegister Now
2 to 6 November 2026Maseru, LesothoClassroomR19,950 per delegateRegister Now
11 to 15 January 2027Gaborone, BotswanaClassroomR19,950 per delegateRegister Now
8 to 12 February 2027Port Louis, MauritiusClassroomUSD 1,325 per delegateRegister Now

Database Administration and Performance

From R8,500

AskRegister