Course Code: bsppsql
Duration: 21 hours
Course Outline:

Bespoke - PostgreSQL

 

PostgreSQL Administration

  • Architecture overview
  • Configuring the Server
  • Setting up and Managing Users
  • Setting Permissions & Security
  • Monitoring
  • Logs

Performance Optimization

  • Reducing I/O with HOT
  • Locking & Concurrency
  • Evaluating the Design of the Database
  • Optimizing SQL Queries with EXPLAIN
  • Inspecting the Workload
  • Benchmarking and Profiling
  • Query optimization
  • Using Indexes Efficiently / index types
  • Memory management
  • Extensions

PostgreSQL Replication & Backup & HA

  • Logical & Physical backups
  • PITR
  • Transactional Log archiving
  • Overview of PostgreSQL Replication
  • High Availability in PostgreSQL
  • Streaming Replication (sync / async)
  • Upgrading PostgreSQL
  • PgPool