PostgreSQL Course for Developers
PostgreSQL is an open-source object-relational database with over 30 years in a market with strong reliability, feature robustness, and performance.
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 training course covers SQL, DML, DDL, PL/pgSQL language and basic performance diagnostics. Attendees will learn how to work with a PostgreSQL development environment, 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
שעות אקדמיות - בסיסי ומתקדם
רמת הקורס - עברית
שפת הדרכה 
לבדיקת התאמה לקורס
ממליציםלעוד קורסים בתחום
לפתיחה והורדת סילבוס