Certified PostgreSQL Developer(CPSDBD)
![](https://skillswares.com/wp-content/uploads/2024/12/cpsdbd-1.png)
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:
- 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 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