EDB301 EDB Postgres for Developers and Architects

Date/Time
August 16, 2021 - August 18, 2021
09:00 - 17:00

EDB Postgres Architecture and how to design and develop applications with PostgreSQL

This 3-day course, PG301 EDB Postgres for Developers and Architects gives you the essential skills for application development with PostgreSQL / EDB Postgres Advanced Server backend. Learn about Postgres data types, database objects, indexes, transactions, connectors, client tools, extensions, foreign data wrappers and various other SQL functionalities. You will also learn a multi-step plan for SQL tuning and an overview of PLSQL compatible stored procedure language (SPL) in EDB Postgres Advanced Server.

This class is available in v12.

Course Outline

• PostgreSQL / EDB Postgres Advanced Server introduction.
• User Tools.
• Transactions and Concurrency.
• EDB Postgres Database Connectors
• Extensions in EDB Postgres.
• Database Designing.
• Data Types.
• SQL Primer.
• Indexes.
• SQL Tuning and Optimization.
• Stored Procedural Language.

Target Audience

• This course is designed for experienced Database Developers who are new to EDB Postgres and want to gain the essential as well as advanced skills required to effectively design and use EDB Postgres databases as a backend for their new or existing applications.

Recommended Prerequisites

• Familiarity with programming languages and concepts of SQL.
• Working knowledge of relational databases.
• Basic knowledge of Linux or Windows.

Recommended next exam or course

• PG201 Advanced PostgreSQL Administration
• EDB201 Postgres Advanced Server DBA Advanced
• PostgreSQL Associate Certification
• PostgreSQL Professional Certification