Webové stránky používají k poskytování služeb, personalizaci reklam a analýze návštěvnosti soubory cookie. Informace, jak tyto stránky používáte, jsou sdíleny se společností Google. Používáním souhlasíte s použitím souborů cookie. Více informací.

Rozumím

Course code: POSQLD

PosgreSql for db Developers

This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

Course overview

The SQL Language

  • SQL Syntax

  • Data Definition

  • Data Manipulation

  • Queries

  • Data Types

  • JSON

  • Functions and Operators

  • Type Conversion

  • Indexes

Transactions and Concurrency

  • Transactions and Isolation

  • Multi-Version Concurrency Control

Server Programming

  • Extending SQL

  • Triggers

  • The Rule System

  • Procedural Languages

  • PL/pgSQL - SQL Procedural Language

  • Error Handling

  • Cursors

SQL Tuning

  • Logging in PostgreSQL

  • Query Plans

  • Optimizing Queries

  • Statistics

  • Parallel Query Scans

  • SQL Best Practices

  • Indexes

Course price

€510 (excl. VAT)
€617 (incl. VAT)

Available terms

Date Guaranteed Location Language Duration
24. January 2022 - Prague Czech 2 days Register

Virtual Course

Date Language Duration
24. January 2022 Czech 2 days Register
7. February 2022 Czech 2 days Register
14. February 2022 English 2 days Register
9. May 2022 Czech 2 days Register
16. May 2022 English 2 days Register
25. July 2022 Czech 2 days Register
19. September 2022 English 2 days Register
12. December 2022 Czech 2 days Register
19. December 2022 English 2 days Register

Alternative terms

Suggested dates do not suit you? Contact us for an alternative date.

Contact us