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