Register Now and enjoy 25% off on your first 5 courses (Published Courses & Group / Batch Classes)
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
Lear what are Postgresql functions and their benifets.
.Learn what are Postgresql functions and their benifets.
How to apply each function type in a Postgresql server.
practice with examples of all types of functions/
10 years practical experience with Postgresql database... and Postgres Pro :
1- Databases (cluster)
3a- Install fully encrypted cluster of databases from customized package.
3b- Create databases,tables,views,domains .
3c- Assign permissions(Roles & Authorities) to users.
3d- Replicate(backup) the master server cluster to a replica server...for Postgresql and PosftresPro.
3e- Optimize queries performance with indexes ,Partitioning of tables & Sharding of databases.
3f- extensive knowledge of PL/PGSQL(Triggeres,Functions & Procedures)
3f- Logging and monitoring of database activities.
2- Create SSL certificates for the Server,Intermediate,Chain,Client .
3- ERD & EER diagrams for database ..and converting the diagram into database Physical Data Model.
4- Apply Postgresql to Android applications & Web Applications
5- Flutter : Build android application user interface (U.I).
6- Ubuntu server : install & optimize.
Click for more0 Rating
General information about the Functions structure
00:23:43
Create a function structure
00:23:08
Types of variables and parameters we can use with functions
00:09:03
Function body implementations and queries
00:09:46
What are data types we can RETURNS from a function
All implementations of RETURNS RECORD composite type with SELECT query
Function RETURNS RECORD composite type using insert/update/delete with RETURNING
25% off Convert between BINARY, OCTAL, DECIMAL & HEXADECIMAL numbers with ease and increase your analytical and critical thinking skills.
25% off Understanding the concept of Pl/PGSQL. Defining Types of Postgresql PL/PGSQL. Understanding Triggers and their role in a program. Defining types of
25% off 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
25% off Welcome to "Building Web Applications with Django and PostgreSQL"! This course is designed to provide you with a comprehensive understanding of how
In this course, we will learn: 1.What is the meaning of Data? What is the meaning of Information? What is the difference between Da
25% off 1. What is meaning of “Data”? 2. What are the main differences between “Data” and “Information”? 3. What is me
25% off 1. What are the current trends and areas of interest in DBMS? 2. What is meant by Open source DBMS? 3. What is the meaning of Cloud-based DBMS? Wh
25% off 1. What is the full form of ACID? 2. Which are the fundamental principles of a Database Management System? 3. What is meant by Atomicity? 4. What
25% off 1. What are the various advantages of DBMS? 2. What is meant by Data Independence? 3. What is the meaning of Data Redundancy? 4. What is meant by
1. What is the full form of DBMS? 2. What is meant by Database management system? 3. What is the benefit of DBMS to users? 4. How DBMS mana
1. What is meant by Data? 2. What is the meaning of information? 3. What are the various differences between data and information? 4. Which is us
25% off Interested in the field of Machine Learning? Then this course is for you! This course has been designed by two professional Data Scientists so that w
25% off Learn The Full Stack Web Development 2023 Course, The first step to the full-stack web development you need to learn to succeed in the core basics of
25% off In this course, we will learn the basic tools that every Web developer needs to know. We will start from scratch by learning how to implement web de
25% off In this course, we will learn the basic tools that every Web developer needs to know. We will start from scratch by learning how to implement modern w
25% off Learn how to use SQL quickly and effectively with this course! This SQL course is without a doubt the most comprehensive database course avai
25% off Learn how to use SQL for Data Science quickly and effectively with this course! This Masterclass on SQL course is without a doubt the most co
25% off Learn how to use MySQL for Data Science quickly and effectively with this course! This Masterclass on SQL course is without a doubt the most
