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

Подписаться 306 тыс.

Просмотров 266 тыс.

50% 1

Visit brilliant.org/techTFQ/ 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:
/ discord
My Recommended SQL Course:
learnsql.com/?ref=thoufiqmoha...
My Recommended platform to practice writing SQL queries:
www.stratascratch.com/?via=te...
My Live SQL Course on Lighthall:
www.lighthall.co/profile/techTFQ
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 - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq

Опубликовано:

27 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 215

@techTFQ 2 года назад

Visit brilliant.org/techTFQ/ to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.

@michelchaghoury9629 2 года назад

Great vid can you please make q tutirial on how to download and install oracle database and how to configure it with the right settings to get started and learning iracle please?

@tamalmondal6158 3 месяца назад

Please share the link to download those dB, if I manually creating this entry from 1 after previous entry was loaded at 10.

@TheRaju991 Год назад

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!

@rahulv2265 2 года назад

Your are bahubali of SQL tutorials 👌👌👌

@techTFQ 2 года назад

haha thank you bro

@showripratury9202 Год назад

😂

@learningislife2934 Год назад

👍😁

@Prabhakaran-hp1to Год назад

😂😂😂

@sudharsansugumar3992 9 месяцев назад

😂

@karangupta_DE Год назад

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

@shivammadaan9498 Год назад

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.

@techTFQ Год назад

your welcome Shivam. I am very glad to read this

@ryuhayabusa3540 Год назад

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

@garybou8559 2 месяца назад

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👋👋👋 !

@itikalaneelu9126 11 месяцев назад

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

@brendensong8000 Год назад

Very comprehensive tutorial! Thank you for sharing!!!

@sushmashreem.t1823 2 года назад

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

@skriesten 2 года назад

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

@techTFQ 2 года назад

Thanks Steve, will do!

@ShawnTheSheep407 Год назад

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

@techTFQ Год назад

Thank you so much buddy

@adarshpandey8023 Год назад

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

@Rainbow_Academy Месяц назад

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

@prabhulakhera1430 Год назад

Thank you techTFQ sir , your way of teaching is best

@manupriyar8169 Год назад

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..

@deepshah2137 Год назад

Excellent as always!!!

@sudarshanmhaisdhune1039 Год назад

Wow man! simply outstanding.....!

@saibhargav4378 2 года назад

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.

@vellakibb9367 Год назад

One of the best video I have ever seen. Its so simple and easy to start from. Thanks @techTFQ.

@lkkota41 Месяц назад

Appreciate putting the differences.. Very helpful

@UpendraYadav-te8ov Год назад

Thank you so much bro for making such a wonderful video, well explained

@ramakumarguntamadugu1299 Год назад

thanks for sharing the great content! keep it up !

@itikalaneelu9126 11 месяцев назад

Thanks is just a small work. Keep up the good work

@usamaamir2511 Год назад

One of the bes ttutorial for SQL. I request you to make such kinds of tutorials for PowerBI with some projects. Love from Pakistan...

@jubburusrikanth509 Месяц назад

Brilliant work 👏

@odelolatechup1447 2 года назад

Am a big fan of your teachings. Keep it up sir, you are fantastic

@techTFQ 2 года назад

Thanks a lot brother :)

@xunianzu 2 года назад

This is very helpful. Thank you.

@techTFQ 2 года назад

Thank you Joe :)

@Platoface 26 дней назад

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.

@rishabhverma4735 6 месяцев назад

Best video on store procedure. Thankyou bhai for covering everything ❤.

@techTFQ 6 месяцев назад

Glad it helped

@sukritiguin5637 Год назад

Best SQL teacher on RU-vid ♥️🔥

@techTFQ Год назад

Thank you buddy

@yogeshmane9860 Год назад

Good work Sir, Keep it up

@Persianchannel1 Год назад

tnx bro. outstanding video 👏

@maheshp5244 2 года назад

Thanks sir , I'm waiting for this video

@techTFQ 2 года назад

I hope this helps Mahesh

@singh9661 Год назад

Hi Tofik, It's an too awesome video.. Great effort Tafiq.. Please give more examples in real time scenario as well. Please please make video on Trigger and Cursor as well. God Bless You !!!!

@harshshah9006 11 месяцев назад

Thank u so much for this !

@hasanmougharbel8030 Год назад

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.

@prajnamayadi1764 7 месяцев назад

