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 LanguageSQL 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
Podobné kurzy
podľa názvu a lokality