Development

Certified PostgreSQL Developer

Descriptions

A PostgreSQL Developer is a professional who specializes in developing applications that interact with the PostgreSQL database. They are responsible for designing, implementing, and optimizing database schemas, writing efficient SQL queries, and developing database-driven applications.

PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

Prerequisites:

Basic Structured Programming Knowledge or experience
Linux or Windows OS
PostgreSQL basics and/or SQL basics

Program Outline

Writing Queries using psql
Creating, Altering and Truncating a Table
Inserting, Deleting, and Updating Data from the Tables
Data Types, Operators, and Usage
PostgreSQL Constraints
The Procedural Language: PL/pgSQL
Working with Indexes
Triggers & Rules
Window Functions
Interface Details (.Net, DBI, etc.)
Statement behaviour
Optimization
Partitioning
PostgreSQL Large Objects
Foreign Data Wrappers
PostgreSQL Using LibPQ
Extensions

Exam Number

PG900DEV

Exam Requirements

All candidates interested in becoming Certified PostgreSQL Developer are encouraged to attend hands-on instructor-led training at CertFirst or through one of its affiliated partners.

Exam Details:

Number Of Questions:60 Questions

Time Allocated:90 Minutes

Minimum Pass Requirement: 70%

Certification Renewal is required every three years.

Target Audience:

share it :

Development

Certified PostgreSQL Developer

Descriptions

Target Audience:

Start your learning journey today! Enroll now in our online course.

Newsletter