• views: 143
• date: 29 January 2023
• posted by: voska89

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

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

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.