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.

3.072€*
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.

Master new skills guided by experienced instructors from anywhere.

2.037€*
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.