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
Trusted by Leading Organizations
Esteemed Clients We Served
Esteemed Companies Where Our Alumni Work