Postgresql PL/PGSQL Functions in-depth - part 1
Improve your database performance with PL/PGSQL Functions
Updated on Jun, 2025
Language - English
Development ,Database and Design Development,PostgreSQL
Lectures -7
Duration -1.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
If you are a database developer and performance is a goal to achieve with your DB design, then using PL/PGSQL functions is an excellent tool.
In this course we will learn all about functions :
Usage benefits.
Structure & structure components.
Syntax to create a function.
The core part of any function is the body; we will see examples of which parts the body builds.
We see the different kinds of implementations in the body, starting with the variables, queries and the return results.
We see with examples the different datatypes that we can RETURNS from a function
We see the parameters that we can use to create a function.
How to deal with different types of data that we process in a function such as ARRAY and mix data types value…
How to RETURNS TABLES, RECORDS or Scalar variables.
How to use special queries such as insert, update, delete with returning ... or use INTO clause and how to apply FOR & FOR EACH Loops
how to use PERFORM and EXECUTE
All this we will practice with live examples on a Postgresql server.
P.S: THIS FUNCTIONS course in total consists of 2 parts with more than 15 videos divided into 2 parts in compliance with rules
Goals
- Learn what PostgreSQL functions are and their benefits.
- Learn the types of PL/PGSQL Functions types.
- How to apply each function type in a Postgresql server.
- practice with examples of all kinds of functions.
Prerequisites
- Basic knowledge of Postgresql.
Curriculum
Check out the detailed breakdown of what’s inside the course
Postgresql Function
7 Lectures
-
Postgresql PL/PGSQL Functions introdution
21:56
21:56
-
Create a function structure
23:43
23:43
-
Functions Variables
23:08
23:08
-
Function body implementations and queries
09:03
09:03
-
What are data types we can RETURNS from a function
09:46
09:46
-
All implementations of RETURNS RECORD composite type with SELECT query
09:46
09:46
-
Function RETURNS RECORD composite type using insert/update/delete with RETURNING
14:45
14:45
Instructor Details
Mohammed Al Saadi
1- My main field of expertise is the Postgresql Database , with 12 years of work .
2- Flutter apps development both U.I and back end.
3- Cloud Postgresql database with Supabase platform.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now