Pre-Conference Training

Introduction to PostgreSQL 18

Build practical skills through hands-on learning, interactive workshops, and real-world exercises designed to accelerate your professional growth.

Duration: 2 Days • Instructor-Led • Hands-On Labs

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
  1. Installation and Management; psql
  2. PostgreSQL Overview
  3. Isolation and MVCC
  4. Vacuum
  5. Buffer Cache and WAL
  6. Logical Structure
Day 2 – Advanced Topics & Practical Application
  1. Physical Structure
  2. Monitoring
  3. Access Control Overview
  4. Backup Overview
  5. Replication Overview