@@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 👍👍 😃
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.
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.
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!
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!
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!
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.
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
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.
Hi Taufiq, I am so happy to come across your postgres channel. You explain the concepts very clearly and I am very much benefitting from them. Thank You
So far the best RUclips channel for Sql you deserve million subscribers brother for the quality of content you provide thanks a lot for your hard work ❤️
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.😍😍🔥🔥💯
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.
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
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 😊💐
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.
I started watching your videos since from a week it was awesome tutorials, i wanted to switch to Data Engineer role, your videos are so useful for me, if possible can you make video on Kubernetes and AWS
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
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❤️😊
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.
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
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.
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
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
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❤
First of all thank you very much for your efforts and great content ... Humble request from my end please make a video on how we can update views whose are based on more than 1 table... kindly 🙏🙏🙏
hey, i was referring oreilly learning sql book, there they showed updating views with more than 1 table...under updating complex views topic could you please look into it
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
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 !!
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
hello sir! i have a doubt regarding VIEW WITH ENCRYPTION. i created a view with encrption in MS SQL & when i right click on the encrypted view in object explorer i can still see the script of SELECT, INSERT, UPDATE,DELETE statements & also DROP VIEW option .I just wanna know that the other users are able to see those scripts & able to DROP the view???? please reply ASAP sir
The first 1,000 people to use this link will get a 1 month free trial of Skillshare: skl.sh/techtfq02221
Not able to login using this link can to check what is the problem
The link is working fine.. I just tried .. u need to sign up
@@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 👍👍 😃
Sir please upload SQL project
sir, please make video on sql joins and problem related to join , make video for beginers, please please please...
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.
Thank you so much Nishtha 🙏
Super happy to read your comment and good luck with the practice 👍
Hey, if you don't mind, can you share those notes?
It will be really helpful.
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.
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!
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!
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!
Thanks Laura. Always a pleasure reading your comment.
I hope the video helped. Have a great day you too :)
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.
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
Thank you so very much Siva 🙏🏼🙏🏼
It’s such a wonderful feedback from you ☺️
Appreciate it
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.
Hi Taufiq,
I am so happy to come across your postgres channel. You explain the concepts very clearly and I am very much benefitting from them.
Thank You
been to many courses and videos but this playlist is amazing. crisp & clear . Thank you :)
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
Thank you :)
Glad you liked it Mohit!
So far the best RUclips channel for Sql you deserve million subscribers brother for the quality of content you provide thanks a lot for your hard work ❤️
Thank you Nihar 🙏🏼
Much appreciated
Just wow... Your explanation is so clear. If I have any doubt about SQL. Your any video is more than enough. Thank you Teacher😅😁
always Indian youtubers helps with computer related things by the way that was ann amazing tutorial ! i love it !
👍👍👍
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.😍😍🔥🔥💯
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.
Stored Procedures next please 🙏. Thank you for all the valuable content
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
Noted guys and will cover Procedure soon
@@techTFQ thank you sir
Stored Procedures next Please ♥️
Noted bro
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 😊💐
He speaks really fast!!! Many complain of this
@@teniahicks2039 not true
One of the best videos I have ever seen on views. Kudos to you bro for this fantastic video.
Excellent video! in detail, clear and concise . keep it up. I have plan to watch all of your videos.
Fantastic video!!!!!!!! Orderly presentation at a good pace for any beginner covering important aspects of the topic. Just awesome!!!
Absolutely banger.
Just finished you With Clause videos ❣️❣️❣️
Keep making a full playlist for SqL sir
Thank you Arpan :)
Thanks is a very simple word to express
Thank you :)
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.
Thank you :) and sure will do
@@techTFQ from where I will get the views script?
I’ve shared it in my discord..
Link to my discord in video description
sir if you are reading this , I want to say thank you for sharing these beneficial tutorials
Very helpful to understand things not only for beginners but also for professionals
Appreciated
Glad to hear that Haroon
You are the best I always look for your videos here on RUclips
We are so Thankful to you as you are making such informative videos💯.
best video ever seen on sql, thank you so much brother ...
i am really inpressed by the way u explain things …
it is very useful bro..easy to understand every concept.
Very nicely taught!
Wonderful and very thorough explanation.. please keep up with the great work 👍
Amazing videos for learning SQL. Thanks and please keep it up :).
Thank you 🙏🏼
Thank you very much for sharing your knowledge brother !!!!!!!
Really awesome, salute to you. Thanks for making this video. It really helps me.
Awsome video Taufiq. Great teaching. Looking forward to many such videos on complex SQL .
Thank you bro
Thanks for the video with clear explanation 🙂 valuable examples
I started watching your videos since from a week it was awesome tutorials, i wanted to switch to Data Engineer role, your videos are so useful for me, if possible can you make video on Kubernetes and AWS
Thank you! This video explains very clearly and thoroughly!
Excellent as always👌🏻👏
Thank you :)
I never had this much clarification on views. Thanks @techTFQ
Great information, thank you!
Your welcome
Another master piece of content :) Thank you for explaining this topic crystal clear !!!
Glad you liked it!
Thank you very much for sharing with us your experience. Much appreciated.
It's my pleasure, glad this helped
Hello sir, good video, content is excellent better than most of the paid courses
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
Noted bro and will cover Index soon
@@techTFQ +1 for indexes
Noted Vinay
Great explanation sir thanks 🙌🙌🙌🙌🙌🙌
Thank you :)
Excellent Tutorial on Views, Grateful to you sir.
All content is just too much good ❤️
Thank you, learned new things about view.😊 Pls make video on trigger.
Your welcome Sangameshwar and will cover triggers soon
Hello Taufiq, love how you provide details in every video. Do you have plans to create a video regarding SQL optimization techniques? Thank you
Amazing way of explaining things!
Thank you:)
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❤️😊
Very glad to hear that .. thanks for sharing it and hoping you get the job 👍
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.
Thanks for sharing it Rahul.. yeah some differences in other RDBMS ..
will cover materialized views soon
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
Rules are differ from one dbms to another dbms. Even i have the same query initially.
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.
Your videos are so helpful and you teach very clearly.. 👌👍👍👍
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.
Great tutorials. Much appreciated
Learnt a lot from ur videos thx .
Glad to hear that Sumanth ☺️
Thank you! your explanation is superb...please make a video on materialized view.
Thank you will do
Thanks for providing this kind of material, please continue to make new video.
You're welcome ☺️
awesome explanation... covered all points in the view .👍
glad you liked it
Thanks for such in depth explanation on view 👏
Glad it was helpful!
Yet another awesome video🙌🏻 Thank you for all the great contents you post in this channel👌🏻 Really helps a lot🙏🏻
Awesome bro. glad you liked it :)
What a video sir its a osm work for fresher clear understanding how view use in real industries
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
Awesome buddy, glad to read this
Wow! What a session Taufiq👏
Another very helpful video.. Awaiting for Materialized View..
Thank you Anwar . Will make materialized view soon
Thanks for explaining from the scratch. It's really helped me to understand easily.
you explained everything with the practical situations so its really helpfull. pls do same like videos for stored procedures and triggers
Such a systematic approach to each concept really we are blessed to have u.....Great teaching🙏
So nice of you Padma.
thank you :)
Nice explanation bro.... Thank you for the valuable video
Your welcome buddy
Many many thanks for your beautiful lecture....❤
You're most welcome
in mysql workbench you can change column name in create or replace explain?
Thank you for such a wonderful explanation. Keep doing the good work. You're simply awesome
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
Detail video on view , very use full and helpful
A lot of information!!!!! Thank you !!!
Excellent Video ! Updatable Views Allow For Delete ?
Thx
Yes delete is possible too and thank you 🙏🏼
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❤
Super , waiting for your another video 👍👍
Thank you so much 😀
Great content. Keep teaching. Thank you 👏
Great video! What query editor are you using?
I loveeeeedddd it ❤❤❤❤....also make one how to create functions in sql
Noted Shiv and will do
First of all thank you very much for your efforts and great content ... Humble request from my end please make a video on how we can update views whose are based on more than 1 table... kindly 🙏🙏🙏
It is very usefull sir, sir please make a video over DDL, DML, DCL, TCL with all commands....
noted, will consider it
Its really awesome video.Thank you so much sir
hey, i was referring oreilly learning sql book, there they showed updating views with more than 1 table...under updating complex views topic could you please look into it
Thank you for the video, really awesome explanation
Thank you sir for this great content.
Thanks again for the great lesson.
Can you add a new column in existing view by using alter ?
@techTFQ hi.. I am great fan of your teachings. When are planning to teach python? Please reply
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
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 !!
I understand and I’ll work on it
Dear Taufiq , Thats great, thank you very much for understanding !! Really apperciate your work and passion !! Best Regards
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
Bhai thanks please continue awesome videos bro salute great job
Great 👍 must appreciate your efforts bro
Thank you :)
Nicely explained:)
Excellent bro.please do through video on procedures and functions.
Thank you Shiva and will do
hello sir! i have a doubt regarding VIEW WITH ENCRYPTION. i created a view with encrption
in MS SQL & when i right click on the encrypted view in object explorer i can still see the script of SELECT, INSERT, UPDATE,DELETE statements & also DROP VIEW option .I just wanna know that the other users are able to see those scripts & able to DROP the view????
please reply ASAP sir