Pre-Conference Training
Introduction to PostgreSQL 18
2 Days | 18 - 19 Nov 2026 | Instructor-Led | Hands-On Labs
Build practical skills through hands-on learning, interactive workshops, and real-world exercises designed to accelerate your professional growth.
Prerequisites
- Fundamentals of Databases and SQL
- Basic knowledge of Unix OS
Skills to be gained
- General idea of PostgreSQL architecture
- Basics of Installation, Configuring, and Managing the server
- Physical and Logical data layout
- Basic Administration tasks
- Authentication and Access Control
- Overview of Backups and Replication
Topics
Day 1 – Foundations & Core Concepts
Getting Started
- Installation and Management; psql
- PostgreSQL Overview
Core Internals
- Isolation and MVCC
- Vacuum
- Buffer Cache and WAL
Database Organization
- Logical Structure
Day 2 – Advanced Topics & Practical Application
Storage & Monitoring
- Physical Structure
- Monitoring
Security & Administration
- Access Control Overview
- Backup Overview
High Availability
- Replication Overview