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
6 ай бұрын
Please share the link to download those dB, if I manually creating this entry from 1 after previous entry was loaded at 10.
@TheRaju991
2 жыл бұрын
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
Жыл бұрын
😂
@shivammadaan9498
2 жыл бұрын
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
2 жыл бұрын
your welcome Shivam. I am very glad to read this
@PallabNath-to9oq
3 ай бұрын
This is by far the best SQL tutorials on the internet, better than a lot of paid resources
@karangupta_DE
2 жыл бұрын
one of the best explanations of a stored procedure with an actual use case, thank you so much for the video.
@maryamm.z-dr7xb
4 күн бұрын
Thank you for great tutorials. I've learned a lot. Please make a separate video for materialized view in Oracle too.
@Platoface
4 ай бұрын
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.
@Rainbow_Academy
5 ай бұрын
Just started learning SQL and I'm amazed how you explain things to look that easy. Keep it up💞🎖️🔥
@garybou8559
6 ай бұрын
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
Жыл бұрын
This is the best explaination about stored procedures. Its like spoon feeding.
@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
@ryuhayabusa3540
Жыл бұрын
THIS MAN MAKES LEARNING EASIY, THANK YOU SO MUCH FOR ALL YOU DO FOR US. GOD BLESS YOU BROTHER;
@sukritiguin5637
Жыл бұрын
Best SQL teacher on KZitem ♥️🔥
@techTFQ
Жыл бұрын
Thank you buddy
@manupriyar8169
2 жыл бұрын
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..
@bala9535
2 жыл бұрын
Wonderfull story telling comparing 4 diff category. Please do more vedio series.. it will help full us..
@techTFQ
2 жыл бұрын
Thank you Balaji :)
@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...
@murchhanabanerjee862
9 ай бұрын
Hi Taufiq, excellent video as always ❤ why don't you cover cursor & error handling as well ? is there any separate video for that ?
@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
@vellakibb9367
Жыл бұрын
One of the best video I have ever seen. Its so simple and easy to start from. Thanks @techTFQ.
@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
@adarshpandey8023
Жыл бұрын
There are so many tutorials out there but you are damn too good.
@odelolatechup1447
2 жыл бұрын
Am a big fan of your teachings. Keep it up sir, you are fantastic
@techTFQ
2 жыл бұрын
Thanks a lot brother :)
@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.
@rishabhverma4735
10 ай бұрын
Best video on store procedure. Thankyou bhai for covering everything ❤.
@techTFQ
10 ай бұрын
Glad it helped
@hritikdalal5633
4 ай бұрын
Awesome presentation, explained in a crisp and clear manner, Hats off the Tutor🫡
@prabhulakhera1430
Жыл бұрын
Thank you techTFQ sir , your way of teaching is best
@Ayesha-wf3sy
3 ай бұрын
very well explained. I didn't bore for a while even
@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!
@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
@hasanmougharbel8030
2 жыл бұрын
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.
@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
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
2 жыл бұрын
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
2 жыл бұрын
@@TheRaju991 true You know in functions you don't write the codes again
@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
@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
@UpendraYadav-te8ov
Жыл бұрын
Thank you so much bro for making such a wonderful video, well explained
@sudarshanmhaisdhune1039
Жыл бұрын
Wow man! simply outstanding.....!
@honestreview6900
2 жыл бұрын
Wish u a very happy Eid Taufiq
@techTFQ
2 жыл бұрын
Thank you bro, saw this a little late :)
@omkargurme20
5 ай бұрын
awesome video, thanks, also a request, can you make more videos on PL-SQL , thanks
@itikalaneelu9126
Жыл бұрын
Thanks is just a small work. Keep up the good work
@Kirankumar-ml1ro
Жыл бұрын
Tq u buddy!! Will you please upload a video on pl/SQL fucntions
@brendensong8000
Жыл бұрын
Very comprehensive tutorial! Thank you for sharing!!!
@ratneshraj6086
2 жыл бұрын
Well covered but need a video using output paramaters Also cover user defined function and triggers
@techTFQ
2 жыл бұрын
Noted bro, will do
@ShawnTheSheep407
2 жыл бұрын
awesome video, as practical as an example can get! as compact as possible! thank you!
@techTFQ
2 жыл бұрын
Thank you so much buddy
@NEG0POS
2 жыл бұрын
Superb ! Keep up the good work ...
@techTFQ
2 жыл бұрын
Thank you :)
@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 !!!!
@lkkota41
5 ай бұрын
Appreciate putting the differences.. Very helpful
@sivadurgaprasadjatla8115
Жыл бұрын
Hi Brother...will you please make a detail video about the difference between procedures and funtions?
@xunianzu
2 жыл бұрын
This is very helpful. Thank you.
@techTFQ
2 жыл бұрын
Thank you Joe :)
@rohitjaiswal8116
Жыл бұрын
@techtfq please make videos for performing tuning of Store procedure
@NaveenKallur-b4f
Жыл бұрын
Hi sir, Can you Please upload how to update records from multiple tables(different tables) using stored procedure
@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?
@harshshah9006
Жыл бұрын
Thank u so much for this !
@balajir724
2 жыл бұрын
Hello Tofik. Please make a video for triggers as well. Thank You
@techTFQ
2 жыл бұрын
Noted bro
@sundarrajan8306
2 жыл бұрын
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
2 жыл бұрын
Good luck buddy
@maheshp5244
2 жыл бұрын
Thanks sir , I'm waiting for this video
@techTFQ
2 жыл бұрын
I hope this helps Mahesh
@SurajSingh-n8x1m
Жыл бұрын
Bahut acha kaam karta ho aap
@Gate_Tricks
2 жыл бұрын
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
2 жыл бұрын
let me consider it bro
@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
@nayeem3905
2 жыл бұрын
Hello, Would be willing to create a video on how to troubleshoot and optimize stored procedure? Thank you
@dhineshdhinesh6276
2 жыл бұрын
Thank you so much sir will you teach json in plsql sir, thank you for your help sir learned lot international standard
@techTFQ
2 жыл бұрын
Thank you Dhinesh. glad you liked it :) as for PLSQL concepts, I may do it in the future
@dhineshdhinesh6276
2 жыл бұрын
@@techTFQ thank you for your reply sir
@prajnamayadi1764
10 ай бұрын
Thoufiq excellent vedio lectures!!
@techTFQ
10 ай бұрын
Thank you:)
@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
@manideepgubba3536
Жыл бұрын
Also Explain the stored procedures for snowflake database
@jubburusrikanth509
5 ай бұрын
Brilliant work 👏
@Buzzingfact
2 жыл бұрын
Thanks for the video👍
@techTFQ
2 жыл бұрын
Your welcome bro
@ManishSharma-fi2vr
2 жыл бұрын
Please make a tutorial on indexing....I requested you many times.
@techTFQ
2 жыл бұрын
Noted Manish , but not anytime soon
@satindersingh2562
2 жыл бұрын
Keep it up 👍. Great Efforts
@techTFQ
2 жыл бұрын
Thank you :)
@Madhavi-ti8xo
Жыл бұрын
Hi Thoufiq. So far we enrolled for SQL Bootcamp. I would like to learn TSQL from basic to Advance. Are there any bootcamps going on for TSQL. How can we enroll?
@techTFQ
Жыл бұрын
TSQL and SQL are basically 90% same .. The SQL used in Microsoft SQL Server is referred to as TSQL .. If you learn SQL then you can easily work in TSQL
@ka2165
2 жыл бұрын
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
2 жыл бұрын
Ive mentioned it in the video description. Check the timestamp plz
@ka2165
2 жыл бұрын
@@techTFQ Will do thanks a lot and also for your other great SQL lectures.
@rika0729
8 ай бұрын
please the text editor / IDU u are using sir... or someone else, please tell..!!
@Persianchannel1
Жыл бұрын
tnx bro. outstanding video 👏
@yogeshmane9860
2 жыл бұрын
Good work Sir, Keep it up
@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.
@deepshah2137
Жыл бұрын
Excellent as always!!!
@manoganesan7618
2 жыл бұрын
Could you please explain that how to send multiple parameters? Like IN condition in the WHERE Caluse.
@dinesh.p8642
11 ай бұрын
Thank you TFQ ji
@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.
@ramakumarguntamadugu1299
Жыл бұрын
thanks for sharing the great content! keep it up !
@waseembari2125
3 ай бұрын
Hi,As i stay outside india can you help me purchase your SQL course as there is no option for oversea payments
@Gate_Tricks
2 жыл бұрын
hi please make a video on sql order of execution
@techTFQ
2 жыл бұрын
I’ll plan it out
@Gate_Tricks
2 жыл бұрын
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
@priyadarshini3284
11 күн бұрын
Can u explain? How to resolve the error? Relation does not exists in postgre.
@shubhamkapoor85
Жыл бұрын
Is the difference between t-sql pl/sql and standard sql is the stored procedure?
@SatyamKumar-lj5bi
2 жыл бұрын
Thanks man for the video
@techTFQ
2 жыл бұрын
Your welcome Satyam
@nisha6165
2 жыл бұрын
Thanks a lot for the vedio😀
@techTFQ
2 жыл бұрын
Glad you liked it Nisha
@sanilkumarbarik9151
Жыл бұрын
Are Recursive(), Procedure and statistics mandatory to get an entry level DA job?
@tamalmondal6158
7 ай бұрын
Please share the link to download the database unable to replicate by manually creating table!!
@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?
@SumanKumarS
4 ай бұрын
Hi @techTFQ I couldn't find the scripts for this Stored procedure session in the Discord..Can you pls help.
@rupamkarmakar2315
2 жыл бұрын
Can you make a video on functions and loops in sql please!
@techTFQ
2 жыл бұрын
sure will do
@ArifRaza
4 ай бұрын
Hello Taufiq Sir, I followed your suggested steps to create and execute stored procedure in oracle SQL. When I have created a stored procedure without parameter and executed, I came across the below error. Please suggest me how to resolve it. warning:- procedure created with compilation error. ERROR at line 1: ORA-06550: line 1, column 7: PLS-00905: object SYS.PR_BUY_PRODUCTS is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
@hustlerguy6091
2 жыл бұрын
where are the scripts and datasets used in this video. I cannot find them in discord
@techTFQ
2 жыл бұрын
I’ve just attached it in “scripts_n_resources” channel of my discord. Plz check now
@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
@ashabhumza3394
2 жыл бұрын
I have a query: if a job description demands for postgre SQL but I know MySQL ,so am I eligible for the job?
@techTFQ
2 жыл бұрын
yes you are since 80-90% of SQL is common accross diff databases
@ashabhumza3394
2 жыл бұрын
@@techTFQ thank you 👍
@JD_2
Жыл бұрын
great stuff
@itikalaneelu9126
Жыл бұрын
You are a gem
@levinfrederic1190
2 жыл бұрын
Please make a video on Triggers
@techTFQ
2 жыл бұрын
Noted, will plan 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.
Пікірлер: 228