Course structure
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
