Detail kurzu
POSQLD - PosgreSql 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
Cílová skupina
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
Kontaktní osoba
Lukáš Vallo
+420 724 792 023
lukas.vallo@edutrainings.cz