Databases

• PostgreSQL for Python Programmers (14 hours delivered over 2 days, online and on-site)

  Build fast, secure Python apps on PostgreSQL 18: SQL and schema design, JSONB, PL/pgSQL, async SQLAlchemy 2.0 with asyncpg, pandas, and pgvector search.

• PostgreSQL for Administrators (21 hours delivered over 3-5 days, online and on-site)

  Hands-on PostgreSQL administration: secure, monitor, tune, back up, and operate PostgreSQL 16, 17, and 18 in production.

• PostgreSQL Stored Procedures and Functions (14 hours delivered over 2-4 days, online and on-site)

  PL/pgSQL deep-dive: writing stored procedures, functions, triggers, window functions, and dynamic SQL on modern PostgreSQL.

• Amazon RDS for PostgreSQL (21 hours delivered over 3-5 days, online and on-site)

  Hands-on AWS RDS PostgreSQL admin: secure, monitor, tune, back up, and troubleshoot for uptime and cost.

• Azure PostgreSQL Flexible Server (21 hours delivered over 3-5 days, online and on-site)

  Build, secure, scale, and monitor PostgreSQL on Azure Flexible Server for real workloads.

• SQL Fundamentals (14 hours delivered over 2 days, online or on-site)

  A standards-first introduction to SQL on PostgreSQL 18: the relational model, SELECT, joins, aggregation, subqueries, CTEs, and window functions.