Short, applied courses with a verifiable certificate. Search for a topic, or narrow by category, level, duration and price.
Learn to automate data integrity and auditing in PostgreSQL with triggers. You will write trigger functions in PL/pgSQL, choose BEFORE/AFTER and ROW/STATEMENT timing correctly, use NEW and OLD to validate and transform data, and build a reusable audit-log trigger — while avoiding recursion, ordering and performance pitfalls.
Write server-side database logic in PostgreSQL using PL/pgSQL. You will build functions that return scalars, rows and sets, write procedures with transaction control, handle errors with exception blocks and RAISE, and judge when logic belongs in the database rather than the application.
Administer a PostgreSQL database securely from end to end — manage roles and privileges, enforce row-level security, lock down connections through pg_hba.conf, and take dependable logical and physical backups. You will finish able to grant least privilege, protect data in transit, and restore a cluster to a chosen point in time.
Learn to run PostgreSQL in production — configure streaming replication and read replicas, choose between synchronous and asynchronous commit, plan failover, pool connections with PgBouncer, partition large tables, and monitor the metrics that keep a cluster healthy. You finish able to design and operate a resilient, scalable PostgreSQL deployment.
Work confidently with semi-structured data in PostgreSQL — store and query JSONB, index it with GIN, model repeated values with arrays, and build a real full-text search. You will finish able to choose between relational and document modelling and ship queries that are both correct and fast.
