PostgreSQL Developer Training - PFE 727
Software development training compatible with PostgreSQL.
It is a unique training program designed for software developers who want to fully utilize the power of PostgreSQL while developing applications in PostgreSQL.
Purpose
This training aims to educate individuals who will work as Linux system administrators or software developers, with the goal of equipping participants with the skills to perform installations on the system, make necessary configurations, and intervene in and resolve issues by the end of the program.
Target Audience
Software developers and database experts who write programs using databases, and develop functions, procedures, and triggers.
Training Notes
Training materials will be distributed electronically in PDF format.
Certification
A certificate of participation will be issued by Profelis.
Prerequisites
PFE723 PostgreSQL System Administrator, PFE721 PostgreSQL Fundamentals or Linux for PostgreSQL PFE111 Having received the training.
Training Duration
- Class: 5 days / 30 hours
- Remote: 5 days / 20 hours
Training Topics
- PostgreSQL Data Types, Functions and Operators
- Structure and Behaviors of Queries
- Transactions
- Foreign Key
- Window Functions
- JSON and XML
- Inheritance in Tables
- Index Types and Characteristics
- View and Materialized View
- Recursive Queries
- Common Table Expressions
- Grouping Sets
- PL/pgSQL
- Functions and Procedures
- Triggers
- PostgreSQL Extensions
- pgLoader
PostgreSQL Certificate
