Lectures

PL/pgSQL is a procedural programming language built right into PostgreSQL. In this lecture, you'll find out why it's useful, how it's different from regular SQL, where it's used, and you'll see a simple example of a PL/pgSQL function. This is your first step toward automating stuff and coding logic right inside your database!

PL/pgSQL is a procedural language for PostgreSQL that lets you implement business logic, automation, error handling, and complex algorithms right on the server side. In this lecture, you'll learn about the benefits of PL/pgSQL, where to use it, see real examples of functions, triggers, and error handling, and check out some practical cases from the IT world.

In this article, we compare three popular procedural languages for DBMS: PL/pgSQL (PostgreSQL), PL/SQL (Oracle), and T-SQL (SQL Server). You'll learn about their similarities, differences, syntax quirks, error handling, working with cursors, transaction and JSON support, and you'll see code examples for the same task in each language.

In this lecture, you'll get to know the basic structure of PL/pgSQL blocks, learn how to declare variables, use control structures, handle errors, and write simple scripts to automate stuff in PostgreSQL. Examples and tips will help you pick up the syntax fast and dodge common mistakes.

In this lecture, you'll learn how to use the main PL/pgSQL data types: INTEGER, TEXT, BOOLEAN, and RECORD. We'll go over what they're for, their quirks, code examples, and common mistakes, so you can confidently use them in your PostgreSQL procedures and functions.