the mvp of this video was the last join with 4 tables. exactly what i wanted to learn. the internet was filled with simple joins which never did justice to the concept of joins . industries will have 4-6 joins in a query and now i can visualize things way better. most helpful sql video seen all year. we must start small with learning but we must also learn complex stuff till it becomes useful in computer field
The last 10 mins of your video truly clarified issues I had with joining "multiple" tables--beyond the simple two we so many times in tutorials and online course. Thanks so much for taking the time to reinforce these concepts!
Teachers like you are so important to boost our confidence. Thanks a ton for making these videos, which are only helping us in flourishing our career. Loads of blessings
Repeat this episode 2 to 5 times that would help you the concept and use your query window hand on write his code , I assure you definitely got it. I found techTFQ is one of the best teachers as far I do experience! Thank you.
have been using sql for years now and watched tons of sql videos, nothing came close to this explanation. After years of using sql, I was still confused with joins, but this video did it.. Thanks for this man, keep it up.
I highly recommend checking out this page for comprehensive tutorials on SQL join queries, as they provide clear explanations and practical examples that have greatly enhanced my understanding of database operations. and kindly help us with some database and give some questions in that.. It will attract more number of students who see this video.anyways thansss
Hi Thoufiq, I am only halfway through and I just have to tell you that you were born to be a teacher. Truly. Even though I’ve now taken so many classes on LearnSQL (per your video recommending that resource, which I really appreciate), so that this is material I know, this is such a great explanation of these concepts. I think what I appreciate most about you is that you include everything I need to hear and nothing I do not need to hear. You don’t waste your time or the viewer’s time with extraneous information. That is a very big deal on UA-cam, where I come for information. I like to use my time well and you clearly keep this in mind when you put your videos together. This is my busy time now in my current job and so I won’t be around as much, but I’m so happy to again see that your channel has grown now to over 30K subscribers. I think that the combination of your skills, experience and knowledge combined with your humble spirit will serve and are serving you well. I wish you all the best for 2022 and many thanks for all of your assistance with SQL. 🙏🏻😊
It's always a pleasure to read your feedback Laura. I am so glad to receive your wishes. And I imagined when I was making this video that it might relate to you. I am glad it did and I am glad you found this useful. Thank you so very much for being a constant supporter of my channel and I truly wish you achieve all your goals for this new year :)
My American teacher has a way of making the lessons on “Joins” sound so complicated. Thank you for simplifying it sir. For the first time I’ve actually understood it.
I went through so many videos to learn joins and finally I landed here. Thank you so much for this. Your exceptional way of teaching can make learning easy.
I watched your SQL basis, intermediate, advanced and interview question videos. You are giving your best to all those categories. Thanks you so much for your efforts bro. Really appreciate your help. 🙏
This guy was born to do this. Your simple method of explanation and clear demonstration is apt. Am catching the vibes, enjoying the groove. Lets go there...
Wow, I just have to say that your videos are some of the best I've ever seen! this sql joins video was absolutely fantastic - your explanations were clear and concise, and I was able to follow along with ease. I've watched a lot of videos on this topic before, but none of them have been as helpful as yours. Thank you so much for taking the time to create such high-quality content - it's truly appreciated!
Hi Sir, Earlier I was struggling to get fetch data from 3 three tables, now after watching your 2 two videos several times now I am confident enough to solve any query of SQL... no. of tables doesn't matter. Bunch of thanks for everything Sir. Now I am targeting windows functions, I never thought I will write such queries but Sir, the way you teach is just amazing 😍😍
Hi Thoufiq, browsing your videos could't agree more with others you are born a teacher, clear instructions I think your humbleness and the manner you teach is helpful to me and others. We are with you.
I have to agree 100% I have been trying to learn sql and python and felt lost and confused, anyone teaches it's hard to understand or they talk down to you. So happy I found your content.
You have done an amazing job of breaking these joins down, step by step, and making it simple to understand the differences. Thank you for such a thorough explanation. My professor could learn a thing or two from you.
This is how the content is delivered, how the teaching is done! After going through a hell lot of tutorials on Joins, I can confidently say this is the explanation we beginners require! Though One request I'd like to make. Could you please put the code of the tables you used in the tutorial. This will save our time, and we can focus more on practicing writing the queries itself. Thanks a lot :)
Thoufiq bhai I was not able to understand joins concept from one year, but after watching this video i got cleared my all queries, wonderful teaching really appreciated.
The unique thing about this join video is that it helps to understand when to use which join. Certainly boosting my confidence for counter questions on join in an interview.
This is a very clear and simple explanation.I almost gave up and thats when I chanced to see this video. I cant believe that I finally learnt Joins! Thanks a ton
Hello Thoufiq, i started my journey as a data analyst 3 weeks ago, i stumbled across your video on the explanation of the roadmap for been a data analyst, the skills to develop, to enable someone have at least basic knowledge especially on SQL. This has guided me through the journey so far, although it all seem lumped up at the moment, bu i am taking it one at a time, since its a new skill for me but your videos has made it easy for me to learn. Thank you.
Janet may I know what all skills you need to learn for data analyst profile as a start-up or entry level in this particular domain?? pls reply if possible
Glad I found this channel . You are doing a really great job man. Teaching is a skill which not everyone out there who is teaching have , but this man thoufiq , is a master at this.
No one taught me which table is left and right..you do this just.. Thank you sir... Thank you very much... Just this things can me confused me. Today I got clear this.. Thank you very much...
I saw the whole video and you explained everything perfectly . Thank you so much ! Really appreciated! I spent so much time studying and still I have the feeling I am not getting anything right . I was really sad today. Thank you for explaining so clearly and detailed ! 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼
Thank You very much sir! Your SQL basic, intermediate and advanced all the series are really very helpful and it's totally understandable You explain all the topics very well As an aspiring data analyst I can say this tutorials ✨😊 are helping me to achieve my goal
Wow. Really enjoyed this. Joins was one topic which i was feeling hard to understand in depth. Thanks to this amazing video. I have got a clear idea now. Looking forward to the next one👍🏻✌️
You are sooo right. I hated joins till I came across this video by luck. I missed out on a lot of opportunities because I did not have a good understanding on joins till now.
I always have this sort of feeling that joins are kind of confusing. I really appreciate this video helped a lot and boosted my confidence I can now easily run the query. Thanks a ton...!
No one can teach joins better than you. thank you so so much for doing this. This is helpingso many new learners like me. I a going to go through the whole course work
very good clear explanation, can you please share the scripts for creating the tables and inserting the data for the explained tables, if we follow the same tables and same data it will be better, Thank you....
Thank you 🙏🏼 I had shared the scripts in my discord server, perhaps you can join my discord server to get those scripts. Link to join my discord can be found in video description
I am a complete beginner in SQL , JOIN was a tricky topic to understand, but u made it very simple to understand, thank you Thoufiq , you are awesome 🥰🥰🥰
I did SQL a few years ago in school, Joins was something that I could never understand. Mainly cuz the instructor wasn't very good. Your explanation is very good. Will go thru it a couple times again to make notes so I fully understand and also do examples. But very helpful! :)
This is video is quite helpful. You have given answers to a lot many questions that i had. Thanks a lot 😊 Also could you please tell how to create the team_member_id column which has two FOREIGN KEY references in the same column? Thanks in advance 😊
If there are two tables for example employees & Department and you are getting your desired output using left join. If I exchange the table position and used the right join then output will be the same. Then what is the use of left or right join? For example:-- Select e.emp_name, d.dept_name From employees e Left Join department d On e.dept_id = d.dept_id ; Same output with query below. Select e.emp_name, d.dept_name From department d Right Join employees e On e.dept_id = d.dept_id ; Please answer it was asked in interview
@Muhammad Zahid I’d like to know which query is more efficient for the system to run. One with join or with a subquery or does it vary from case to case? Or is there a general rule about this. Would be curious if @TechTFQ has time to answer us. I love this channel! 😀 I would also like to know the answer to Sachin’s question, from the interviewer’s perspective at least.
The reason why we need both LEFT and RIGHT join is because in certain scenarios, you may have to write some query where one specific table might be on the left hence you will need left join and then some other table may be on the right side for which you would need right join. Now this explanation may not convince you hence consider the below example: In my video, the last query I wrote was to fetch ALL emp, dept, manager and project details.. Imagine, instead of this, if the requirement was to fetch ALL emp, dept, ALL managers and project then for such cases we would need to use both left and right join together. Sample query below: -- Fetch details of ALL emp and ALL manager, their department and the projects they work on. select e.emp_name, d.dept_name, m.manager_name, p.project_name from employee e left join department d on d.dept_id = e.dept_id right join manager m on m.manager_id = e.manager_id left join projects p on p.team_member_id = e.emp_id;
Subqueries and Joins are 2 different things.. we should not mix them. Joins can be used everywhere even inside a subquery. I tried to explain the reason why we need both left and right join in above comment. Hope that clarifies Zahid..
I tried to answer it in above comment Laura. Hope it clarifies :) As for more efficient query, it depends on many other factors. The way how you form your query plays a big role in performance too.
OMG..! You are a Marvel..You are a James Bond of SQL..You are beyond my words...You are from another world. 😊 Sir ji, No doubts remained, all clear.....Thank you so much...for this great work.😊
I'm soooo happy I came across this video!! I'm a fresher and still struggle with JOINS and this was the most helpful video I've watched in MONTHS!! You made it easy to understand. THANK YOU Thoufiq!!!
Thank you so much. You made SQL joins so easy to understand. I have not gotten the self join very well but I will watch the video again. Thank you so much 🙏🙏🙏🙏
Hello sir, you are simply amazing .thank you for your videos. I don’t know anything about sql after seeing your videos I lost my fear and I am able to write queries. Thanks for all your efforts. Please educate us . We are blessed to have you like this teacher. Your explanation is very simple and easy understanding 😊😊
Thank you sir, I have watched so many tutorias from your channel and i only have one thing to say that your content is best for learning sql, thanks a lot.
Sharing knowledge freely is also a great sign of good people like you, Thanks again for doing these videos and spending your valuable time on helping us learn.
Oh my God!! I have seen so many videos regarding Joins never i understand the concep even in my native language also I didn't understand. Finally I understood Joins session only after seeing your video. The way you teach was really awesome. Thanks a lot for this amazing video bro 🤗❤️❤️
I just want to add that the point you made at the end about the left join being applicable to all the prior joins up to that point was new information to me and also very helpful. I always learn something from your videos and I so appreciate your time and your method of instruction. Thanks again, sir!
Fantastic Laura. I am glad these details are helping you. Your dedication towards learning and that too from so many different resources is amazing and an inspiration. All the best to you :)
@@techTFQ I’m a little in love with SQL, if I’m honest lol. It makes me sad that I can’t spend as much time with it now. But I do get just a bit of brush up time in every day, to keep my skills fresh!
Kindly provide queries so that we can practice along and have better understanding, only watching videos may not help us that much. But your explanations are wonderful! Thanks.
Left join = inner join + additional records in left table = best explanation I ever heard. Thanks!
Indeed.
or you can say left join=left table + matching values in both table.
@@Somya_bhardwaj01 The original description enforces the 'inner' join concept and builds up from a basic understanding.
Truly! I was stunned when I saw this. Its genius simple.
the mvp of this video was the last join with 4 tables. exactly what i wanted to learn. the internet was filled with simple joins which never did justice to the concept of joins . industries will have 4-6 joins in a query and now i can visualize things way better. most helpful sql video seen all year. we must start small with learning but we must also learn complex stuff till it becomes useful in computer field
The last 10 mins of your video truly clarified issues I had with joining "multiple" tables--beyond the simple two we so many times in tutorials and online course. Thanks so much for taking the time to reinforce these concepts!
Trust my word. You are the only one so far who really made SQL JOIN easy .
Teachers like you are so important to boost our confidence. Thanks a ton for making these videos, which are only helping us in flourishing our career. Loads of blessings
Thank you for your kind words Urvindar..
So glad this helped
You are awesome ur hardwork is amazing
I have not understood SQL JOINS more clearly than the way you taught me. Thank you! I appreciate what you do.
Repeat this episode 2 to 5 times that would help you the concept and use your query window hand on write his code , I assure you definitely got it.
I found techTFQ is one of the best teachers as far I do experience!
Thank you.
have been using sql for years now and watched tons of sql videos, nothing came close to this explanation. After years of using sql, I was still confused with joins, but this video did it.. Thanks for this man, keep it up.
I highly recommend checking out this page for comprehensive tutorials on SQL join queries, as they provide clear explanations and practical examples that have greatly enhanced my understanding of database operations. and kindly help us with some database and give some questions in that.. It will attract more number of students who see this video.anyways thansss
Which page ?
Hi Thoufiq, I am only halfway through and I just have to tell you that you were born to be a teacher. Truly. Even though I’ve now taken so many classes on LearnSQL (per your video recommending that resource, which I really appreciate), so that this is material I know, this is such a great explanation of these concepts. I think what I appreciate most about you is that you include everything I need to hear and nothing I do not need to hear. You don’t waste your time or the viewer’s time with extraneous information. That is a very big deal on UA-cam, where I come for information. I like to use my time well and you clearly keep this in mind when you put your videos together. This is my busy time now in my current job and so I won’t be around as much, but I’m so happy to again see that your channel has grown now to over 30K subscribers. I think that the combination of your skills, experience and knowledge combined with your humble spirit will serve and are serving you well. I wish you all the best for 2022 and many thanks for all of your assistance with SQL. 🙏🏻😊
It's always a pleasure to read your feedback Laura. I am so glad to receive your wishes.
And I imagined when I was making this video that it might relate to you. I am glad it did and I am glad you found this useful.
Thank you so very much for being a constant supporter of my channel and I truly wish you achieve all your goals for this new year :)
@@techTFQ do u take online live SQL classes?
@@techTFQ This is what a beginner always needs. Thanks man, you got a new subscriber !
My American teacher has a way of making the lessons on “Joins” sound so complicated. Thank you for simplifying it sir. For the first time I’ve actually understood it.
I went through so many videos to learn joins and finally I landed here. Thank you so much for this. Your exceptional way of teaching can make learning easy.
Thank you so much 🙏🏼
Glad you liked it
I agree, he’s teachings are so easy to understand
I have been doing sql for years but never quite understood joins as i now understand after watching this video for just a few minutes. Thank you!
Tracy come and teach me😢😂
I watched your SQL basis, intermediate, advanced and interview question videos. You are giving your best to all those categories. Thanks you so much for your efforts bro. Really appreciate your help. 🙏
The joins are much clearer now! Thank you for literally saving my life!!
This guy was born to do this. Your simple method of explanation and clear demonstration is apt. Am catching the vibes, enjoying the groove. Lets go there...
Wow, I just have to say that your videos are some of the best I've ever seen! this sql joins video was absolutely fantastic - your explanations were clear and concise, and I was able to follow along with ease. I've watched a lot of videos on this topic before, but none of them have been as helpful as yours. Thank you so much for taking the time to create such high-quality content - it's truly appreciated!
Agree
Your are the great teacher.. I have 3 yrs experience in sql.. Now I got more clear in joins thank you bro 😊
Thank you Lionel .. glad this helped
Hi Sir,
Earlier I was struggling to get fetch data from 3 three tables, now after watching your 2 two videos several times now I am confident enough to solve any query of SQL... no. of tables doesn't matter. Bunch of thanks for everything Sir.
Now I am targeting windows functions, I never thought I will write such queries but Sir, the way you teach is just amazing 😍😍
Thank you so very much for leaving this feedback bro.. means a lot to receive such amazing feedback 🙏🏼
I had the same problem man. So easy to understand.
The best video i have ever seen in my 3years of IT experience
Hi Thoufiq, browsing your videos could't agree more with others you are born a teacher, clear instructions I think your humbleness and the manner you teach is helpful to me and others. We are with you.
Thank you Rad .. I am glad to hear that
I have to agree 100% I have been trying to learn sql and python and felt lost and confused, anyone teaches it's hard to understand or they talk down to you. So happy I found your content.
BEST EXPLANATION EVER. May ALLAH Bless You Sir❤🙌
You have done an amazing job of breaking these joins down, step by step, and making it simple to understand the differences. Thank you for such a thorough explanation. My professor could learn a thing or two from you.
Great explanation. 8 years experienced here, wanted to revise sql joins for a small project. This video really helped.
Thank you Ruchi..
Glad to know that even an experienced professional like you is benefiting from this content 🙏🏼
This is how the content is delivered, how the teaching is done!
After going through a hell lot of tutorials on Joins, I can confidently say this is the explanation we beginners require!
Though One request I'd like to make. Could you please put the code of the tables you used in the tutorial. This will save our time, and we can focus more on practicing writing the queries itself.
Thanks a lot :)
Thank you very much Akash .. glad you liked it .. the scripts are already shared in my discord
totally agree....this video was a life saviour. Thank you Toufik
You have explained so smoothly n it's actually very easy to understand
Thoufiq bhai I was not able to understand joins concept from one year, but after watching this video i got cleared my all queries, wonderful teaching really appreciated.
The unique thing about this join video is that it helps to understand when to use which join. Certainly boosting my confidence for counter questions on join in an interview.
Glad you liked it
This is a very clear and simple explanation.I almost gave up and thats when I chanced to see this video. I cant believe that I finally learnt Joins! Thanks a ton
I can strongly say that no one can teach this content in such short duration .Thank you for the valuable content
Thank you Manoj 🙏🏼🙏🏼
Hello Thoufiq, i started my journey as a data analyst 3 weeks ago, i stumbled across your video on the explanation of the roadmap for been a data analyst, the skills to develop, to enable someone have at least basic knowledge especially on SQL.
This has guided me through the journey so far, although it all seem lumped up at the moment, bu i am taking it one at a time, since its a new skill for me but your videos has made it easy for me to learn.
Thank you.
Thank you so much Janet .. super glad to know my videos have helped and I wish you all the best in your learning journey
Janet may I know what all skills you need to learn for data analyst profile as a start-up or entry level in this particular domain?? pls reply if possible
Glad I found this channel . You are doing a really great job man. Teaching is a skill which not everyone out there who is teaching have , but this man thoufiq , is a master at this.
Thanks a lot Aman. Feels great to read such feedback :)
Much appreciated!
No one taught me which table is left and right..you do this just.. Thank you sir... Thank you very much... Just this things can me confused me. Today I got clear this.. Thank you very much...
Glad this helped bro ☺️
WOWOOWOWOWOWOOW I REALLY LIKE HOW DID YOU EXPLANED LEFT JOIN AND RIGHT JOIN I LOOOOVE IT
Thank you buddy
Glad you liked it
with how much simplicity you explained the ending question, is just WOW
EPIC EXPLANATION. The level of clarity that I have on JOINS now is insane. Thanks!
Great to hear!
Best youtube class ever, love how you took your time to explain.
Many thanks for this detailed explanation of Joins. I can’t wait for the other part of the video. Notifications has been set.
Thank you James 🙏🏼
I saw the whole video and you explained everything perfectly . Thank you so much ! Really appreciated! I spent so much time studying and still I have the feeling I am not getting anything right .
I was really sad today. Thank you for explaining so clearly and detailed ! 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼
Thank You very much sir!
Your SQL basic, intermediate and advanced all the series are really very helpful and it's totally understandable
You explain all the topics very well
As an aspiring data analyst I can say this tutorials ✨😊 are helping me to achieve my goal
Officially the BEST explanation on SQL JOINS online! WHERE Thoufiq = "awesome";
Amazing quality man..u have taken my SQL to next level that too for free❤❤❤❤
Awesome Shiv , glad you liked it
I usually have a problem with Indian tutors due to accent but yours sir is good, well done well explained !
Wow. Really enjoyed this. Joins was one topic which i was feeling hard to understand in depth. Thanks to this amazing video. I have got a clear idea now. Looking forward to the next one👍🏻✌️
Awesome bro 😍 glad you liked it
You are sooo right. I hated joins till I came across this video by luck. I missed out on a lot of opportunities because I did not have a good understanding on joins till now.
I always have this sort of feeling that joins are kind of confusing. I really appreciate this video helped a lot and boosted my confidence I can now easily run the query. Thanks a ton...!
Hi Thoufiq, you broke down the concept beautifully into mini-concepts and explained it really well. Thank you!
Glad you liked it
It is so unique explanation why someother person did not notice that which is left is left table and right side is right table that is awesome concept
Thank you Anup :)
@@techTFQ ❤️
Among First Viewers , Thank you Thoufiq for the efforts
Thank you bro for watching
Outstanding explanation
99099
Commenting after one year as I watched it full now 😅
Love it after 31.12
Cleared a huge confusion
Hi can you share the dataset which you have explained in the video
Was confused with JOIN, saw many videos but couldn't understand, You explained beautifully
Thank you.
Awesome.. I am glad to read this ..
Many thanks sir, I was looking for this one since a long time
Glad I could help
since past 7 days I am searching for these type of videos. Thank you sir
Excellent teaching
Your work 👏👏👏
Thank you! 😃
I had so much trouble understanding joints, the way you have broken this down was very helpful, thank you.
I'm waiting for the video...1st like mine🤝👍sir
Awesome. Thank you buddy
No one can teach joins better than you. thank you so so much for doing this. This is helpingso many new learners like me. I a going to go through the whole course work
Good Explanation . Thank you
Glad it was helpful!
You are the only one who made JOIN easy. Thank you
very good clear explanation, can you please share the scripts for creating the tables and inserting the data for the explained tables, if we follow the same tables and same data it will be better, Thank you....
Thank you 🙏🏼
I had shared the scripts in my discord server, perhaps you can join my discord server to get those scripts.
Link to join my discord can be found in video description
I am a complete beginner in SQL , JOIN was a tricky topic to understand, but u made it very simple to understand, thank you Thoufiq , you are awesome 🥰🥰🥰
Glad to hear that Abhishek ☺️
Awesome..appreciate your efforts to create such precise and clear contents👏
Thank you 😍
Agreed✨
I did SQL a few years ago in school, Joins was something that I could never understand. Mainly cuz the instructor wasn't very good. Your explanation is very good. Will go thru it a couple times again to make notes so I fully understand and also do examples. But very helpful! :)
Yea take notes to get clearer picture
YOU ARE THE BEST
Thank you buddy 🙏🏼
@@techTFQ it's really good ❤️
this is the best video on joins I have ever come across on YT
Good content 👌
Thank you Saha 🙏🏼
I seen multiple videos on SQL joins and This is the best video to understanding joins completely really excellent explanation.
Amazing explanation, the best part is the practical query execution and tips given while executing them. Really loved it! Thanks 😄
Thank you Vipul .. I appreciate this feedback and that you noticed the details ☺️🙏🏼
@@techTFQ ...!.
I know you've heard this for the umpteenth time but allow me to reiterate that you're the best! Thank you
This is video is quite helpful. You have given answers to a lot many questions that i had. Thanks a lot 😊
Also could you please tell how to create the team_member_id column which has two FOREIGN KEY references in the same column?
Thanks in advance 😊
EXCELLENT explanation of JOINS! Thanks for helping me better understand...hands down the best video ever!
If there are two tables for example employees & Department and you are getting your desired output using left join. If I exchange the table position and used the right join then output will be the same. Then what is the use of left or right join?
For example:--
Select e.emp_name, d.dept_name
From employees e Left Join department d On e.dept_id = d.dept_id ;
Same output with query below.
Select e.emp_name, d.dept_name
From department d Right Join employees e On e.dept_id = d.dept_id ;
Please answer it was asked in interview
@Muhammad Zahid I’d like to know which query is more efficient for the system to run. One with join or with a subquery or does it vary from case to case? Or is there a general rule about this. Would be curious if @TechTFQ has time to answer us. I love this channel! 😀 I would also like to know the answer to Sachin’s question, from the interviewer’s perspective at least.
The reason why we need both LEFT and RIGHT join is because in certain scenarios, you may have to write some query where one specific table might be on the left hence you will need left join and then some other table may be on the right side for which you would need right join.
Now this explanation may not convince you hence consider the below example:
In my video, the last query I wrote was to fetch ALL emp, dept, manager and project details..
Imagine, instead of this, if the requirement was to fetch ALL emp, dept, ALL managers and project then for such cases we would need to use both left and right join together.
Sample query below:
-- Fetch details of ALL emp and ALL manager, their department and the projects they work on.
select e.emp_name, d.dept_name, m.manager_name, p.project_name
from employee e
left join department d on d.dept_id = e.dept_id
right join manager m on m.manager_id = e.manager_id
left join projects p on p.team_member_id = e.emp_id;
Subqueries and Joins are 2 different things.. we should not mix them.
Joins can be used everywhere even inside a subquery.
I tried to explain the reason why we need both left and right join in above comment. Hope that clarifies Zahid..
I tried to answer it in above comment Laura. Hope it clarifies :)
As for more efficient query, it depends on many other factors. The way how you form your query plays a big role in performance too.
@@techTFQ thank you, that makes it very clear! 🙏🏻🙏🏻🙏🏻
OMG..! You are a Marvel..You are a James Bond of SQL..You are beyond my words...You are from another world.
😊 Sir ji, No doubts remained, all clear.....Thank you so much...for this great work.😊
Thank you brother ☺️
It means a lot .. I am so happy the video helped you 🙏🏼
I'm soooo happy I came across this video!! I'm a fresher and still struggle with JOINS and this was the most helpful video I've watched in MONTHS!! You made it easy to understand. THANK YOU Thoufiq!!!
Super glad to know this helped ☺️
Thank you so much. You made SQL joins so easy to understand. I have not gotten the self join very well but I will watch the video again. Thank you so much 🙏🙏🙏🙏
Hello sir, you are simply amazing .thank you for your videos. I don’t know anything about sql after seeing your videos I lost my fear and I am able to write queries. Thanks for all your efforts. Please educate us . We are blessed to have you like this teacher. Your explanation is very simple and easy understanding 😊😊
The best i have ever seen u made me realize that these topics are so easy and anyone at a basic level can master it !!
Thank you sir, I have watched so many tutorias from your channel and i only have one thing to say that your content is best for learning sql, thanks a lot.
after too many videos now am sure that completely understood and am clear about joins after watching your video thank you sso much.
Crazy stuff. The last 10 minutes are a treat to watch ❤✨
This is how the content is delivered, how the teaching is done!
Dude...Great video. I don't think anyone else has a better video on this topic.
Unique video...I hv tried many videos on utube to learn join, but never find the kind of valuable video... thanks a lot...
I am a beginner learner. Overall JOINS are very well explained. Thanks
I’ve watch many videos and none has been as easy as this one. Thank you. Wonderful training.
Glad you liked it :)
The best video you can find on joins is this one ! Thank you so much for the clear explanations
After almost 6 years in industry finally found someone who know how to teach SQL in easy way
Teaching SQL is just like a breakfast for you ,brother!
This is the best tutorial on SQL JOINS I have encountered. Thank you so much!
Sharing knowledge freely is also a great sign of good people like you, Thanks again for doing these videos and spending your valuable time on helping us learn.
Thank you for your kind words 🙏🏼
After watching many videos in youtube this is the Great video for explaining things easier & simply superb
Thank you so much 🙂
This is the only video you need to understand joins!!
This was the best explanation of INNER, LEFT, and RIGHT joins I've ever seen. Thank you!
Thank you very much 😊
underrated SQL teacher. simply amazing
Thank you Javed 🙏🏼
Glad you liked it
Your explanation is very Crystal Clear, God bless you and continue the same spirit
teachers like you can trained anyone..super
This is amazing! Always struggled to learn joins, never thought this video would give me so much clarity.
This was posted 2 years ago? Why am I just seeing this!
Hi Thoufiq, I am only halfway through and I just have to tell you this your content is GOLD!
wow! From now I will never be confused about joins
Oh my God!! I have seen so many videos regarding Joins never i understand the concep even in my native language also I didn't understand. Finally I understood Joins session only after seeing your video. The way you teach was really awesome. Thanks a lot for this amazing video bro 🤗❤️❤️
Glad it was helpful!
I just want to add that the point you made at the end about the left join being applicable to all the prior joins up to that point was new information to me and also very helpful. I always learn something from your videos and I so appreciate your time and your method of instruction. Thanks again, sir!
Fantastic Laura. I am glad these details are helping you.
Your dedication towards learning and that too from so many different resources is amazing and an inspiration.
All the best to you :)
@@techTFQ I’m hoping the interviewers will agree lol! Thanks again, Thoufiq, and thanks as always for your encouragement 🙏🏻😀
@@techTFQ I’m a little in love with SQL, if I’m honest lol. It makes me sad that I can’t spend as much time with it now. But I do get just a bit of brush up time in every day, to keep my skills fresh!
Haha SQL is amazing ☺️..
Why can’t you find time for SQL now .. busy with art work is it?
@@techTFQ no it is my busy time in my day job, but maybe after busy season, will be time for a new career 🙏🏻
Kindly provide queries so that we can practice along and have better understanding, only watching videos may not help us that much. But your explanations are wonderful! Thanks.
This video has really helped me understand joins! Reading the text im going through I was so confused. Thanks!
Thanks a ton sir. I could really understand very well. Honestly couldn't get diverted few seconds also from this video. God bless you.
Glad to hear that Surya :)