Detail kurzu

PostgreSQL for DB Developers

EDU Trainings s.r.o.

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.

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
Certifikát Na dotaz.
Hodnotenie




Organizátor



Ďalšie termíny kurzu
Termín Cena Miesto konania Zarezervovať