Catalogue
/
Databases
/
PostgreSQL for Administrators

PostgreSQL for Administrators

Dive deep into the world of PostgreSQL administration. This intensive training course is meticulously designed for system administrators and database architects, offering a detailed overview of PostgreSQL administration and performance tuning.

Equip yourself with the tools to master advanced PostgreSQL modules like replication, connection pooling, and full text searching.

What will you learn?

Dive deep into the world of PostgreSQL administration. This intensive training course is meticulously designed for system administrators and database architects, offering a detailed overview of PostgreSQL administration and performance tuning. Equip yourself with the tools to master advanced PostgreSQL modules like replication, connection pooling, and full text searching.

  • In-depth knowledge of PostgreSQL's history and conventions.
  • Hands-on sessions on installation, SQL language, and advanced features.
  • Insights into performance optimization, server setup, and high-availability solutions. By the end of the course, attendees will:
  • Understand advanced PostgreSQL modules such as replication, connection pooling, and full-text searching.
  • Be equipped to manage databases, perform backups, and ensure high availability.
  • Possess the expertise for efficient PostgreSQL server administration and performance tuning.

Requirements:

Attendees should have a basic working knowledge of SQL.

Course Outline*:

*We know each team has their own needs and specifications. That is why we can modify the training outline per need.

Introduction to PostgreSQL
  • What is PostgreSQL?
  • Brief History of PostgreSQL
  • Conventions and Further Information
  • Bug Reporting Guidelines
Getting Started with PostgreSQL
  • Installation and Database Creation
  • Introduction to the SQL Language
SQL Language Deep Dive
  • Advanced SQL Features
  • Syntax, Data Definition, and Manipulation
  • Queries, Data Types, and Functions
  • Indexes, Triggers, and Full Text Search
Advanced PostgreSQL Features
  • Foreign Data Wrappers
  • PL/pgSQL - SQL Procedural Language
  • Concurrency Control and Performance Tips
Server Administration
  • Installation (Source Code vs Distribution, Windows considerations)
  • Server Setup and Operation
  • Database Physical Storage and Configuration
  • Client Authentication and Database Roles
  • Managing Databases and Routine Maintenance
  • Backup, Restore, and Recovery Configuration
Monitoring and Maintenance
  • Monitoring Database Activity and Disk Usage
  • Reliability with Write-Ahead Log
  • Installation of Third-Party Server Extensions
High Availability and Replication
  • Understanding Brewer's CAP Theorem
  • Replication Strategies (Synchronous vs. Asynchronous)
  • Different Replication Techniques and their Applications
  • Connection Pooling with Pgpool
Failover and Recovery
  • Configurations using DRBD
  • Replacing Failed Servers
  • Recovering from Network Partitions

Hands-on learning with expert instructors at your location for organizations.

0
Graph Icon - Education X Webflow Template
Level: 
Intermediate
Clock Icon - Education X Webflow Template
Duration: 
14
Hours (days:
2
) 
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.
Get Quote

Master new skills guided by experienced instructors from anywhere.

0
Graph Icon - Education X Webflow Template
Level: 
Intermediate
Clock Icon - Education X Webflow Template
Duration: 
14
Hours (days:
2
) 
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.
Get Quote

You can participate in a Public Course with people from other organisations.

0

/per trainee

Number of Participants

1 Participant

Thanks for the numbers, they could be going to your emails. But they're going to mine... Thanks ;D
Oops! Something went wrong while submitting the form.
Graph Icon - Education X Webflow Template
Level: 
Intermediate
Clock Icon - Education X Webflow Template
Duration: 
14
Hours (days:
2
) 
Camera Icon - Education X Webflow Template
Fits ideally for individuals and small groups
Star Icon - Education X Webflow Template
Networking opportunities with fellow participants.
*Price can range depending on number of participants, change of outline, location etc.
Get Quote