Postgresql PL/PGSQL Functions -part 1
Learn all about Postgresql functions and their benefits, types of PL/PGSQL functions, and how to apply each function type in a Postgresql server. Practice with examples of all types of functions and improve your database performance. This course is suitable for all levels of Postgresql developers.
What you’ll learn
- Lear what are Postgresql functions and their benifits
- Learn the types of PL/PGSQL Functions types
- How to apply each function type in a Postgresql server
- practice with examples of all types of functions
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.
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.
P.S : THIS FUNCTIONS course in total consist of 2 parts with more than 15 videos divided in 2 parts in compliance with UDEMY rules
Who this course is for:
- all levels of Postgresql developers
