DB-301
PostgreSQL Administration
Cost: $1000
Duration: 5
Day
s
Skill Level: Intermediate
Course Overview
This course will help trainees to acquire the necessary skills to administer and operate PostgreSQL in a real environment on a daily basis. The course covers critical aspects of PostgreSQL operations, including performance monitoring, database backups and restoration, high availability configurations, and security implementation.
Trainees will also learn strategies for seamless database upgrades and migrations.
By the end of the course, participants will be equipped to handle daily PostgreSQL administrative tasks with confidence, ensuring optimized performance, security, and scalability in real-world environments.
Learning Outcomes
At the end of the course, trainees will be able to:
- Perform performance monitoring and tuning
- Migrate databases with minimal downtime
- Monitor database health using built-in PostgreSQL tools
- Configure database backups and restoration
- Configure high availability and clustered setups
- Implement database security
- Implement database upgrades
Suitable For
Current and aspiring PostgreSQL administrators
Course Outline
PostgreSQL Administration
- Database Backups and Restoration
- pg_dump
- Base backups + WAL
- Restoration
- Performance Monitoring and Tuning
- Indexes
- Denormalization
- Query Explain
- Vacuum
- Benchmarking using pgBench
- CPU, Memory, and Disk
- OS Parameters
- Scaling and High Availability
- Master-Slave
- Hot Standby
- PgPool II
- Database Security
- pg_hba.conf
- RBAC
- SQL Injection
- Prepared Statements
- Database Migration and Upgrades
- Strategies: Lower to Higher Version
- Strategies: Lift and Shift
Hardware Requirements
- Laptop or Computer
- Intel i3 or greater
- 8GB RAM Minimum
- 100 GB Disk Space
Software Requirements
- Linux or Windows
- Docker Desktop
EXCLUSIVE TRAINING FOR YOU COMPANY
AT YOUR PREFERRED SCHEDULE
Tailored to the needs of your organization, we also offer cadetship
programs which include a series of our standardized O&B Academy courses.
Get a quote