Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
21 Hours
Testimonials (3)
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
I genuinely enjoyed the trainer Subject Knowledge.
