Back

Certified PostgreSQL Developer(CPSDBD)

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.

Course Contents:

  1. Writing Queries using psql
  2. Creating, Altering and Truncating a Table
  3. Inserting, Deleting, and Updating Data from the Tables
  4. Data Types, Operators, and Usage
  5. PostgreSQL Constraints
  6. The Procedural Language: PL/pgSQL
  7. Working with Indexes
  8. Triggers & Rules
  9. Window Functions
  10. Interface Details (.Net, DBI, etc.)
  11. Statement behaviour
  12. Optimization
  13. Partitioning
  14. PostgreSQL Large Objects
  15. Foreign Data Wrappers
  16. PostgreSQL Using LibPQ
  17. Extensions

Exam Details:

  • Course Number: -PG900DEV

Prerequisites:

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

Virtual live Training

Training Expired