PostgreSQL3 - Foundations of PostgreSQL Administration

18 000 CZK
Course length: 
3 dny

In this course you will learn the essential details of PostgreSQL Administration including PostgreSQL architecture, configuration, maintenance, monitoring, backup, recovery, and data movement. It is designed for people with experience in database administration who are new to PostgreSQL

This class conveys the knowledge you will need to perform your duties as a PostgreSQL DBA, and is the foundation for the advanced courses that follow in the DBA track.

All of the topics tested in the PostgreSQL Associate Certification exam will be covered, including:

  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • Introduction to PSQL
  • pgAdmin III
  • Security basics
  • SQL
  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance
  • Postgres Data Dictionary
  • Moving Data