PosgreSql for db Developers

Základní info

Popis kurzu

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.


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.

Určeno pro

Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.

Obsah kurzu

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



Studijní materiály

V angličtině

PosgreSql for db Developers

Vybraný termín:

1.12.2021  Bratislavský kraj

Cena
12300 Kč + 21 % DPH

Termíny kurzu

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je dvě a deset ? Součet zapište číslicemi.