Thoufiq excellent vedio lectures!!

@techTFQ 6 месяцев назад

Thank you:)

@bala9535 2 года назад

Wonderfull story telling comparing 4 diff category. Please do more vedio series.. it will help full us..

@techTFQ 2 года назад

Thank you Balaji :)

@user-yr5oi6ns8c 10 месяцев назад

Bahut acha kaam karta ho aap

@NEG0POS 2 года назад

Superb ! Keep up the good work ...

@techTFQ 2 года назад

Thank you :)

@dinesh.p8642 7 месяцев назад

Thank you TFQ ji

@hritikdalal5633 10 дней назад

Awesome presentation, explained in a crisp and clear manner, Hats off the Tutor🫡

@satindersingh2562 2 года назад

Keep it up 👍. Great Efforts

@techTFQ 2 года назад

Thank you :)

@me_svr16 Год назад

Hi Thank you for the content. Is there a way to sanitise those inputs declared in the parameter of procedure? if so can you tell me how

@SatyamKumar-lj5bi 2 года назад

Thanks man for the video

@techTFQ 2 года назад

Your welcome Satyam

@murchhanabanerjee862 6 месяцев назад

Hi Taufiq, excellent video as always ❤ why don't you cover cursor & error handling as well ? is there any separate video for that ?

@Buzzingfact 2 года назад

Thanks for the video👍

@techTFQ 2 года назад

Your welcome bro

@sivadurgaprasadjatla8115 Год назад

Hi Brother...will you please make a detail video about the difference between procedures and funtions?

@theskillverze 11 месяцев назад

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

@SandyCoco1 2 года назад

I'm trying to relate this with functions in Python Thanks for this video sir. I've not gotten to this stage yet but a pre-knowledge is not bad

@TheRaju991 Год назад

Though I haven't used this in a work context because in most cases Analysts will only have Read permissions, these are exactly like functions.

@SandyCoco1 Год назад

@@TheRaju991 true You know in functions you don't write the codes again

@omkargurme20 2 месяца назад

awesome video, thanks, also a request, can you make more videos on PL-SQL , thanks

@basavapn6487 2 года назад

Thanks for this video and could you please make the next video including collection types and cursors in Procedure

@techTFQ 2 года назад

sure, will cover it as part of my PL SQL series in the future

@dgh25 Год назад

Nice!

@itikalaneelu9126 11 месяцев назад

You are a gem

@manoganesan7618 2 года назад

Could you please explain that how to send multiple parameters? Like IN condition in the WHERE Caluse.

@nada-rw6iy 3 месяца назад

thank you!!

@Kirankumar-ml1ro Год назад

Tq u buddy!! Will you please upload a video on pl/SQL fucntions

@JD_2 Год назад

great stuff

@honestreview6900 2 года назад

Wish u a very happy Eid Taufiq

@techTFQ 2 года назад

Thank you bro, saw this a little late :)

@qurdedu4032 2 года назад

Hey Tofik thank you so much for the great materials. I was wondering, if you would create real time examples in SQL intermediate and advance lvl.

@techTFQ 2 года назад

you mean SQL queries right? I have already done it and will continue to do it

@nisha6165 2 года назад

Thanks a lot for the vedio😀

@techTFQ 2 года назад

Glad you liked it Nisha

@julagantivenkatavyshnavi5301 Год назад

Hi Thoufiq, I have a doubt. When you used current_date in MySql, it worked in procedure without parameters, but it didn't work in case of procedure with parameters. Why?

@nayeem3905 2 года назад

Hello, Would be willing to create a video on how to troubleshoot and optimize stored procedure? Thank you

@Neropil Год назад

Amasing, thx for lessons. Could you explain, when and who use procedure..like even with this example, who should do it? And if it must be automatizete, how? I mean if someone but ipad, it's procedure or smth will called without you

@Luvxaurora Год назад

Omg another way of escaping quotes

@lokeshreddy7479 2 года назад

Hai tofik, I'm great fan of your teaching. especially, the way you teach is simply awesome 👌. But if you could do any video on t-sql (or) pl-sql, it will be very helpful for us... 👍Thank you Tofik.

@techTFQ 2 года назад

Thank you Lokesh :) and sure will consider it

@skumar05 2 года назад

Thanks sir to upload this video big thanks

@techTFQ 2 года назад

I hope you like it Rahul 🙏🏼

