About this programme

Databases form the backbone of modern organizations, and effective administration ensures reliability, security, and performance. This training introduces participants to the core principles and practices of database administration, focusing on PostgreSQL and SQL Server. It covers installation, configuration, user management, backup and recovery, performance tuning, and security. Through case studies and practical exercises, participants will learn how to manage databases efficiently, troubleshoot issues, and support business-critical applications.

Duration

5 Days

Who Should Attend

IT professionals and system administrators
Aspiring or junior database administrators
Software developers and data analysts working with databases
Technical support staff managing data systems
Professionals seeking to build expertise in PostgreSQL or SQL Server administration

Learning outcomes

What you'll walk away with

By the end of the training, participants will be able to:

Install and configure PostgreSQL and SQL Server.
Manage databases, users, roles, and permissions.
Perform backups, restores, and ensure data recovery strategies.
Monitor performance and optimize queries.
Secure databases against unauthorized access and threats.
Apply real-world case studies to strengthen administration skills.

Course modules

What we cover, module by module

Module 1: Introduction to Database Administration

Overview of PostgreSQL and SQL Server architecture
Installation and configuration
Database creation and management
Case Study: Setting up a production-ready PostgreSQL/SQL Server instance

Module 2: User and Security Management

Creating users, roles, and permissions
Authentication methods and security best practices
Case Study: Implementing access controls for a multi-department system

Module 3: Backup, Recovery, and Maintenance

Backup strategies (full, differential, incremental)
Recovery models and restore operations
Routine database maintenance tasks
Case Study: Designing a disaster recovery plan for a financial database

Module 4: Performance Monitoring and Optimization

Monitoring tools and system performance metrics
Query optimization and indexing strategies
Troubleshooting performance bottlenecks
Case Study: Optimizing slow queries in a reporting system

Module 5: Advanced Administration and Practical Scenarios

High availability and replication basics
Automation with scripts and scheduling tools
Best practices for database lifecycle management
Case Study: Implementing replication for business continuity

Impact

Where the change lands

Organizational Impact

Improved reliability and performance of critical databases
Reduced downtime through effective backup, recovery, and troubleshooting
Stronger database security and compliance with data governance standards
Increased in-house technical capacity, lowering dependence on external support

Individual Impact

Hands-on skills in PostgreSQL and SQL Server administration
Ability to manage database users, permissions, and roles
Enhanced troubleshooting and performance optimization knowledge
Career growth opportunities in IT infrastructure, development, and data management

Dates and locations

Upcoming intakes

Every intake is limited to a small cohort. Booking closes when a date fills or three weeks before the start, whichever comes first.

Full calendar

City	Starts	Ends	Delivery	Book
NakuruNext	20 Jul 2026	24 Jul 2026	In-Person	Book
Kigali	20 Jul 2026	24 Jul 2026	In-Person	Book
Accra	20 Jul 2026	24 Jul 2026	In-Person	Book
Kisumu	27 Jul 2026	31 Jul 2026	In-Person	Book
Johannesburg	27 Jul 2026	31 Jul 2026	In-Person	Book
Dakar	27 Jul 2026	31 Jul 2026	In-Person	Book