+49 (0) 30 5201 4923
info@orb-experts.com
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.
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.
Attendees should have a basic working knowledge of SQL.
*We customize the course outline and content to your specific needs and relevant use cases.
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.
Master new skills guided by experienced instructors from anywhere.
