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
PostgreSQL Training
India, Karnataka, Bangalore
Published 3 years ago
ID #157
1 photo
Check with advertiser
PostgreSQL Training
India, Karnataka, Bangalore,
Published 3 years ago