Postgresql PL/PGSQL Functions in-depth - part 1
Improve your database performance with PL/PGSQL Functions
Databases,PostgreSQL,Development,Data Science
Lectures -7
Duration -1.5 hours
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 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 benefits.
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 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.
![Postgresql PL/PGSQL Functions in-depth - part 1 Postgresql PL/PGSQL Functions in-depth - part 1](https://d3mxt5v3yxgcsr.cloudfront.net/courses/14504/course_14504_image.png)
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](https://www.tutorialspoint.com/assets/profiles/607269/profile/200_1638027-1677222902.jpeg)
Mohammed Al Saadi
I'm focused mainly on :
1- Postgresql database : Installation from a customized source code & encryption of the DB cluster with data-at-rest encryption .
2- Security of data & connections : the database encryption , SSL Certificates(ROOT,Intermediate,trust-chain, Server & Client) & also creating SSLSockets for both the server & the client using customized provider such as Bouncy Castle with FIPS mode.
3- GUI building using JavaFX & Jfoinex .
4- The Ubuntu Server both installation & configuration (creating users,firewal, netplan networking).
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)