2-Day Intro

2-Day Introduction to PostgreSQL 11

About the course

Duration: 2 days


  • basic understanding of databases and SQL
  • acquaintance with Unix

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

Student guide

Before self study the course please make sure to read the Student Guide to learn how to set up the environment and get instructions on how to perform practices.


 Introductionslides  video
 Basic Toolkit    
1.Overview: Installation and Management, psqlslidesdemosolutionvideo
2.General Overviewslides  video
3.Isolation and Multiversion Concurrency Controlslidesdemosolutionvideo
4.Buffer Cache and Loggingslidesdemosolutionvideo
 Data Organization    
5.Logical Layoutslidesdemosolutionvideo
6.Physical Layoutslidesdemosolutionvideo
 Administration Tasks    
 Access Control    
9.Access Control Overviewslidesdemosolutionvideo
 Backup and Replication    
10.Backup and Restore Overviewslidesdemosolutionvideo
11.Replication Overviewslidesdemosolutionvideo


Video was recorded in February 2019 durig pgDay Israel 2019 in Tel Aviv (playlist).

You can download all course materials in a single archive.