@skumar05 2 года назад

@@techTFQ not only this video sir all your video is excellent I always watch only your video.by watching your video I am gaining sql knowledge day by day.

@sibanandakhatei9634 2 года назад

Thanks for this

@techTFQ 2 года назад

My pleasure bro!

@ratneshraj6086 2 года назад

Well covered but need a video using output paramaters Also cover user defined function and triggers

@techTFQ 2 года назад

Noted bro, will do

@user-lh4no5ve3u 11 месяцев назад

Hi sir, Can you Please upload how to update records from multiple tables(different tables) using stored procedure

@rohitjaiswal8116 Год назад

@techtfq please make videos for performing tuning of Store procedure

@rika0729 4 месяца назад

please the text editor / IDU u are using sir... or someone else, please tell..!!

@Behappy-ft5yc 10 месяцев назад

hii sir, can we put a condition to check if the input quantity is not 0, since the query will update sales table for 0 as an input to the required quantity, i am still a beginner and finding it difficult as to how should i put this condition

@anupsinghrana5735 Год назад

I have a question "You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result set after executing the Joins. The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority. What should you use?" ---- so what would be the answer and why: Stored procedure or Materialized view........kindly give your valuable guidance

@shubhamkapoor85 10 месяцев назад

Is the difference between t-sql pl/sql and standard sql is the stored procedure?

@ksharsha17 7 месяцев назад

@techTFQ How to call a Parameter when it is table type?

@junedkhan-ge5mi 4 месяца назад

when you execute select * from product how they reduce quantity ?

@manideepgubba3536 Год назад

Also Explain the stored procedures for snowflake database

@user-qk9qs1lc5b 8 месяцев назад

Can u do video on trigger?

@_.s.u.d.h.e.e.r._ Год назад

Bro need alternative for collection types in postgres sql Can you guide me plssss

@nagarjunhb9739 Год назад

What is difference between input parameter and output parameter?

@AsadAli-wi1xs 2 года назад

😍😍😍😍 thanks

@techTFQ 2 года назад

Your welcome Asad

@balajir724 2 года назад

Hello Tofik. Please make a video for triggers as well. Thank You

@techTFQ 2 года назад

Noted bro

@theerapoj.disarapong Год назад

Dear Sit Where can I download your file for this learning video? I tried to do step by step but found some difficulties. Thank you.

@sanilkumarbarik9151 Год назад

Are Recursive(), Procedure and statistics mandatory to get an entry level DA job?

@tamalmondal6158 3 месяца назад

Please share the link to download the database unable to replicate by manually creating table!!

@kartikpatil5581 Год назад

can you explain pagination in postgresql?

@Pardhu007 2 года назад

Hi bro These videos are very much useful Can you make an video for json file format and flatten the data for json format

@techTFQ 2 года назад

Thank you :) and will consider it

@Pardhu007 2 года назад

Thank you

@sagarbankar5732 2 года назад

I am looking platform where I can perform queries for proc. ,Function and triggers

@SumanKumarS 10 дней назад

Hi @techTFQ I couldn't find the scripts for this Stored procedure session in the Discord..Can you pls help.

@sidegap8345 Год назад

i have done the same thing for mysql but changes are not reflecting in the products table. sold remains 195 and remaining also 5 please some one guide me

@Fitbrahman31 11 месяцев назад

Sir I'm using Ms SQL management studio and when I wrote all this there it shows error in the first line 'create or alter pr_buy_products' else everything is correct but its showing error what to do

@nammibhargav9498 2 года назад

I'm a fresher just finished my SQL course..I wanted to know what are the important topics will be there in real time..so I can practice more on them ..can you please suggest

@ShubhamSharma-ks7vd Год назад

Normalization,Joins, Stored proc, Views,Index, Groupby, Cursor, Trigger👍

@wSawa3689 2 года назад

First like 🎉

@techTFQ 2 года назад

Appreciate it bro

@hudatolah 2 года назад

I am getting The EXECUTE permission was denied on the object 'pr_buy_products' :(

@shuvampal7290 Год назад

Hi sir. I'm having one issue. I am creating a procedure that will take parameter from another 1 colum table and run the procedure. Finally save the result. But the problem is i can't able to set parameter value which will take each row from that 1 column table. Can u please help?

@learningislife2934 Год назад

Sir different b/w function and Store procedure