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
