PostgreSQL 9.6 Associate Certification


comp name

This Certification helps candidates to demonstrate their postgres db fundamental skills necessary to manage and maintain a Postgresql server and applications in a production environment.

Exam Details


Required Exam(s) PostgreSQL 9.6 Associate
Durations 60 mins (50 Questions)
Passing Score 70%
Question Types Multiple choice
Exam Fees $200 USD
Prerequired Exams None
Exam Policy N/A
Recommended Training Foundations of Postgres Administration

Exam Pattern

Below are the exam objectives for PostgreSQL 9.6 Associate Certification

Questions will be asked from the following topics.

  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • Creating and Managing Databases
  • User Interfaces: PSQL and pgAdmin4
  • Database
  • clusters
  • Security
  • SQL Queries and Data Handling
  • Backup and Recovery
  • Point--in Time Recovery
  • Routine Maintenance
  • Data Dictionary
  • Moving Data

Books to Prepare

PostgresQL Cover Image

Book Name : Learning PostgreSQL

Author Name : Salahaldin Juba, Achim Vannahme, Andrey Volkov

Publisher :

Topics Covered in this book:

  • 1. Relational Databases
  • 2. PostgreSQL in Action
  • 3. PostgreSQL Basic Building Blocks
  • 4. PostgreSQL Advanced Building Blocks
  • 5. SQL Language
  • 6. Advanced Query Writing
  • 7. Server Side Programming with PL/PgSQL
  • 8. PostgresQL Security
  • 9. The PostgreSQL System Catalog and System
  • 10. Optimizing Database Performance
  • 11. Beyond Conventional Data types
  • 12. Testing
  • 13. PostgreSQL JDBC
  • 14. PostgreSQL and Hibernate

Softwares for Practice

Software: PostgreSQL 9.6

License : Free

Click here to download the free copy PostgreSQL Latest Edition