Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Postgresql PL/PGSQL Functions - part 2
Rating: 3.5 out of 5(2 ratings)
16 students

Postgresql PL/PGSQL Functions - part 2

Improve your database performance with PL/PGSQL Functions
Created byMohammed N.S. Al Saadi
Last updated 1/2023
English

What you'll learn

  • Learn what are Postgresql functions and their benifets
  • 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

Course content

1 section • 7 lectures • 1h 37m total length

  • Functions RETURNS void9:21

    Functions that RETURNS void

  • Functions RETURNS SETOF13:55

    Functions that RETURNS SETOF any type

  • Functions taking OUT parameter8:08

    Functions that takes OUT parameter

  • Functions RETURNS Table15:53

    Functions RETURNS table using RETURN QUERY and RETURN NEXT

  • Functions RETURNS Scalar variable taking Multiple parameters11:51

    Functions RETURNS Scalar variable taking Multiple parameters .. and Functions Returns Scalar ARRAY

  • Functions using FOR loop with different RETURNS types20:52

    Functions using FOR loop with different RETURNS types

  • Functions using FOREACH loop with Multiple rows entry17:20

    Functions using FOREACH loop with Multiple rows entry

Requirements

  • knowledge of Postgresql

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 is the 2nd part of this course

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 developers

Report abuse