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