2-Day Introduction to PostgreSQL 11

About the course

Duration: 2 days

Prerequisites:

  • 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.

Topics

 Introductionslides  video
 Basic Toolkit    
1.Overview: Installation and Management, psqlslidesdemosolutionvideo
 Architecture    
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    
7.Monitoringslidesdemosolutionvideo
8.Maintenanceslidesdemosolutionvideo
 Access Control    
9.Access Control Overviewslidesdemosolutionvideo
 Backup and Replication    
10.Backup and Restore Overviewslidesdemosolutionvideo
11.Replication Overviewslidesdemosolutionvideo

Additional

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

You can download all course materials in a single archive.