Signing you in…

Stored Procedures and Triggers

Logic inside the database: procedures and triggers

Sometimes it is not enough just to store data - you need the database to react to changes. For example, it automatically recorded who and when changed the price of a product in an online store, or checked the conditions before saving. To do this, PostgreSQL uses stored functions (and procedures in the broad sense) and triggers: the code is executed next to the data, without additional round-trip into the application.

Content is available with subscription.
Get full access to all courses on the platform for one year with a single payment.
Unlike other platforms that charge per course, here you get everything for one price, and after one year of use there will be no automatic charge for the following year.