Intro
2-Day Introduction to PostgreSQL 15
About the course
Duration: 2 days
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
Student guide
When using the course for self-study, check out the Student’s Guide to learn how to set up the virtual machine and do practical assignments.
Topics
| Introduction | course materials | ||
| Basic Tools | |||
| 1. | Installation and Management; psql | course materials | |
| Architecture | |||
| 2. | PostgreSQL Overview | course materials | |
| 3. | Isolation and MVCC | course materials | |
| 4. | Vacuum | course materials | |
| 5. | Buffer Cache and WAL | course materials | |
| Data Organization | |||
| 6. | Logical Structure | course materials | |
| 7. | Physical Structure | course materials | |
| Administration Tasks | |||
| 8. | Monitoring | course materials | |
| Access Control | |||
| 9. | Access Control Overview | course materials | |
| Backup and Replication | |||
| 10. | Backup Overview | course materials | |
| 11. | Replication Overview | course materials |
You can download all course materials in a single archive.
Previous version of the course for PostgreSQL 11
2-Day Introduction to PostgreSQL 11
About the course
Duration: 2 days
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
Student guide
When using the course for self-study, check out the Student’s Guide to learn how to set up the virtual machine and do practical assignments.
Topics
| Introduction | slides | video | |||
| Basic Toolkit | |||||
| 1. | Overview: Installation and Management, psql | slides | demo | solution | video |
| Architecture | |||||
| 2. | General Overview | slides | video | ||
| 3. | Isolation and Multiversion Concurrency Control | slides | demo | solution | video |
| 4. | Buffer Cache and Logging | slides | demo | solution | video |
| Data Organization | |||||
| 5. | Logical Layout | slides | demo | solution | video |
| 6. | Physical Layout | slides | demo | solution | video |
| Administration Tasks | |||||
| 7. | Monitoring | slides | demo | solution | video |
| 8. | Maintenance | slides | demo | solution | video |
| Access Control | |||||
| 9. | Access Control Overview | slides | demo | solution | video |
| Backup and Replication | |||||
| 10. | Backup and Restore Overview | slides | demo | solution | video |
| 11. | Replication Overview | slides | demo | solution | video |
Video was recorded in February 2019 during pgDay Israel 2019 in Tel Aviv (playlist).
You can download all course materials in a single archive.