Beskrivning
Prerequisites:
fundamentals of databases and SQL and 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
Topics
Basic Tools
1. Installation and Management; psql
Architecture
2. PostgreSQL Overview
3. Isolation and MVCC
4. Vacuum course materials
5. Buffer Cache and WAL
Data Organization
6. Logical Structure
7. Physical Structure
Administration Tasks
8. Monitoring
Access Control
9. Access Control Overview
Backup and Replication
10. Backup Overview
11. Replication Overview
Recensioner
Det finns inga recensioner än.