Detailed Course Outline
- Essentials
- PostgreSQL System Architecture
- Installation
- Configuration
- Creating and Managing Databases
- Introduction to PSQL
- pgAdmin III
- Security Basics
- SQL Primer
- Backup and Recovery
- Point--βin Time Recovery
- Routine Maintenance
- Postgres Data Dictionary
- Moving Data
- Advanced Topics
- Transactions and Concurrency
- Performance Tuning
- Table Partitioning
- High Availability & Replication
- Monitoring
- Extension Modules