Intended Audience
This course is intended for:
- Database administrators
- Database developers
- Database architects
- Database engineers
Course Objectives
In this course, you will learn how to:
- Understand the architecture of a PostgreSQL database
- Read, write, and edit data in a PostgreSQL database
- Store data in a PostgreSQL database
Prerequisites
We recommend that attendees of this course have the following prerequisites:
- Taken the PostgreSQL Fundamentals course
- Familiarity with relational databases
- Familiarity with structured query language (SQL)
Delivery Method
This course is delivered through:
- Digital training
Duration
1 hour
Course Outline
This course covers the following concepts:
- Client Architecture
- Server Overview
- Process Components
- Memory Components
- Per-Session Memory
- Data Directory
- base Directory
- Block / Page Layout
- Storing Large Values
- TOAST Table
- pg_wal Directory
- On-Disk Components
- In-Motion
- Connect Request
- Reading Data
- Writing (or deleting) Data
- MVCC
- Logical Layout
- Logical-Physical Mappings