PostgreSQL Developer for developer of other DBMS

Client Interfaces

• Command Line Interface – psql
• Graphical Interface - pgadmin4

Understanding PostgreSQL Data Types

• Numeric data types
• Character types
• Binary data types
• Date & time types
• Boolean values
• Array types
• Other data types

Working with array values

Performing type casting and conversion

Transactions and Concurrency

• Transactions and Isolations
• Multi-Version Concurrency Control

Server Programming

• Extending SQL
• Triggers
• The Rule System
• Procedural Languages
• PL/pgSQL - SQL Procedural Language
• Error Handling
• Cursors

Foreign Data Wrappers

• Extension in PostgreSQL
• Adding FDW in a Database
• postgres_fdw
• file_fdw
• Other FDWs

SQL Tuning

• Logging in PostgreSQL
• Query Plans
• Optimizing Queries
• Statistics
• Planner Parameters
• Parallel Query Scans
• SQL Best Practices
• Indexes
• Table Partitioning