PostgreSQL database management

Duration: 5 days
  • PostgreSQL versions and features
  • Operating system considerations
  • Hardware requirements
  • Authentication
  • Relational database model
  • Concurrency issues
  • Transactions and isolation levels
  • Locking and deadlock handling
  • Application considerations
  • Data definition language
  • Data integrity constraints
  • Keys and indexes
  • Complex SQL query construction
  • Extensible data types
  • Updatable views and triggers
  • Write ahead logging mechanism
  • Recovery and replication techniques
  • Transaction performance debugging
  • Benchmarking