Ashnik & EDB Postgres hosted a 5-day comprehensive administration training in Singapore from 3rd – 7th Sept’18. This comprehensive course included the basics of PostgreSQL Administration Training and some key advanced concepts. The training prepared the learners for day-to-day Administrative and Management tasks to be performed as a PostgreSQL DBA and slowly scale up to manage large and highly available databases, with ease and confidence.
The Course covered:
- Introduction and Architectural Overview
- PostgreSQL System Architecture
- Installation
- PPAS Installation
- Database Clusters
- Configuration
- Creating and Managing Databases
- User Tools: Command Line Interfaces
- GUI Tools
- Security
- SQL Primer
- Backup and Recovery & Point-in-Time Recovery
- Routine Maintenance
- Data Dictionary
- Moving Data
- Transaction and Concurrency
- Performance Tuning
- Table Partitioning
- High Availability and Replication
- Extension Module
