Procedure Tutorial in SQL | SQL Stored Procedure | Procedure in SQL

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

[TheRaju]

Thank you very much for covering all different SQL platforms. I don't see anyone taking the effort to teach all 4 to help everyone. Much appreciated!

[rahulv]

Your are bahubali of SQL tutorials 👌👌👌

[PallabNath-tooq]

This is by far the best SQL tutorials on the internet, better than a lot of paid resources

[karangupta_DE]

one of the best explanations of a stored procedure with an actual use case, thank you so much for the video.

[shivammadaan]

Thanks a lot Thoufiq, whenever I have to learn anything about SQL, your channel is the first I go through and as always you did justice to teaching it simply but elegantly. Thanks a lot my dear friend.

[garybou]

I really like speed of this tutorial, no kicking tires!
For someone who has experience in multiple DBs need just refresh key words and style to write store procedures!!! Awesome👋👋👋 !

[ryuhayabusa]

THIS MAN MAKES LEARNING EASIY, THANK YOU SO MUCH FOR ALL YOU DO FOR US. GOD BLESS YOU BROTHER;

[manupriyar]

It's an awesome video.. Great effort Tafiq.. Please give more examples in real time scenario as well. Also please do videos regarding in real time scenario how we will do it like using a tool such as SSIS Or UNIX something like this..

[saibhargav]

Hi Tofik,
I am impressed of your teaching. Kindly, Hoping you will do a video on functions too. It will be much useful to compare with procedures as well most of the interview pannel posting a question diff b/w procedures and functions.
Thankyou.

[itikalaneelu]

This is the best explaination about stored procedures. Its like spoon feeding.

[skriesten]

Great explanation on this. Good reference for the future when I need it. Keep them coming. Thanks for all your videos.

[brendensong]

Very comprehensive tutorial! Thank you for sharing!!!

[Rainbow_Academy]

Just started learning SQL and I'm amazed how you explain things to look that easy. Keep it up💞🎖️🔥

[hasanmougharbel]

Hey there, Great efforts in this channel.
I have learned recently about assemblies.
In what way, Assemblies are different from stored procedures?
I appreciate your help at your sole convenience.
Thanks a lot.

[ShawnTheSheep]

awesome video, as practical as an example can get!
as compact as possible!
thank you!

[sushmashreem.t]

Superb teaching..We get more interest on Sql after seeing your videos...

[adarshpandey]

There are so many tutorials out there but you are damn too good.

[Platoface]

I am working on Version 8.0.18 which does not support Materialized views natively. I have an issue with performance in crosstabs when I query a decently large table for unique patient ids for YTD. It takes about 3-5 mins depending on what YTD months. After Jan-Apr the query deteriorates exponentially with each passing month. So I just created an aggregated table that I run each month. But the materialized view would have been nice to use. You are a good teacher and teach at a good pace with limited filler which I really like. Thank you.

[theskillverze]

Hi @techTFQ thank you for the amazing content on Procedures. It cleared lot of things in my head. I just had a request to make: Can you please do 1 or 2 videos on Triggers ? I tried searching a lot but didn't find any good videos explaining the same so hoping you could help. Thanks in advance

[prabhulakhera]

Thank you techTFQ sir, your way of teaching is best