Home
Courses
PostgreSQL Administration: Hands-On Training

PostgreSQL Administration: Hands-On Training

Course 2112

Duration: 3 days
Language: English
Level: Intermediate

Unlock the full potential of PostgreSQL with this comprehensive three-day, instructor-led course. Designed for database administrators and IT professionals, this hands-on training equips you with the skills to install, configure, manage, and optimize PostgreSQL databases across multi-platform environments. Learn to implement robust backup and recovery strategies, enhance performance and scalability, and ensure efficient routine maintenance. Whether you're transitioning to PostgreSQL or expanding your expertise, this course provides the practical knowledge needed to thrive in today’s database landscape.

PostgreSQL Administration Course Information

In this course, you will:

Gain hands-on experience installing and configuring PostgreSQL on diverse platforms, ensuring you can adapt to any environment.
Master the skills to efficiently manage database clusters, schemas, roles, and tablespaces, enabling seamless organization and access control.
Learn to implement reliable backup, recovery, and disaster recovery solutions to safeguard critical data.
Discover techniques to optimize PostgreSQL databases for peak performance, even as workloads grow.
Acquire tools and strategies for routine database upkeep and server performance monitoring, ensuring long-term stability and efficiency.

Prerequisites

Basic Knowledge of RDBMS Concepts: Familiarity with relational database principles, SQL queries, and common database objects like tables, indexes, and views.
Experience with Command-Line Tools: Comfort with using command-line interfaces for database administration tasks.
Understanding of Operating Systems: Basic experience with Linux/UNIX and Windows operating systems, including file systems and user account management.
Technical Background: Prior experience as a database administrator or similar technical role is beneficial but not required.

Exam Information

Learning Tree exam included.

PostgreSQL Administration Training Outline

Learning Objectives

Day 1: Foundations of PostgreSQL Administration

Chapter 1: Course Introduction

Overview of course materials and agenda.
Introductions and expectations.

Chapter 2: Installation and Configuration

PostgreSQL versioning.
Installation on Linux/UNIX platforms.
Basic server configuration.
Post-installation setup and account management.

Chapter 3: PostgreSQL Architecture

PostgreSQL instance overview.
Data processing, shared memory, and directory structures.
Configuration files and WAL architecture.

Chapter 4: Client Applications and Database Setup

Introduction to client tools (psql, pgAdmin).
Database creation, configuration, and management.
Troubleshooting common client connection issues.

Day 2: Advanced Administration and Security

Chapter 5: PostgreSQL Schemas

Schema concepts and management.
Information and system catalog schemas.

Chapter 6: Role Management

Role creation, attributes, and membership.
Troubleshooting role access issues.

Chapter 7: Fine-Grained Access Control

Grant and revoke commands.
Managing column-level permissions and schema privileges.

Chapter 8: Index Creation and Management

Index types and best practices.
Partial, unique, and multi-column indexes.
Reindexing and maintaining indexes efficiently.

Chapter 9: Transactions and Concurrency

Transaction properties and isolation levels.
Multi-version concurrency control.
Deadlock detection and advisory locks.

Day 3: Optimisation, Maintenance, and Recovery

Chapter 10: Database Structure and Tablespaces

Physical storage layout.
Creating and managing tablespaces.

Chapter 11: Logging and Extensions

Configuring PostgreSQL logging.
Installing and managing extensions.

Chapter 12: Backup and Recovery

Methods for database backup and restore.
pg_dump, pg_restore, and point-in-time recovery.

Chapter 13: Query Optimisation and Performance Tuning

Using EXPLAIN and ANALYZE to optimise queries.
Index and query planner statistics.
Memory settings and performance tuning parameters.

Chapter 14: Routine Maintenance and Monitoring

Configuring autovacuum and routine cleanup tasks.
Monitoring activities and statistics.
Efficiently populating databases.

Get This Course £1,780

3-Day Instructor-Led Training
Hands-On Training
After-Course Instructor-Coaching Included

Get the Advantage £3,150

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

Include dates with afternoon start times

#2112

Apr 9 - 11 9:00 AM - 4:30 PM BST

London or Virtual
Apr 30 - May 2 2:00 PM - 9:30 PM BST

Herndon, VA or Virtual
May 21 - 23 9:00 AM - 4:30 PM BST

London or Virtual
Jun 11 - 13 2:00 PM - 9:30 PM BST

Ottawa or Virtual
Jul 9 - 11 9:00 AM - 4:30 PM BST

London or Virtual
Jul 30 - Aug 1 2:00 PM - 9:30 PM BST

Herndon, VA or Virtual
Aug 20 - 22 9:00 AM - 4:30 PM BST

London or Virtual
Sep 10 - 12 2:00 PM - 9:30 PM BST

Ottawa or Virtual
Oct 8 - 10 9:00 AM - 4:30 PM BST

London or Virtual
Oct 29 - 31 1:00 PM - 8:30 PM GMT

Herndon, VA or Virtual
Nov 19 - 21 9:00 AM - 4:30 PM GMT

London or Virtual
Dec 10 - 12 2:00 PM - 9:30 PM GMT

Ottawa or Virtual

Scroll to view additional course dates

Bring this or any training to your organization
Full-scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

Get the Advantage £3,150

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#2112

Questions about this course?

Customise Your Team Training Experience

Fill out the form below or call 44 (0) 207 874 5000

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

PostgreSQL Administration FAQs

This course is ideal for database administrators, IT professionals, and systems architects who are transitioning to multi-platform environments or looking to enhance their PostgreSQL expertise. It's also suitable for organizations leveraging PostgreSQL alongside other database technologies like SQL Server or Oracle.

While prior PostgreSQL experience is not required, participants should have a basic understanding of relational database concepts and experience working with databases such as SQL Server, MySQL, or Oracle.

The course covers PostgreSQL versions 17.2, 16.6, 15.10, 14.15, and 13.18, ensuring participants gain skills applicable to a wide range of environments.

Yes, this course is highly relevant for cloud-based deployments, including PostgreSQL on Azure, AWS RDS, and other cloud platforms. The curriculum includes installation, configuration, and optimization techniques for both on-premises and cloud environments.

Participants will learn how to install and configure PostgreSQL, manage clusters and schemas, implement robust backup and recovery solutions, optimize performance, and monitor server performance effectively. These skills are crucial for administering PostgreSQL databases in modern IT environments.

PostgreSQL Administration: Hands-On Training

PostgreSQL Administration Course Information

PostgreSQL Administration Training Outline

Learning Objectives

Upgrade your course experience with: Subscriptions

Get the Advantage £3,150

Thank you for choosing subscriptions!

Upgrade your course experience with: Subscriptions

Get the Advantage £3,150

Thank you for choosing subscriptions!

PostgreSQL Administration FAQs

Who is this course designed for?

Do I need prior experience with PostgreSQL to take this course?

What PostgreSQL versions are covered in this course?

Is this course suitable for cloud-based PostgreSQL environments?

What are the key benefits of attending this course?

Related Courses