The first 1,000 people to use this link will get a 1 month free trial of Skillshare: skl.sh/techtfq02221
@haroonahmad7312 жыл бұрын
Not able to login using this link can to check what is the problem
@techTFQ2 жыл бұрын
The link is working fine.. I just tried .. u need to sign up
@beingcheercool2 жыл бұрын
@@techTFQ My humble request to you , Please make more videos on practicing complex queries for interview preparation It will help lot of students to crack their tech interview 👍👍 😃
@taqihussain53122 жыл бұрын
Sir please upload SQL project
@govindmall4731 Жыл бұрын
sir, please make video on sql joins and problem related to join , make video for beginers, please please please...
@nishtha_pd8 ай бұрын
Hi Taufiq, I have recently revised SQL using your videos. This is an appreciation comment. I am so happy that I discovered your channel. The concepts are way more clearer now. all videos were easy to understand but special mention to Joins,cte and windows function are the best videos to refer to. I have made hand written notes while revising them. I feel more confident now. Now all I have to do is practice, practice ,practice. Going to suggest people to definitely stop by your channel and learn. Kudos to your hard work and knowledge.
@techTFQ8 ай бұрын
Thank you so much Nishtha 🙏 Super happy to read your comment and good luck with the practice 👍
@sushantkumar82083 ай бұрын
Hey, if you don't mind, can you share those notes? It will be really helpful.
@ManikandanRaju Жыл бұрын
This is GOLD! I am a self learner. I have seen so many channels. But hands down you are the best!!!!! No Exaggeration. The way you you teach is really awesome. Clear and concise. Detailed explanation. Ambience. 💯 thanks a lot sir. Keep educating please.
@sivasrimakurthi2062 жыл бұрын
When I saw new video from you this morning, I felt like a new "Thriller" movie released :-) .. yes, your content is NO LESS than that. I am literally addicted 🙂. Truth be told, the content is well planned and apt examples, much appreciate your patience creating the content and passing to beginners and experienced alike. Great Job Toufiq
@techTFQ2 жыл бұрын
Thank you so very much Siva 🙏🏼🙏🏼 It’s such a wonderful feedback from you ☺️ Appreciate it
@parthibangopi83936 күн бұрын
I started learning SQL by watching your videos and with the help of your videos I can use SQL in my work without having prior knowledge in SQL. All I need to say is keep posting videos related to SQL. BTW again I learned the concept view in detail with the help of this video. Thank you so much. Can you post a video for Index in SQL ? It would be really helpful if you can do that.
@CHSKnight2 жыл бұрын
Stored Procedures next please 🙏. Thank you for all the valuable content
@nagaranjith91472 жыл бұрын
Yes, thoufiiq. I am expecting the same . Please do a next video about stored procedures and user defined functions. I mean in what scenarios we use stored procedures and UDF. Thanks
@techTFQ2 жыл бұрын
Noted guys and will cover Procedure soon
@CHSKnight2 жыл бұрын
@@techTFQ thank you sir
@SatyamKumar-lj5bi2 жыл бұрын
Stored Procedures next Please ♥️
@techTFQ2 жыл бұрын
Noted bro
@Moon_Rise6393 Жыл бұрын
Hey Man!! You need a lot of popularity and i don't know why you're not subscribed by people you should have atleast millions subscribe and soon you will have. You have cleared all the confusion about the Views & I'm very thankful to you. Lots of love & Respect for this kind of free knowledge you're providing 😊💐
@teniahicks2039 Жыл бұрын
He speaks really fast!!! Many complain of this
@fathimafarahna2633 Жыл бұрын
@@teniahicks2039 not true
@laurak51962 жыл бұрын
You’re almost up to 50K, this is so exciting!!! Thanks for this video, which I just started watching. I know nothing at all about views so this will be all new for me. Have a great day ahead, Thoufiq!
@techTFQ2 жыл бұрын
Thanks Laura. Always a pleasure reading your comment. I hope the video helped. Have a great day you too :)
@KaranSharma-nb8sj Жыл бұрын
Hello Taufiq, I just wanted to take a moment to thank you for the excellent SQL tutorials you've been creating. Your videos have been incredibly informative and have helped me to deepen my understanding of SQL and improve my skills in this area. I appreciate how clearly you explain complex concepts and make them easy to understand, even for someone like me who is relatively new to SQL. Your tutorials are also well-organized, which makes it easy to follow along and practice what I've learned. Overall, your dedication to creating high-quality educational content is evident, and I believe your tutorials are a valuable resource for anyone looking to improve their SQL skills. Thank you for sharing your knowledge with the community and helping us to become better at what we do. I can Bet at current time there is no other youtuber who can explain these concepts like you do man.😍😍🔥🔥💯
@musafir_119411 ай бұрын
This is true. I too started learning DB to start working as DBA need some more clarification on the concepts and here I found this guy is giving you the complete understanding of the DB.
@kumaraswamy34527 ай бұрын
been to many courses and videos but this playlist is amazing. crisp & clear . Thank you :)
@SardorSaydazimov-b6h4 ай бұрын
always Indian youtubers helps with computer related things by the way that was ann amazing tutorial ! i love it ! 👍👍👍
@niharjamdar48692 жыл бұрын
So far the best KZbin channel for Sql you deserve million subscribers brother for the quality of content you provide thanks a lot for your hard work ❤️
@techTFQ2 жыл бұрын
Thank you Nihar 🙏🏼 Much appreciated
@debadityabhar142 ай бұрын
Hello techTFQ, I’m going through your SQL videos. It is very detailed steps by step explanation. I love to watch those and it gives me confidence on advanced level SQL knowledge. Keep going!
@nayeem39052 жыл бұрын
Hello Taufiq, love how you provide details in every video. Do you have plans to create a video regarding SQL optimization techniques? Thank you
@mohitbokade26912 жыл бұрын
Hey Thoufiq, This is my 3rd video and I am so glad I found you in the ocean of SQL trainers. Thank You for best video
@techTFQ2 жыл бұрын
Thank you :) Glad you liked it Mohit!
@datascienceisfun442 жыл бұрын
Thanks for providing such awesome content on SQL, please make videos on stored procedures, triggers as well, as many of the companies I came across detailing SQL with triggers as well.
@techTFQ2 жыл бұрын
Thank you :) and sure will do
@datascienceisfun442 жыл бұрын
@@techTFQ from where I will get the views script?
@techTFQ2 жыл бұрын
I’ve shared it in my discord.. Link to my discord in video description
@bernardarhin2628 Жыл бұрын
Fantastic video!!!!!!!! Orderly presentation at a good pace for any beginner covering important aspects of the topic. Just awesome!!!
@arpan80762 жыл бұрын
Absolutely banger. Just finished you With Clause videos ❣️❣️❣️ Keep making a full playlist for SqL sir
@techTFQ2 жыл бұрын
Thank you Arpan :)
@sreekarreddy67952 жыл бұрын
Thanks for the video on views. Can you also make a video on indexes, i have a lot of doubts on writing and using of indexes and also in many interviews they ask about indexes for performance tuning. Can you please make a video on this
@techTFQ2 жыл бұрын
Noted bro and will cover Index soon
@VinuP20232 жыл бұрын
@@techTFQ +1 for indexes
@techTFQ2 жыл бұрын
Noted Vinay
@AsadAli-wi1xs2 жыл бұрын
Sir please the cover these topic that is index, store procedure, and trigger in sql plz plz plz
@techTFQ2 жыл бұрын
Noted Asad and will cover them soon
@graceamah9962 жыл бұрын
Please same here Make a tutorial on stored procedures and triggers
@gayatrinayak6449 Жыл бұрын
Same here sirr ...plzz
@deepakdas2312 Жыл бұрын
Yes please create a video in index and collection
@mrmuranga11 ай бұрын
Very well laid out...thank you
@haroonahmad7312 жыл бұрын
Very helpful to understand things not only for beginners but also for professionals Appreciated
@techTFQ2 жыл бұрын
Glad to hear that Haroon
@careyliao-pc2dd6 ай бұрын
I appreciate the way you explained and incorporated realistic situations and potential challenges that may arise in the real-world work environment. This provided me with more inspiration and insight into the role of a data analyst. Very well done!
@saranrajv32 жыл бұрын
Another master piece of content :) Thank you for explaining this topic crystal clear !!!
@techTFQ2 жыл бұрын
Glad you liked it!
@nasunilkumar Жыл бұрын
I really dont know these many options available in View I thought View is select query until i saw this entire Video. Thank You Toufiq you are doing amazing job Thank you again.
@rahulvalecha64252 жыл бұрын
Hi Thoufiiq, First of all, thank you very much for the amazing content. I was trying to practice all the things which you taught in this video related to views and i realized that some of the rules does not apply in MSSQL . For e.g. 1. You can change the order, column name, etc in view. But I guess that is because we use to create or alter command as there is no replace statement. 2. I was able to update data through view even though I was using joins in my view. Just wanted to share my findings. Waiting for videos on materialized views.
@techTFQ2 жыл бұрын
Thanks for sharing it Rahul.. yeah some differences in other RDBMS .. will cover materialized views soon
@mritunzaysingh89782 жыл бұрын
Please check one more time If you make some updates with join in view then please check there are some changes have made on base tables because if you update view which based on 2 tables then it mismatched the data in both the table.... I think that is why we use triggers
@shivampatel6044 Жыл бұрын
Rules are differ from one dbms to another dbms. Even i have the same query initially.
@arindamsaha1929 Жыл бұрын
in second point which you mention you are able to update a view where you use join, i think you are update those column which is present in one table , if you want to update a view which has column from multiple table then you got an error to tackle those situation we have insted of trigger. please correct me if i'm wrong.
@aakashdubey96532 ай бұрын
One of the best videos I have ever seen on views. Kudos to you bro for this fantastic video.
@NeverStopLearning562 жыл бұрын
Thanks is a very simple word to express
@techTFQ2 жыл бұрын
Thank you :)
@yogamayaa2 жыл бұрын
Awsome video Taufiq. Great teaching. Looking forward to many such videos on complex SQL .
@techTFQ2 жыл бұрын
Thank you bro
@gauravnehare98445 ай бұрын
Just wow... Your explanation is so clear. If I have any doubt about SQL. Your any video is more than enough. Thank you Teacher😅😁
@meenakshiphore37402 жыл бұрын
We are so Thankful to you as you are making such informative videos💯.
@fathimafarahna26332 жыл бұрын
Excellent as always👌🏻👏
@techTFQ2 жыл бұрын
Thank you :)
@harithamenon63842 жыл бұрын
Thank you Sir for your detailed explanation.This topic was really helpful for the interview which I attended today.Interviewer came with the same question which you have mentioned in this video.Once again thank you so much Sir❤️😊
@techTFQ2 жыл бұрын
Very glad to hear that .. thanks for sharing it and hoping you get the job 👍
@sampleshawn53802 жыл бұрын
Very nicely taught!
@sikhasharma1204 Жыл бұрын
Excellent video! in detail, clear and concise . keep it up. I have plan to watch all of your videos.
@ionturea66782 жыл бұрын
Thank you very much for sharing with us your experience. Much appreciated.
@techTFQ2 жыл бұрын
It's my pleasure, glad this helped
@nehamegha33842 жыл бұрын
Great explanation sir thanks 🙌🙌🙌🙌🙌🙌
@techTFQ2 жыл бұрын
Thank you :)
@rajseharann54005 күн бұрын
Thanks for the video with clear explanation 🙂 valuable examples
@RajeshPudi182 жыл бұрын
stored procedures and functions please... also, a complete full SQL course from beginner to expert( like you)
@techTFQ2 жыл бұрын
Noted bro and will do
@marisa49428 ай бұрын
Thank you! This video explains very clearly and thoroughly!
@padmat65562 жыл бұрын
Such a systematic approach to each concept really we are blessed to have u.....Great teaching🙏
@techTFQ2 жыл бұрын
So nice of you Padma. thank you :)
@lambdaboss55282 жыл бұрын
Amazing videos for learning SQL. Thanks and please keep it up :).
@techTFQ2 жыл бұрын
Thank you 🙏🏼
@LalithambikaPeetam Жыл бұрын
Thanks for explaining from the scratch. It's really helped me to understand easily.
@prashanttayade15672 жыл бұрын
All content is just too much good ❤️
@mohammedshahil48982 жыл бұрын
Yet another awesome video🙌🏻 Thank you for all the great contents you post in this channel👌🏻 Really helps a lot🙏🏻
@techTFQ2 жыл бұрын
Awesome bro. glad you liked it :)
@rajeshk77172 жыл бұрын
Hi, May I request you arrange the videos in the playlist in order of learning, I mean which video to start first and then how to continue from there and in which order, currently views in no 1. For a new beginner, it might be slightly confusing.. thank you for your work !!
@techTFQ2 жыл бұрын
I understand and I’ll work on it
@rajeshk77172 жыл бұрын
Dear Taufiq , Thats great, thank you very much for understanding !! Really apperciate your work and passion !! Best Regards
@behumble...7059 Жыл бұрын
Your way of teaching is excellent.
@zero_analyst10 ай бұрын
Amazing way of explaining things!
@techTFQ9 ай бұрын
Thank you:)
@surajgupta-m7o Жыл бұрын
Thanks for the video, i think in mysql you can change the order of column and their alias as well by using create or replace command.
@balaji_prabhu Жыл бұрын
i am really inpressed by the way u explain things …
@raghavgoel34202 жыл бұрын
Good Content as usual. When you covered VIEWS this time than why not INDEX in SQL next time?
@techTFQ2 жыл бұрын
I will cover Index in the near future Raghav and thank you for liking my content :)
@user-ix7ee1kw7n Жыл бұрын
You are the best I always look for your videos here on KZbin
@ankitpant77922 жыл бұрын
Thank you Taufiq for the wonderful tutorial !! Would it be possible for you to create playlist for PL-SQL concepts like Store Proc,Trigger, Cursor etc ?
@techTFQ2 жыл бұрын
Your welcome Ankit and yes will cover these topics soon
@kylesnavely61652 жыл бұрын
Great information, thank you!
@techTFQ2 жыл бұрын
Your welcome
@Madur19022 жыл бұрын
please do videos on stored procedures and triggers 🙏
@techTFQ2 жыл бұрын
Noted and will do
@Hunter-di9by2 жыл бұрын
Wishing you joy and happiness, you are an amazing teacher, and you only deserve the best. That way you have explain view thats great sir.... Everything is perfect.we can understand every concept perfectly.thank you
@techTFQ2 жыл бұрын
Awesome buddy, glad to read this
@teslaocean9949 Жыл бұрын
best video ever seen on sql, thank you so much brother ...
@ritikajaiswal38242 жыл бұрын
hey! Thoufiq, Can you please review different websites like sqlzoo, sqlbolt, leetcode, stratascratch,hackerrank,mode etc. and tell me which one is the best to practise sql?
@techTFQ2 жыл бұрын
Reviewing all these platforms may take time for me . I would suggest that you start with StrataScratch, Leetcode and any other platform where you can find free options. Once you solved free questions, you will get an idea yourself which platform has good questions. then you can purchased the paid subscription. Just my suggestion
@anwardote2 жыл бұрын
Another very helpful video.. Awaiting for Materialized View..
@techTFQ2 жыл бұрын
Thank you Anwar . Will make materialized view soon
@sumanmondal88362 жыл бұрын
Thank you! your explanation is superb...please make a video on materialized view.
@techTFQ2 жыл бұрын
Thank you will do
@shivaaryaprakash Жыл бұрын
Hii Taufiq..your videos are always awesome and your explanation is outstanding.. I have a small request ,would you please make videos in Hindi. If possible please make video in hinglish. Thank you
@urzsurya23925 күн бұрын
Hello sir, good video, content is excellent better than most of the paid courses
@WBL-t9w8 ай бұрын
Hi. Do you have a video that explains primary key and foreign key etc?
@ritudahiya62232 жыл бұрын
@techTFQ hi.. I am great fan of your teachings. When are planning to teach python? Please reply
@techTFQ2 жыл бұрын
Hi Ritu, Thank you :) Python, I plan to make tutorial videos on youtube hopefully in couple of months time .. as for course I will do it early next year
@sangameshwarhippargi20072 жыл бұрын
Thank you, learned new things about view.😊 Pls make video on trigger.
@techTFQ2 жыл бұрын
Your welcome Sangameshwar and will cover triggers soon
@easycommerceclasses82418 ай бұрын
Wonderful and very thorough explanation.. please keep up with the great work 👍
@tarunbudhlakoti58282 жыл бұрын
awesome explanation... covered all points in the view .👍
@techTFQ2 жыл бұрын
glad you liked it
@ravikhandsiya12382 жыл бұрын
I never had this much clarification on views. Thanks @techTFQ
@vishalnasre12512 жыл бұрын
Great Video, Can you make one video on the difference between sub-query, view, with clause, temp table, I am quite confused on when to use what?
@techTFQ2 жыл бұрын
I understand Vishal. When to use what is something we understand when we solve more and more sql queries. But let me see if i can come up with some useful tips for it
@vishalnasre12512 жыл бұрын
@@techTFQ thank you
@shivamkapoor1827 Жыл бұрын
Bro your sql videos are great But my question is when to use cte and when to use views?
@rahulrrtt10 ай бұрын
Thanks for such in depth explanation on view 👏
@techTFQ9 ай бұрын
Glad it was helpful!
@UnknownPerson-e2b Жыл бұрын
I like to have a project in SQL with different domains. So, while doing it with you and plz share the data so we also follow your steps to understand the concept. Thanks for the CTE video It really helps alot❤
@jagdishrohit374811 ай бұрын
Thanks for providing this kind of material, please continue to make new video.
@techTFQ9 ай бұрын
You're welcome ☺️
@saniasinghania11832 жыл бұрын
Hello sir, loved the tutorial, i have been following your videos to learn SQL. Just a few things that I wanted to ask: 1) What is ::? I am not able to understand its functionality in my SQL, it doesn't work. Not able to find any documentation as well. 2) I am able to change column names, add columns in between columns in my 'create or replace view' queries. Both rules don't apply in my code. Am i missing something? 3) I am able to update my views which are made of multiple tables using join. Again, is something wrong in my SQL? Would really appreciate your response over this. 😊🙏
@jahedulislam3438 Жыл бұрын
yes it works.
@remyagiri2 жыл бұрын
Hi First of all really thanks fully to you, I am just starting to learn this sql , Very informative all these videos, I requested to you . could you please explain Execution plan ? how to identify which function or query takes more time to execute?, i am trying to optimization our procedure, Please explain .......
@techTFQ2 жыл бұрын
Thank you Renjini :) and will cover performance tuning concepts in the near future
@AnzioBake2 жыл бұрын
I would suggest that you make it clear what SQL server you are using. Using propriety coding syntax can fool people in thinking that can be used in any sql server
@techTFQ2 жыл бұрын
Noted. People who followed my other video, would probably know that I use PostgreSQL but I make video considering standard sql and not just for PostgreSQL. But will make sure to announce it in the future video’s
@abdhrsm-pf7bi Жыл бұрын
Really awesome, salute to you. Thanks for making this video. It really helps me.
@balajiV20012 жыл бұрын
Bro plz explain trigger and stored procedure and normalization.....
@techTFQ2 жыл бұрын
Noted, will do
@sanjeetsingh19432 жыл бұрын
Thanks for educating us...kindly make a video on some awesome session onto Store Proc which will cover from beginning to advance with industry standard and real time example.
@techTFQ2 жыл бұрын
Your welcome buddy and sure will cover procedure soon
@theunusual45666 ай бұрын
Excellent Tutorial on Views, Grateful to you sir.
@shubhamtyagi72992 жыл бұрын
It is very usefull sir, sir please make a video over DDL, DML, DCL, TCL with all commands....
@techTFQ2 жыл бұрын
noted, will consider it
@sumanthtiru41282 жыл бұрын
Learnt a lot from ur videos thx .
@techTFQ2 жыл бұрын
Glad to hear that Sumanth ☺️
@ashaarun527 Жыл бұрын
you explained everything with the practical situations so its really helpfull. pls do same like videos for stored procedures and triggers
@mdhossain529 Жыл бұрын
Assalamualaikum warahmatullah. Dear brother Awesome explanation. Shukran. I am from New York.
@avinashboyina24023 ай бұрын
Could you please tell me what the difference between CTE and VIEW
@NEG0POS2 жыл бұрын
Excellent Video ! Updatable Views Allow For Delete ? Thx
@techTFQ2 жыл бұрын
Yes delete is possible too and thank you 🙏🏼
@NEG0POS2 жыл бұрын
Please , If possible add a video on Recursive SQL , Always a pleasure to watch your videos ... Thx in Advance !
@techTFQ2 жыл бұрын
Noted and will do
@ratneshraj46532 жыл бұрын
Thanks for wonderful content. Stored procedure and indexes next. Also please make videos of hard sql questions of strata scratch. One of those video was really good and helpful. Thanks once again
@techTFQ2 жыл бұрын
Thank you Ratnesh and will do 🙏🏼
@ajayyaleti6197 Жыл бұрын
Thanks for the video coach. I have a question. As you said create or replace view will always remove and creates a new view then how can it identify if we include a new column in between or change the data type or change the order
@ronakronu Жыл бұрын
sir if you are reading this , I want to say thank you for sharing these beneficial tutorials
@shivsharma91532 жыл бұрын
I loveeeeedddd it ❤❤❤❤....also make one how to create functions in sql
@techTFQ2 жыл бұрын
Noted Shiv and will do
@amywang1840 Жыл бұрын
A lot of information!!!!! Thank you !!!
@sarjunak26052 ай бұрын
Now In MS sql Server, view created using multiple joins are allowed to update, and order of columns are also allowed to change. Can you make a new series with updated concepts. Thanks for the series it is really helping to learn more clearly.
@saraswathirajendran2395Ай бұрын
Yes, the column names, datatype as well as it's order can be changed now in a view. I wonder if anyone would mention that here in the comments! Thanks...
@balakrishnam5077 ай бұрын
Can you add a new column in existing view by using alter ?
@hemanthnaidu61782 жыл бұрын
Nice explanation bro.... Thank you for the valuable video
@techTFQ2 жыл бұрын
Your welcome buddy
@haroonahmad7312 жыл бұрын
Please make a video on query optimization and prevent from sql injection i mean how to secure
@techTFQ2 жыл бұрын
Noted and will cover them in the future
@shivashankara70822 жыл бұрын
Excellent bro.please do through video on procedures and functions.
@techTFQ2 жыл бұрын
Thank you Shiva and will do
@deebanm124 Жыл бұрын
Your videos are so helpful and you teach very clearly.. 👌👍👍👍
@BHARATHISINGARESI6 күн бұрын
Thank you sir for this great content.
@r_s79272 жыл бұрын
Do you have any video of how to install SQL , so that whatever queries you have taught in this video , we can pratice them
@mehulgarg33782 жыл бұрын
Thank you sir for this informative content, what I like the most is your explanation about the concept Please also create separate content on user roles and permission and also on SQL events.