PL/pgSQL: PostgreSQL procedural language

In this two day ABIS course, the PostgreSQL programming language PL/pgSQL is explained and extensively practiced.

During the development and/or control of programs for database processing, application programmers, developers and DBAs need more than the basic relational possibilities of SQL in a PostgreSQL database.

Therefore the objectives of this course are:

to describe and exercise the procedural characteristics that are added by PL/SQL to SQL;
to know the advantages of using stored procedures, functions and triggers.

Schedule a training?

Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

REQUEST IN-COMPANY TRAINING

Public training calendar
date	dur.	lang.	location	price
10 Dec	2		Leuven	1710 EUR (excl. VAT)
10 Dec	2		web based	1710 EUR (excl. VAT)
SESSION INFO AND ENROLMENT

Intended for

This course is designed for application programmers, developers and DBAs.

Background

Knowledge of PostgreSQL relational database systems, SQL and the concepts behind procedural languages.

Main topics

Introduction PL/SQL:
'Inline' versus 'Stored' procedures
SQL support:
Writing SQL in a procedural environment
Variables and constants - records, collections:
Explicit declaration • implicit declaration
Logical comparisons:
If-then-else structure
Conditional and iterative control:
For-loop • do-while loop • loop-endloop • goto
Cursor management:
Implicit and explicit cursors • attributes • cursor-for loop
Error treatment:
Pre-defined exceptions • application exceptions
Procedural objects:
functions • stored procedures • triggers

Training method

Classroom instruction with practical exercises.

Certificate

At the end of the session, the participant receives a "Certificate of Completion".

Duration

2 days.

Course leader

Kris Van Thillo (ABIS), Peter Vanroose (ABIS).

SESSION INFO AND ENROLMENT