IT Brain Training

8-2-619/2/1/1 Suite 304-A
Banjara Hills, Road No 11
Hyderabad, 500034


PostgreSQL is the world’s most advanced open source database. Developed over 25 years by a vibrant and independent open source community, PostgreSQL was born from the same research as Oracle and DB2 and contains comparable enterprise class features such as full ACID compliance for outstanding transaction reliability and Multi-Version Concurrency Control for supporting high concurrent loads.
PostgreSQL supports standards such as ANSI SQL and SQL/MED (including foreign data wrappers for Oracle, MySQL, MongoDB and many others) and yet is highly extensible with support for over 12 procedural languages, GIN and GIST Indexes, Spatial data support, and multiple NoSQL like features for document (JSON) or key-value based applications.
  • 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