Postgresql PL/PGSQL Functions in-depth -part 2
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 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 rules
Goals
What will you learn in this course:
- Learn what are Postgresql functions 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 types 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 in-depth - part 2
7 Lectures
- Functions that RETURNS void 09:21 09:21
- Functions that RETURNS SETOF any type 13:55 13:55
- Functions that takes OUT parameter 08:08 08:08
- Functions RETURNS table using RETURN QUERY and RETURN NEXT 15:53 15:53
- Functions RETURNS Scalar variable taking Multiple parameters .. and Functions Returns Scalar ARRAY 11:51 11:51
- Functions using FOR loop with different RETURNS types 20:52 20:52
- Functions using FOREACH loop with Multiple rows entry 17:20 17:20
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