Course Outline
1. Introduction to PL/pgSQL Programming Language for Government
- Code blocks
- Variables
- Conditional instructions
- Loops
- Exceptions
- Built-in functions
- Comments
2. Implementing SQL Operations for Government
- Static and dynamic SQL
- Executing DML commands
- Executing SELECT queries (single-row, single-column, multiple-rows)
3. Implementing Stored Procedures and Functions for Government
- Parameter passing modes
- Overloading
- Functions that return collections
4. Implementing Triggers for Government
- 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 for Government
- PgAgent architecture
- Defining a job
- Using diagnostic tables and views
Requirements
- Fundamental knowledge of SQL and relational databases
- Practical experience with any programming language (e.g., Python, Java, C#, etc.)
Audience
This course is designed for Application Developers, Data Engineers, and Database Developers who are responsible for creating stored functions, triggers, and database-side logic in PostgreSQL. It aligns with the needs of professionals working on projects for government and other public sector entities.
Testimonials (5)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
Amount (a lot) of knowledge provided. Cheerful aprroach to the subject.
Oskar Debowski - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
Shivam - Paessler LLC
Course - PostgreSQL Fundamentals
By the end of the 1st day, one attendee suggested more interaction in practices and the trainers took this in for the second day.
Daniela - Unit4
Course - PostgreSQL 16 for Developers and Administrators
A factual and practical approach to the subject. A nice atmosphere, conducive to asking questions.
