We are currently offering a world class PostgreSQL database administration training programme for interested students and professionals. Registration for our PostgreSQL classes is open for anyone in the world because it is an online course.


This course covers the following topics:
 Installing & Configuring PostgreSQL
 Host access control with pg_hba.conf
 Configuring PostgreSQL for secure access with OpenSSL
 Using the psql client
 Creating & Managing Views (including updateable views.)
 Creating & Managing Indexes
 Creating Indexes
 Indexes on expressions
 Partial indexes
 Transactions and Concurrency
 Managing database privileges
 Understanding PostgreSQL roles
 User Roles
 Assigning users to roles
 Understanding role access
 Access control with GRANT
 PostgreSQL data organization
 PostgreSQL storage
 Managing table space usage
 PostgreSQL log directories
 Other directories
 Managing PostgreSQL clusters
 Creating & Managing PostgreSQL tablespaces and databases
 PostgreSQL Schemas
 PostgreSQL logging
 Backup and recovery (pg_dump, pg_dumpall, file system backups, pg_basebackup)
 Continuous Archiving and Point-in-time-recovery
 PostgreSQL Write-ahead logs
 Performing PITR backups
 Performing PITR recovery
 Server monitoring & performance tuning
 Understanding & Managing Auto-Vacuum
 PostgreSQL Hot Standby & Streaming Replication
 Setting up streaming replication
 Understanding and Managing performance of streaming replication
 Synchronous and Asynchronous replication
 Monitoring replication
 Connection Pooling for Web Applications with pgBouncer
Class Size:
This class is maximum 1 or 2 members.
Languages of class:
Tamil,English