Database Administration and Performance
Databases are blamed for slow applications far more often than they deserve, and tuned by guesswork. This course covers administering a relational database and diagnosing performance from evidence.
Course outline
What this programme covers, module by module.
- 01Database architecture, storage and configuration
- 02Security, users, roles and access control
- 03Backup strategies, recovery testing and point in time recovery
- 04Query execution plans and reading them
- 05Indexing: design, maintenance and when it hurts
- 06Locking, concurrency and blocking
- 07Monitoring, capacity planning and maintenance routines
What you will gain
- Install, configure and secure a database instance
- Design backup and recovery that has been tested
- Read execution plans and identify slow queries
- Design and maintain indexes appropriately
- Manage users, roles and access control
- Monitor performance and plan capacity
Who should attend
- Database administrators
- Developers responsible for their own databases
- System administrators supporting databases
- Data engineers and analysts
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 9 to 13 Nov 2026 | Pretoria | 5 Days | R18,000 | |
| 23 to 27 Nov 2026 | Durban | 5 Days | R18,000 | |
| 7 to 11 Dec 2026 | Cape Town | 5 Days | R18,000 | |
| 11 to 15 Jan 2027 | Johannesburg | 5 Days | R18,000 | |
| 1 to 5 Feb 2027 | London | 5 Days | US$1,800 | |
| 5 to 9 Apr 2027 | Dubai | 5 Days | US$1,800 | |
| 21 to 25 Jun 2027 | Pretoria | 5 Days | R18,000 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R18,000 per delegate
- Duration
- 5 Days
- Field
- IT & Digital Skills
- Formats
- In-house, public, online
More in IT & Digital Skills
Cybersecurity Fundamentals for Professionals
Every organisation now depends on systems and data that attackers actively seek to exploit. This course builds a practical understanding of cyber threats and the defences that reduce them. Participants study common attacks, security controls, and the response to incidents.
Spreadsheet to Database Migration for Teams
Teams outgrow a shared spreadsheet long before they admit it, usually at the point where two people are editing different copies. This course covers moving that work into something that holds.
Cloud Computing Foundations
Cloud services have changed how organisations build, run, and pay for technology. This course explains the concepts, models, and benefits of cloud computing in plain terms. Participants examine service models, deployment options, and the basics of cost and security.