Course Topics

• Introduction to PostgreSQL Server and Advance Features
• Postgres Client Server Architecture
• Installing 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