PostgreSQL 9.6 Professional Certification


comp name

PostgreSQL 9.6 Professional Certification assesses and certifies a database professional’s ability to work in demanding, large-scale, real-world production environments.

Exam Details


Required Exam(s) PostgreSQL 9.6 Professional
Durations 60 mins (50 Questions)
Passing Score 80%
Question Types Multiple choice
Exam Fees $200 USD
Prerequired Exams PostgreSQL 9.6 Associate Certification
Exam Policy N/A
Recommended Training Advanced PostgreSQL Administration

Exam Pattern

Below are the exam objectives for PostgreSQL 9.6 Professional Certification

Questions will be asked from the following topics.

  • Installation of PostgreSQL Sources
  • SQL Tuning
  • Performance Tuning
  • Performance Benchmarking
  • WAL Archiving
  • Connection Pooling
  • Table Partitioning
  • Extensions
  • Foreign Data Wrappers
  • Monitoring
  • Streaming Replication
  • Database Security

Books to Prepare

Postgresql

Book Name : Mastering PostgreSQL 9.6

Author Name : Hans-Jurgen Schonig

Publisher :

Topics Covered in this book:

  • 1. PostgreSQL Overview
  • 2. Understanding Transactions and Locking
  • 3. Making Use of Indexes
  • 4. Handling Advanced SQL
  • 5. Log files and system Statistics
  • 6. Optimizing Queries for good Performances
  • 7. Writing Stored Procedures
  • 8. Managing Postgre Security
  • 9. Handling Backup and Recovery
  • 10. Making Sense of Backup and Replication
  • 11. Deciding on Useful Extensions
  • 12. Troubleshooting PostgreSQL
  • 13. Migrating to PostgreSQL

Softwares for Practice

Software: PostgreSQL 9.6

License : Free

Click here to download the free copy PostgreSQL Latest Edition