Course Topics

  • Introduction to PostgreSQL Server and Advance Features
  • Postgres Client Server Architecture
  • Instnewing the PostgreSQL Server
  • Creating a Cluster
  • Running Server
  • Configuring of PostgreSQL Server .
  • Postgres hosed based access configuration
  • Client and Tools - PSQL & pgAdmin
  • Creating and Managing Databases
  • Databases and Schemas
  • Tablespaces
  • Exploring Databases
  • Obtaining Metadata
  • Transactions & Concurrency Control
  • Database Administration
  • Table Partitioning
  • Extensions
  • Security, Encryption and Auditing
  • Monitoring and Diagnosis
  • Performance and Concurrency
  • Find and Tune Slow Running Queries
  • Discovering why a query is not using an index
  • Forcing a query to use an index
  • Regular Maintenance
  • Backup and Recovery
  • Planning backups
  • Moving Data
  • Replication and Upgrades
  • Replication best practices
  • Streaming Replication
  • Implement Hot Standby
  • Replication Slots
  • Logical Replication
  • Using repmgr
  • Upgrading PostgreSQL

Trusted by Leading Organizations

Esteemed Clients We Served



Esteemed Companies Where Our Alumni Work