PostgreSQL Advanced Administration - 2 days Online Classroom
1.450,00 EUR
- 2 days
Take your PostgreSQL administration skills to the next level with this advanced course designed for professionals managing complex database environments. Learn how to optimise performance, strengthen security, manage high availability, and troubleshoot PostgreSQL systems effectively. Through practical, hands-on exercises, you’ll explore advanced administration techniques including database monitoring, backup and recovery strategies, replication, configuration tuning, and performance optimisation. Build the confidence to maintain reliable, scalable, and secure PostgreSQL databases that support demanding enterprise workloads.
Key Features
Language
Course and materials are in English
Level
Beginner - Intermediate level
2 days (8 hours / day) live classroom
with accredited trainers
40+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Upgrade
Learn how to upgrade PostgreSQL environments safely using methods such as pg_dump, pg_upgrade, and logical replication. Gain the skills to plan, perform, and validate upgrades with minimal service disruption.
Enhance
Enhance PostgreSQL security through authentication, role management, row-level security, SSL/TLS connections, SSH tunnelling, and data encryption using pgcrypto.
Improve
Improve database performance by implementing partitioning strategies, managing large datasets, and applying techniques that support faster queries and easier maintenance.
Build
Build reliable PostgreSQL environments using streaming replication, replication slots, and failover strategies to maintain availability and reduce downtime.
Course timeline
Day 1 – PostgreSQL Advanced Administration
Lesson 01
- Understand PostgreSQL versioning and upgrade methods using pg_dump, pg_upgrade, and logical replication.
- Plan and execute database upgrades with effective post-upgrade validation.
- Configure database security through authentication, roles, and access controls.
- Implement row-level security and encryption using the pgcrypto module.
- Manage user privileges and secure database access.
- Configure SSL/TLS connections and SSH tunnels for secure communication.
- Apply security practices while maintaining database performance.
- Gain practical experience securing enterprise PostgreSQL environments.
Day 2 – PostgreSQL Advanced Administration
Lesson 02
- Learn table partitioning concepts to improve scalability and query performance.
- Create and manage partitions using declarative and inheritance-based methods.
- Optimise large datasets through effective partitioning strategies.
- Configure streaming replication for high availability environments.
- Monitor replication, manage replication slots, and handle failover scenarios.
- Explore logical replication architecture, benefits, and limitations.
- Configure publications, subscriptions, and logical decoding.
- Apply replication techniques to support resilient PostgreSQL systems.
Who Should Enroll in this Program?
PostgreSQL Database Administrators (DBAs) looking to enhance their advanced administration skills.
System Administrators responsible for managing PostgreSQL environments.
Database Developers who need deeper knowledge of PostgreSQL performance and management.
DevOps professionals working with database deployment, automation, and infrastructure.
IT professionals responsible for database reliability, security, and optimisation.
Prerequisites
- A solid understanding of PostgreSQL fundamentals and basic database administration.
- Practical experience working with SQL and relational database concepts.
- Familiarity with PostgreSQL installation, configuration, and basic maintenance tasks.
- Experience with Linux/Unix command-line environments is recommended.
- Prior knowledge of database backup, recovery, and performance concepts is beneficial.
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.