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.
- 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
- Basic Structured Programming Knowledge or experience
- Linux or Windows OS
- PostgreSQL basics and/or SQL basics
Course Number: -PG900DEV
- Basic Structured Programming Knowledge or experience
- Linux or Windows OS
- PostgreSQL basics and/or SQL basics
| COURSE FEATURES |
|---|
|
Lectures - 18 |
|
Videos Duration - 40 hours |
|
Skill level - All levels |
|
Language - English |
Note: Classroom & Virtual live Training includes Examprep Tools
Register Now:
Customized Training
1. Choose your training preference date 2. Virtual Live Group Training 3. Class Room Group Training 4. Class Room On-Site Group Training 5. Virtual Live1-1 Mentoring 6. Class Room 1-1 Mentoring