Visit [ Ссылка ] to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.

This video is about Stored Procedure in SQL. We look at what is a procedure, what is the purpose of using a procedure in SQL, syntax for creating and executing a procedure and also we shall create simple yet realistic procedure with and without parameters. We cover the concept of SQL Procedure for the most popular RDBMS such as PostgreSQL, Oracle, Microsoft SQL Server and MySQL.

All the scripts and dataset used in this video can be downloaded for free from my discord channel.

Link to join my discord below:
[ Ссылка ]

My Recommended SQL Course:
[ Ссылка ]

My Recommended platform to practice writing SQL queries:
[ Ссылка ]

My Live SQL Course on Lighthall:
[ Ссылка ]

Timestamp:
00:00 Introduction to procedure tutorial
02:12 What is a procedure
03:07 What is the purpose of using a procedure in SQL
04:31 Syntax to create a procedure in PostgreSQL
09:18 Syntax to create a procedure in Oracle
10:22 Syntax to create a procedure in Microsoft SQL Server
13:07 Syntax to create a procedure in MySQL
15:58 Create and execute a procedure without parameters in PostgreSQL
26:38 Create and execute a procedure without parameters in Oracle
30:48 Create and execute a procedure without parameters in Microsoft SQL Server
34:54 Create and execute a procedure without parameters in MySQL
38:41 Create and execute a procedure with parameters in PostgreSQL
51:51 Create and execute a procedure with parameters in Oracle
56:18 Create and execute a procedure with parameters in Microsoft SQL Server
01:02:28 Create and execute a procedure with parameters in MySQL

If you like my videos, do consider subscribing.
🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:
[ Ссылка ]

✅ SQL Tutorial - Intermediate concepts:
[ Ссылка ]

✅ SQL Tutorial - Advance concepts:
[ Ссылка ]

✅ Practice Solving Basic SQL Queries:
[ Ссылка ]

✅ Practice Solving Intermediate SQL Queries:
[ Ссылка ]

✅ Practice Solving Complex SQL Queries:
[ Ссылка ]--

✅ Data Analytics Career guidance:
[ Ссылка ]

✅ SQL Course, SQL Training Platform Recommendations:
[ Ссылка ]

✅ Python Tutorial:
[ Ссылка ]

THANK YOU,
Thoufiq

свернуть