PostgreSQL Course for Developers
Getting started with PostgreSQL!
PostgreSQL is a powerful open-source object-relational database with over 35 years in a market with strong reliability, feature robustness, and performance.
PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set and extensibility.
The dedication of the open source community behind the software deliver performant and innovative solutions.
Why use PostgreSQL?
PostgreSQL aimed to help developers build applications, administrators to protect data integrity, and help you manage your data no matter how big or small the dataset.
In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!
PostgreSQL Course for Developers
PostgreSQL course was designed for developers with SQL knowledge and experience, and focuses on functionality that are specific to PostgreSQL. This PostgreSQL training course covers SQL, DML, DDL, PL/pgSQL language and basic performance diagnostics.
Our future PostgreSQL developer will learn how to work with a PostgreSQL development environment, building database code, energizing the company’s cloud platform, among others, manipulate and query data.

PostgreSQL developers
This training (course) is ideal for those who are looking to migrate to PostgreSQL. It is designed for developers with minimal SQL knowledge seeking to leverage their server-side development skills.
Basic knowledge in SQL language.
- Preparing the PG Instance
- PostgreSQL for Windows
- PostgreSQL Docker for Linux
- Development tools
- pgAdmin
- DBeaver
- IDEA
- Connecting to PostgreSQL
- Creating a database/schema
- Loading the demo schema
- What is a database object?
- browsing the schema objects
- Hand-on Lab
- Learning SQL
- Creating a Tables (DDLs): data types, PK, Identity column
- DMLs: INSERT/DELETE/UPDATE
- Selecting Data
- JOINs (INNER, LEFT, RIGHT, OUTER)
- Built-In Functions
- Aggregate functions and GROUP BY
- ORDER BY
- Hand-on Lab
- Procedural Language – PL/pgSQL
- Basics of PL/pgSQL
- Functions
- Procedures
- Cursors (loop, case, if-then-else)
- Triggers
- Exception Handling
- The PERFORM and EXECUTE statements
- Autonomous Transactions
- Hand-on Lab
- Performance tuning
- Explain the explain
- Indexes, B-tree, FKs (constraints)
- Indexes on expressions
- Analyzing & optimizing queries
- טרם נקבע מועד פתיחה
- 09:00-16:30
ימים ושעות - 8
שעות אקדמיות - בסיסי ומתקדם
רמת הקורס - עברית
שפת הדרכה
לבדיקת התאמה לקורס
ממליציםלעוד קורסים בתחום
לפתיחה והורדת סילבוס
