Ashnik & EDB Postgres hosted a 5-day comprehensive administration training in Singapore from 3^rd – 7^th 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