For the global PostgreSQL community, mastering database administration is a critical step towards building robust and efficient systems. Recognizing this, Postgres Professional is excited to announce the release of the English version of our popular course, DBA1: Basic PostgreSQL 16 Administration. This course serves as a bridge from foundational knowledge to confident, professional-level PostgreSQL administration, providing deep insights into server management, architecture, and essential daily tasks.
All course materials, including a student guide for setting up a virtual machine for practical assignments, are freely available on the official Postgres Professional website.
Who is this course for?
The "Basic PostgreSQL 16 Administration" course is designed for all who have basic knowledge of databases, SQL, and Unix-like operating systems and are looking to build or solidify their database administration skills. It is especially useful for:
Junior database administrators seeking a structured path to learn PostgreSQL installation, configuration, and management.
Application developers who want to gain a deeper understanding of the database they work with to improve application performance and reliability.
System administrators who are responsible for maintaining PostgreSQL servers and need to gain understanding of administration, backup, and replication.
Students and specialists studying database technologies, who wish to gain practical, hands-on experience.
What's inside?
The course covers the most critical aspects of PostgreSQL administration over a recommended duration of three days. It systematically unveils the complexities of PostgreSQL, reinforcing theory with practical labs. Key topics include:
Basic tools & setup. Get started with server installation, management using psql, and essential server configuration.
PostgreSQL architecture. Provide a basic introduction to PostgreSQL fundamentals, including the transaction system with isolation and MVCC, the importance of vacuuming, and the mechanics of the buffer cache and write-ahead log (WAL).
Data organization. Understand how data is structured at both logical and physical levels, from databases and schemas to tablespaces and low-level file structures.
Essential administration. Learn key administrative tasks, including server monitoring, to ensure your database runs smoothly.
Security and access control. An overview of managing user access and securing your data.
Backup and replication. Grasp the fundamental concepts of backup strategies and explore overviews of both physical and logical replication to ensure data availability and disaster recovery.
Key strengths of the course
The course is distinguished by its strong practical focus. A dedicated student guide helps you set up a virtual environment, allowing you to immediately apply the concepts learned in each lesson.
The material is comprehensive and up-to-date, focusing on PostgreSQL 16. The logical progression from initial setup to advanced topics like replication ensures a solid learning curve. Backed by the expertise of the Postgres Professional team, the course guarantees high-quality, reliable information, making it a valuable resource for professional growth in the world of PostgreSQL.
How to access the course
The complete course materials, including presentations and the student guide, can be downloaded for free from the Postgres Professional community portal.