Potgresql PL/PGSQL in-depth [ebook]
postgresql database procedural language PL/PGSQL
Language - English
Updated on Feb, 2025
About the Book
Book description
If you are a database developer and you put performance as goal to achieve with your DB design...then using PL/PGSQL functions is your excellent tool.
This book will show you by dozens of examples performed on real Postgresql server ..you will see how the Triggers, Functions and procedures work in real database world.
Page by page you will go deeper and deeper starting with the Triggers then moving to the functions and finally the Procedures.
You will learn each case and see it's implementation code in real database world.
If you wish to develop database like a pro using PL/PGSQL...then you reached to this textbook.
Enjoy your database development .
Goals
In this course we will learn all about functions :
Usage benifits.
Structure & structure components.
Syntax to create a function.
And the core part of any function which is the body ... we will see with examples of which parts the body build.
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 & FOREACH Loops
how to use PERFORM and EXECUTE
All this we will practice with live examples on a postgresql server.
![Potgresql PL/PGSQL in-depth [ebook]](https://d3mxt5v3yxgcsr.cloudfront.net/courses/21244/course_21244_image.png "Potgresql PL/PGSQL in-depth [ebook]")
eBook Preview
Author 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.
Our students work
with the Best
Related eBooks
Annual 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