Course code: PostgreSQL3« Back

Foundations of PostgreSQL Administration

In this course you will learn the essential details of PostgreSQL 9.6 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. This official EnterpriseDB (EDB) course includes one complimentary attempt at the PostgreSQL Associate Certification exam.

 DateDurationCourse priceHandbook priceCourse languageLocation 
5/13/2020 3 19 800 CZK included in course price Český jazyk GOPAS Praha
3/25/2020 3 880,00 EUR included in course price Slovenský jazyk GOPAS Bratislava

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 19 800 CZK included in course price 30
Brno3 19 800 CZK included in course price 30
Bratislava3 880,00 EUR included in course price 30

User intensity level

Who the course is for

  • The primary audience for this course is individuals who administer and maintain PostgreSQL databases

After completing this course, students will be able to:

  • Understand database architecture
  • How to install and implement database system
  • How to configure database system
  • Create and maintain databases
  • How to work with user command line tools and GUI tools
  • How to secure database system
  • Understand basic database system terms and help
  • Create Backup and restore strategy
  • Design and implement database maintenance
  • How to move data
  • Using metadata

Required skills

  • Intermediate knowledge of RDBMS concepts
  • Basic understanding of SQL
  • Basic experience with use of the Linux operating system (helpful)

Teaching methods

Expert instruction with practical examples, computer practice


Printed presentations or documantation


  • People considering taking the Associate Certification exam are strongly encouraged to complete the associated training course on Foundations of PostgreSQL Administration
  • This course includes one complimentary attempt at the PostgreSQL Associate Certification exam
  • This class presents the minimum knowledge of concepts and skills required to achieve this certification.

Course Outline

  • System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • User Tools: Command Line Interface
  • GUI Tools
  • Security
  • SQL Primer
  • Backup and Recovery
  • Point in Time Recovery
  • Routine Maintenance Tasks
  • Postgres Data Dictionary
  • Moving Data

        Previous courses

        no preceding courses

        Next courses

        no following course
        Elektronická příručka kurzu PostgreSQL3

        included in course price
        The prices are without VAT.

        Graph of course relations