Stored Procedures in PL/pgSQL for PostgreSQLPL/pgSQL

Currently there are no scheduled dates

Remote training: online live with a trainer and a group. Available on demand, at time and place convenient to you, for groups of at least 5 participants.

exempt from VAT

Price: 740 EUR

refreshments included

computer station included

Stored Procedures in PL/pgSQL for PostgreSQL

Category: PostgreSQL

Implementation of complicated business processes in database often requires using stored procedures. In case of PostgreSQL it means using Pl/pgSQL language. Although it’s SQL’s close relative it has some differences which open up new opportunities for programmers.

The training shows PL/pgSQL constructions, ways of defining and developing procedures and triggers. Basing on practical examples we show how to close the business logic processes inside stored procedures and what are benefits of applying such architecture. Students also learn writing new triggers which preserve data integrity.

We also discuss the best practises while creating PL/pgSQL procedures and we emphasise the most common mistakes. We show when using PL/pgSQL is neccessary and when the procedure in SQL only is sufficient. We explain the difference between the two mentioned approaches.

Our instructors have many years of experience with PostgreSQL, both as administrators and as programmers. One of our trainers is a PostgreSQL contributor and a regular speaker at the world’s largest conference on the topic.

Duration

2 days

Agenda

  1. Procedures defining
    • Input and output signature
    • Scalars return
    • Tables return
    • Volatile, stable, immutable procedures
  2. PL/pgSQL language
    • Language constructions
      • Variables declaration
      • Conditional expressions
      • Loops and cursors
    • Cooperation with SQL
    • Explicit SQL calls
      • Dynamic SQL
    • Exceptions handling
    • Complex procedures debugging
    • Best practices of writing a code
  3. Triggers
    • Triggers defining
    • Data acceptance, modification, discarding
    • Examples of the triggers usage

Download as PDF

Audience and prerequisites

We recommend that the participants know SQL language and have minimum experience with any programming language.

Certificates

Course participants receive completion certificates signed by ALX.

There are currently no entries

Enter your e-mail address and we will notify you about future dates

Question?

Ask us anything about this training

* I hereby give my consent to the processing of my personal data by ALX Training Ltd. for the purpose of this request.