Postgresql PL/PGSQL Functions – Part 2

Published 1/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 830.99 MB | Duration: 1h 37m
Improve your database performance with PL/PGSQL Functions

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
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 courseIn 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 functionWe 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 Loopshow to use PERFORM and EXECUTEAll 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
Overview
Section 1: Introduction
Lecture 1 Functions RETURNS void
Lecture 2 Functions RETURNS SETOF
Lecture 3 Functions taking OUT parameter
Lecture 4 Functions RETURNS Table
Lecture 5 Functions RETURNS Scalar variable taking Multiple parameters
Lecture 6 Functions using FOR loop with different RETURNS types
Lecture 7 Functions using FOREACH loop with Multiple rows entry
All Levels of developers

Homepage

www.udemy.com/course/postgresql-plpgsql-functions-part-2/