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.