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

[@techTFQ]

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]

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]

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]

Your are bahubali of SQL tutorials 👌👌👌

[@techTFQ]

haha thank you bro

[@showripratury9202]

😂

[@learningislife2934]

👍😁

[@Prabhakaran-hp1to]

😂😂😂

[@sudharsansugumar3992]

😂

[@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

[@PallabNath-to9oq]

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.

[@ranjitchouriwar504]

You are the king of database fields .what a great knowledge i am fan of you .love from India🇮🇳

[@DKRAY-x2l]

God bless you for spreading knowledge with so much clarity , ease and practicality. Your SQL teaching is just awesome.

[@maryamm.z-dr7xb]

Thank you for great tutorials. I've learned a lot. Please make a separate video for materialized view in Oracle too.

[@itikalaneelu9126]

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

[@sukritiguin5637]

Best SQL teacher on KZbin ♥️🔥

[@techTFQ]

Thank you buddy

[@Rainbow_Academy]

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

[@ryuhayabusa3540]

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

[@garybou8559]

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

[@bala9535]

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

[@techTFQ]

Thank you Balaji :)

[@adarshpandey8023]

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

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

[@odelolatechup1447]

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

[@techTFQ]

Thanks a lot brother :)

[@sushmashreem.t1823]

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

[@rishabhverma4735]

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

[@techTFQ]

Glad it helped

[@vellakibb9367]

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

[@Ayesha-wf3sy]

very well explained. I didn't bore for a while even

[@prabhulakhera1430]

Thank you techTFQ sir , your way of teaching is best

[@hritikdalal5633]

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

[@honestreview6900]

Wish u a very happy Eid Taufiq

[@techTFQ]

Thank you bro, saw this a little late :)

[@NEG0POS]

Superb ! Keep up the good work ...

[@techTFQ]

Thank you :)

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

[@skriesten]

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

[@techTFQ]

Thanks Steve, will do!

[@sudarshanmhaisdhune1039]

Wow man! simply outstanding.....!

[@ShawnTheSheep407]

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

[@techTFQ]

Thank you so much buddy

[@maheshp5244]

Thanks sir , I'm waiting for this video

[@techTFQ]

I hope this helps Mahesh

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

[@dhananjaypimple6003]

Very Well Explained! Thank You So Much!!

[@itikalaneelu9126]

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

[@lkkota41]

Appreciate putting the differences.. Very helpful

[@xunianzu]

This is very helpful. Thank you.

[@techTFQ]

Thank you Joe :)

[@UpendraYadav-te8ov]

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

[@brendensong8000]

Very comprehensive tutorial! Thank you for sharing!!!

[@SandyCoco1]

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

[@INDIAN-9528]

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]

Thank you :) and will consider it

[@INDIAN-9528]

Thank you

[@harshshah9006]

Thank u so much for this !

[@basavapn6487]

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

[@techTFQ]

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

[@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

[@Buzzingfact]

Thanks for the video👍

[@techTFQ]

Your welcome bro

[@yogeshmane9860]

Good work Sir, Keep it up

[@jubburusrikanth509]

Brilliant work 👏

[@satindersingh2562]

Keep it up 👍. Great Efforts

[@techTFQ]

Thank you :)

[@Persianchannel1]

tnx bro. outstanding video 👏

[@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

[@prajnamayadi1764]

Thoufiq excellent vedio lectures!!

[@techTFQ]

Thank you:)

[@ratneshraj6086]

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

[@techTFQ]

Noted bro, will do

[@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 !!!!

[@omkargurme20]

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

[@SurajSingh-n8x1m]

Bahut acha kaam karta ho aap

[@SatyamKumar-lj5bi]

Thanks man for the video

[@techTFQ]

Your welcome Satyam

[@artianrika8329]

thanks, that was perfect

[@ramakumarguntamadugu1299]

thanks for sharing the great content! keep it up !

[@deepshah2137]

Excellent as always!!!

[@nisha6165]

Thanks a lot for the vedio😀

[@techTFQ]

Glad you liked it Nisha

[@murchhanabanerjee26]

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

[@dinesh.p8642]

Thank you TFQ ji

[@nammibhargav9498]

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👍

[@balajir724]

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

[@techTFQ]

Noted bro

[@skumar05]

Thanks sir to upload this video big thanks

[@techTFQ]

I hope you like it Rahul 🙏🏼

[@skumar05]

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

[@rohitjaiswal8116]

@techtfq please make videos for performing tuning of Store procedure

[@Kirankumar-ml1ro]

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

[@qurdedu4032]

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]

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

[@ManishSharma-fi2vr]

Please make a tutorial on indexing....I requested you many times.

[@techTFQ]

Noted Manish , but not anytime soon

[@lokeshreddy7479]

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]

Thank you Lokesh :) and sure will consider it

[@sibanandakhatei9634]

Thanks for this

[@techTFQ]

My pleasure bro!

[@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

[@dhineshdhinesh6276]

Thank you so much sir will you teach json in plsql sir, thank you for your help sir learned lot international standard

[@techTFQ]

Thank you Dhinesh. glad you liked it :) as for PLSQL concepts, I may do it in the future

[@dhineshdhinesh6276]

@@techTFQ thank you for your reply sir

[@sundarrajan8306]

Hlo I am working in mnc. I got a training in mssql administrator. I am going to get project also in this stream only. It have worth of learning in 2022

[@techTFQ]

Good luck buddy

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

[@itikalaneelu9126]

You are a gem

[@wSawa3689]

First like 🎉

[@techTFQ]

Appreciate it bro

[@AsadAli-wi1xs]

😍😍😍😍 thanks

[@techTFQ]

Your welcome Asad

[@Gate_Tricks]

hi please make a video on sql order of execution

[@techTFQ]

I’ll plan it out

[@Gate_Tricks]

Sir i want one more topic... That is How to decode SQL query for competitive exam..... I have around 100 relevel question... I have good knowledge in sql but still not able to decode SQL query

[@sivadurgaprasadjatla8115]

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

[@Gate_Tricks]

hi sirSir i want one more topic... That is How to decode SQL query for competitive exam..... I have around 100 relevel question... I have good knowledge in sql but still not able to decode SQL query

[@techTFQ]

let me consider it bro

[@JD_2]

great stuff

[@levinfrederic1190]

Please make a video on Triggers

[@techTFQ]

Noted, will plan it

[@priyadarshini3284]

Can u explain? How to resolve the error? Relation does not exists in postgre.

[@manideepgubba3536]

Also Explain the stored procedures for snowflake database

[@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]

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

[@neerajtripathy6526]

How to write a stored procedure to generate a report of last day of every month into an excel file. This question has been asked to me in 3 interview. Oracle. Postgresql. Mysql. Plz make a video on this.

[@shubhamkapoor85]

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

[@viralfitness7]

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

[@junedkhan-ge5mi]

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

[@rupamkarmakar2315]

Can you make a video on functions and loops in sql please!

[@techTFQ]

sure will do

[@manoganesan7618]

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

[@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

[@dgh25]

Nice!

[@Behappy-ft5yc]

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

[@ksharsha17]

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

[@FactsbyAKA8337]

can anyone share the script of the table use in this video

[@tamalmondal6158]

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

[@rika0729]

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

[@ka2165]

Hello, what are the topics that will be covered in this video? I asked this question because recently I am looking for detailed lecture videos to understand PL/SQL, I really appreciated uploading this video at the right time when I needed the most to understand its concept.

[@techTFQ]

Ive mentioned it in the video description. Check the timestamp plz

[@ka2165]

@@techTFQ Will do thanks a lot and also for your other great SQL lectures.