No Comments

Ashnik organizes a 5-day Comprehensive EDB Postgres Administration Training in Singapore

by , , No Comments


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