TR

PostgreSQL Administration Course

Course Audience

PG201
2 DAYS

System administrators who want to install and manage a PostgreSQL database service.

Course Prerequsities

Informations that required by participants before course:

  • Participants who will join this course should also have joined PG101, LSY103, LSY102, LSY101 courses before or mastered related subjects of these courses.

Course Goals

  • Understanding the basic logic of PostgreSQL operation
  • Installing the PostgreSQL service
  • Connecting to the PostgreSQL service with a client and executing commands
  • Restricting access to the PostgreSQL service and configuring security settings
  • Performing regular maintenance tasks on the PostgreSQL service
  • Examining the logs of the PostgreSQL service
  • Taking backups of the PostgreSQL service and restoring from backups when necessary
  • Knowing which metrics to monitor for PostgreSQL service and how to collect these metrics

Course Subjects

  • PostgreSQL Installation and Management
  • Overview of PostgreSQL
  • psql Client
  • pgAdmin III Client
  • Server Settings
  • Database Management
  • User Management
  • Authorization and Security
  • Monitoring
  • MVCC and VACUUM
  • Maintenance Operations
  • Data Migration and Test Environments
  • Server Logs
  • Backup