Course Outline
1. Introduction to PL/pgSQL Programming Language
- Code blocks
- Variables
- Conditional instructions
- Loops
- Exceptions
- Built-in functions
- Comments
2. Implementing SQL Operations
- Static and dynamic SQL
- Executing DML commands
- Executing SELECT queries (single-row, single-column, multiple-rows)
3. Implementing Stored Procedures and Functions
- Parameter passing modes
- Overloading
- Functions that return collections
4. Implementing Triggers
- Data change triggers
- System event triggers
- Trigger functions
- For each row/statement triggers
- OLD and NEW variables
- AFTER/BEFORE triggers
- WHEN clause
5. Implementing Batch Jobs with PgAgent
- PgAgent architecture
- Defining a job
- Using diagnostic tables and views
Requirements
- Basic understanding of SQL and relational databases
- Experience with any programming language (e.g. Python, Java, C#, etc.)
Audience
Application Developers, Data Engineers, and Database Developers who need to create stored functions, triggers, and database-side logic in PostgreSQL
Testimonials (3)
I expanded my knowledge on DB performance management, some are directly usable while others provide great insight/context for me.
Longze Chen - Center for Open Science
Course - PostgreSQL Advanced - Performance Management
how to use LLM in daily work
Cont - Everymatrix
Course - PostgreSQL AI: Introduction to semantic search
Tables indexes and qq reperforming & tuning in order to improve them