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.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
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