Postgresql Administration

About This Course

Our PostgreSQL Administrator (PG-220) training course is designed to equip you with the practical knowledge and technical skills necessary to manage PostgreSQL databases in production environments effectively. This comprehensive program covers all essential aspects of PostgreSQL administration, including installation, configuration, performance tuning, security, backup and recovery, replication, and troubleshooting. You will learn how to deploy, secure, and optimise PostgreSQL databases, ensuring high availability, reliability, and scalability. The course features real-world case studies, hands-on labs, and instructor-led demonstrations to provide a practical, applied learning experience.

This course goes beyond theoretical knowledge. We focus on building real-world administrative skills that are essential for managing PostgreSQL databases in business-critical environments. Whether you’re an existing DBA, a system administrator looking to expand your database expertise, or transitioning into a database role, this course provides the foundation and confidence to take control of PostgreSQL infrastructure. Our experienced instructors will guide you through key administrative tasks and best practices, preparing you to handle real-world database challenges with confidence and precision.

We continuously update our curriculum to reflect the latest advancements and community-driven enhancements in PostgreSQL. From high availability strategies to advanced indexing and performance tuning techniques, this training ensures you're learning the most relevant and effective practices. Whether you're deploying PostgreSQL on-premises or in the cloud, this course positions you to succeed in your role and elevate your database administration capabilities.

Requirements

Basic knowledge of SQL and relational database concepts is recommended. Familiarity with the Linux or Unix command line is beneficial. Prior experience with PostgreSQL or other relational database systems is helpful but not required. A willingness to engage with hands-on exercises and real-world scenarios is essential for success in this course.

Course Staff

Mark Clarke

Mark Clarke is a seasoned open-source advocate and database expert with over 20 years of experience in system administration, software engineering, and enterprise IT consulting. As the founder of Jumping Bean Solutions, he leads training programs across Linux, cloud, cybersecurity, and database technologies. Mark holds certifications including CISSP, LPI, and Certified Technical Trainer, and is known for his hands-on teaching style and deep PostgreSQL expertise.

His training sessions blend deep technical insights with practical know-how, helping professionals develop real-world skills in PostgreSQL administration and performance optimization. With a strong focus on practical labs and applied learning, Mark ensures each participant walks away confident and capable of managing PostgreSQL in demanding environments.

Frequently Asked Questions

Why is PostgreSQL Administration training beneficial?

PostgreSQL is one of the most powerful and widely used open-source relational databases in the world. Gaining expertise in PostgreSQL administration positions you for high-demand roles in data management, system architecture, and DevOps. This course gives you the skills needed to deploy and maintain mission-critical databases while ensuring performance, security, and scalability—valuable assets in today’s data-driven organizations.

How many hours is the PostgreSQL Administrator course and how is it delivered?

The course runs for approximately 25 hours and is typically delivered over 3 full days in an instructor-led format. We also offer flexible learning formats to suit your schedule and learning preferences, including:

Part-time: Ideal for working professionals, with sessions in the evenings or on weekends.
Self-Paced: Learn at your own pace with access to comprehensive course materials and expert support.
Instructor-led Online: Join live, interactive classes from anywhere with a stable internet connection.
Instructor-led In-Person: Participate in hands-on sessions at our training centers or on-site at your premises.

What topics are covered in the PostgreSQL Administrator training?

This training covers a broad spectrum of PostgreSQL administrative topics, including:

Fundamentals: PostgreSQL architecture, installation, database creation, and user management
Configuration: Tuning server parameters for performance and stability
Security: Role-based access control, authentication, and data encryption
Backup & Recovery: Logical and physical backups, WAL archiving, and PITR
Replication & High Availability: Streaming and logical replication, failover strategies
Performance Tuning: Query optimization, indexing, VACUUM strategies, and monitoring
Advanced Topics: PostgreSQL extensions, concurrency control, partitioning, and troubleshooting

Who should take this course?

This course is ideal for:

Database Administrators currently working with or transitioning to PostgreSQL
System Administrators managing Linux/Unix-based database infrastructure
IT Professionals seeking to deepen their knowledge of database systems
Anyone responsible for ensuring the availability, performance, and security of PostgreSQL databases

Jumping Bean: pg-220 Postgresql Administration