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
What will you learn in this course:
- 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
What are the prerequisites for this course?
- 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
eCourse 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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now