SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1

  Рет қаралды 933,032

techTFQ

techTFQ

Күн бұрын

This is the SQL JOINS Tutorial for complete beginners. In this video we shall cover INNER Join, LEFT Join and RIGHT Join. I’ll be posting the second part of this video next week where we shall cover FULL OUTER Join, SELF Join, CROSS Join and NATURAL Join.
Before we talk about different types of Joins in SQL, we shall first understand what are JOINS and why do we need them and then finally write some SQL queries to understand how to use them. We shall practice writing SQL queries using inner, left and right joins in this video.
Joins are the most fundamental concepts in SQL and having a clear understanding of Joins is very essential to write good SQL queries.
Timeline:
00:00 Intro
02:36 What are JOINS in SQL
05:30 Inner Joins in SQL
13:55 Left Join in SQL
19:59 Right Join in SQL
My recommended SQL Course: learnsql.com/?ref=thoufiqmoha...
Join my Discord Server: / discord
Join my FREE live SQL training session:
Batch 1 - Started on 03-Jan-2022 (08:00 pm Malaysian Time / 05:30 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: www.lighthall.co/class/305d73...
Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: www.lighthall.co/class/185a13...
Note: Both batch 1 and batch 2 will cover the exact same topics. Just the date and time are different based on the convenience of everyone.
How to Join the sessions:
1) Go to www.lighthall.co/
2) Click the subject "Data Science"
3) Find my session and click on it. The sessions will automatically start 4 mins prior to the scheduled time.
Please do subscribe and like this video if you found it useful.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq

Пікірлер: 1 100
@makemymarket1772
@makemymarket1772 5 ай бұрын
Left join = inner join + additional records in left table = best explanation I ever heard. Thanks!
@SurajYadav-bc5id
@SurajYadav-bc5id 3 ай бұрын
Indeed.
@visceralcinema
@visceralcinema 5 ай бұрын
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!
@SmoothWingman
@SmoothWingman Жыл бұрын
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
@slaym5900
@slaym5900 Жыл бұрын
Trust my word. You are the only one so far who really made SQL JOIN easy .
@urvindarkaur0278
@urvindarkaur0278 2 жыл бұрын
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
@techTFQ
@techTFQ 2 жыл бұрын
Thank you for your kind words Urvindar.. So glad this helped
@kamalikamukherji6482
@kamalikamukherji6482 Жыл бұрын
You are awesome ur hardwork is amazing
@sivasankarpalpandian2647
@sivasankarpalpandian2647 Жыл бұрын
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. 🙏
@mdnabeelt7801
@mdnabeelt7801 Жыл бұрын
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.
@ninminion
@ninminion 2 жыл бұрын
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.
@laurak5196
@laurak5196 2 жыл бұрын
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 KZfaq, 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. 🙏🏻😊
@techTFQ
@techTFQ 2 жыл бұрын
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 :)
@altafbaig6485
@altafbaig6485 2 жыл бұрын
@@techTFQ do u take online live SQL classes?
@aeroabrar_31
@aeroabrar_31 Жыл бұрын
@@techTFQ This is what a beginner always needs. Thanks man, you got a new subscriber !
@jersonpogi
@jersonpogi Жыл бұрын
I have not understood SQL JOINS more clearly than the way you taught me. Thank you! I appreciate what you do.
@diliplaz4415
@diliplaz4415 3 ай бұрын
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.
@illusion7223
@illusion7223 Жыл бұрын
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
@alpeshutube
@alpeshutube Жыл бұрын
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.
@junedsaleh8415
@junedsaleh8415 Жыл бұрын
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!
@suganthym1438
@suganthym1438 7 ай бұрын
Agree
@arghasen8236
@arghasen8236 Жыл бұрын
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
@elif_zdl
@elif_zdl 5 ай бұрын
The joins are much clearer now! Thank you for literally saving my life!!
@embisonjones4996
@embisonjones4996 Жыл бұрын
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.
@amandixit3555
@amandixit3555 Жыл бұрын
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.
@techTFQ
@techTFQ Жыл бұрын
Thanks a lot Aman. Feels great to read such feedback :) Much appreciated!
@LowandSlowwithPriya
@LowandSlowwithPriya 2 жыл бұрын
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.
@techTFQ
@techTFQ 2 жыл бұрын
Thank you so much 🙏🏼 Glad you liked it
@Motivation_Station_Neo
@Motivation_Station_Neo 2 жыл бұрын
I agree, he’s teachings are so easy to understand
@KenAgim
@KenAgim Жыл бұрын
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...
@thejunayaka6200
@thejunayaka6200 Жыл бұрын
Hi Thoufiq, I just want to thank you for this simple explanation on the JOIN concepts in SQL.
@YOitsRAD
@YOitsRAD 2 жыл бұрын
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.
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Rad .. I am glad to hear that
@catcreamlive4462
@catcreamlive4462 2 жыл бұрын
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.
@manojkumarmanu6907
@manojkumarmanu6907 2 жыл бұрын
I can strongly say that no one can teach this content in such short duration .Thank you for the valuable content
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Manoj 🙏🏼🙏🏼
@aspa18
@aspa18 2 ай бұрын
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 ! 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼
@akashgautam1909
@akashgautam1909 Жыл бұрын
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 :)
@techTFQ
@techTFQ Жыл бұрын
Thank you very much Akash .. glad you liked it .. the scripts are already shared in my discord
@suranjanasaikia8200
@suranjanasaikia8200 Жыл бұрын
totally agree....this video was a life saviour. Thank you Toufik
@payalkashyap11
@payalkashyap11 10 ай бұрын
You have explained so smoothly n it's actually very easy to understand
@yaseenzuhaib4992
@yaseenzuhaib4992 2 жыл бұрын
Hi Thoufiq, you broke down the concept beautifully into mini-concepts and explained it really well. Thank you!
@techTFQ
@techTFQ 2 жыл бұрын
Glad you liked it
@ATFAtlis
@ATFAtlis Жыл бұрын
I had so much trouble understanding joints, the way you have broken this down was very helpful, thank you.
@tommyd5555
@tommyd5555 6 ай бұрын
This is the best tutorial on SQL JOINS I have encountered. Thank you so much!
@iampowr
@iampowr 2 жыл бұрын
WOWOOWOWOWOWOOW I REALLY LIKE HOW DID YOU EXPLANED LEFT JOIN AND RIGHT JOIN I LOOOOVE IT
@techTFQ
@techTFQ 2 жыл бұрын
Thank you buddy Glad you liked it
@mohammedshahil4898
@mohammedshahil4898 2 жыл бұрын
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👍🏻✌️
@techTFQ
@techTFQ 2 жыл бұрын
Awesome bro 😍 glad you liked it
@MrChero76
@MrChero76 2 жыл бұрын
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.
@samuelbekoe2354
@samuelbekoe2354 5 ай бұрын
Best youtube class ever, love how you took your time to explain.
@user-cn3wf9uc5e
@user-cn3wf9uc5e 8 күн бұрын
with how much simplicity you explained the ending question, is just WOW
@sakshamchaturvedi
@sakshamchaturvedi Жыл бұрын
EPIC EXPLANATION. The level of clarity that I have on JOINS now is insane. Thanks!
@techTFQ
@techTFQ Жыл бұрын
Great to hear!
@sspinjari7643
@sspinjari7643 2 жыл бұрын
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 😍😍
@techTFQ
@techTFQ 2 жыл бұрын
Thank you so very much for leaving this feedback bro.. means a lot to receive such amazing feedback 🙏🏼
@balugovind
@balugovind 2 жыл бұрын
I had the same problem man. So easy to understand.
@tapfumamanhanga
@tapfumamanhanga 10 ай бұрын
I loved the video tutorial. Concepts are clearly explained. Way better than some tutorials on premium platforms.
@shahedasoonasra6552
@shahedasoonasra6552 Жыл бұрын
Hi Taufiq, I just started a crash course in SQL query through work taught by someone from work and I was so lost and frustrated because I couldn't even get the basic concept of the Select or any of the main Join statements. You made it so simple and perfect to understand how to run a query. Thank you so much. I was wondering if you have lessons on the WHERE and the different SQL Functions lessons.
@enefiokjames205
@enefiokjames205 2 жыл бұрын
Many thanks for this detailed explanation of Joins. I can’t wait for the other part of the video. Notifications has been set.
@techTFQ
@techTFQ 2 жыл бұрын
Thank you James 🙏🏼
@vgaurav3011
@vgaurav3011 2 жыл бұрын
Amazing explanation, the best part is the practical query execution and tips given while executing them. Really loved it! Thanks 😄
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Vipul .. I appreciate this feedback and that you noticed the details ☺️🙏🏼
@katamgariravanamma1474
@katamgariravanamma1474 2 жыл бұрын
@@techTFQ ...!.
@swapnilpatil3329
@swapnilpatil3329 Жыл бұрын
Very well understood. Now I'm fearless from JOIN queries...😀🤗 Thank you so much for this video.
@toocool9089
@toocool9089 3 ай бұрын
This is mind blowing info, ah ha moments all the way through. He simplified joins to the next level. Thank you!!
@bhaveshnair5801
@bhaveshnair5801 Жыл бұрын
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.
@techTFQ
@techTFQ Жыл бұрын
Glad you liked it
@RaviKumar-pn8uw
@RaviKumar-pn8uw 2 жыл бұрын
I'm waiting for the video...1st like mine🤝👍sir
@techTFQ
@techTFQ 2 жыл бұрын
Awesome. Thank you buddy
@abdullinkshare9818
@abdullinkshare9818 2 жыл бұрын
after watching so many videos on youtube on sql joins, Your video is perfect + simple + great and simple explanation without jumping the topic. many thanks Thoufiq :)
@sindhuraadusumilli5550
@sindhuraadusumilli5550 2 ай бұрын
This is amazing! Always struggled to learn joins, never thought this video would give me so much clarity.
@laxminarayan4237
@laxminarayan4237 2 жыл бұрын
Excellent teaching Your work 👏👏👏
@techTFQ
@techTFQ 2 жыл бұрын
Thank you! 😃
@ginormica2282
@ginormica2282 2 жыл бұрын
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 😊
@tracy.i6649
@tracy.i6649 6 ай бұрын
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!
@dbest282
@dbest282 5 ай бұрын
Tracy come and teach me😢😂
@kiddosknowledgewizbyakshit9954
@kiddosknowledgewizbyakshit9954 25 күн бұрын
Unique video...I hv tried many videos on utube to learn join, but never find the kind of valuable video... thanks a lot...
@rajendrakakde2622
@rajendrakakde2622 2 жыл бұрын
Many thanks sir, I was looking for this one since a long time
@techTFQ
@techTFQ 2 жыл бұрын
Glad I could help
@shivsharma9153
@shivsharma9153 2 жыл бұрын
Amazing quality man..u have taken my SQL to next level that too for free❤❤❤❤
@techTFQ
@techTFQ 2 жыл бұрын
Awesome Shiv , glad you liked it
@AlvinAbrahamJohn
@AlvinAbrahamJohn 10 ай бұрын
So well explained, I wanted to brush up my skills and this video goes to show with various scenarios to understand JOINS better which most professors just explain the skeleton and let it go , thank you for your hard work put in this video and helping us! Learning better!!
@chandradhamii
@chandradhamii Жыл бұрын
This is how the content is delivered, how the teaching is done!
@gowtham7819
@gowtham7819 2 жыл бұрын
Good Explanation . Thank you
@techTFQ
@techTFQ 2 жыл бұрын
Glad it was helpful!
@kashmirshadows8150
@kashmirshadows8150 2 жыл бұрын
Among First Viewers , Thank you Thoufiq for the efforts
@techTFQ
@techTFQ 2 жыл бұрын
Thank you bro for watching
@swapnavallepu2417
@swapnavallepu2417 Жыл бұрын
Outstanding explanation
@ItsAKWorld-jy7hb
@ItsAKWorld-jy7hb 11 ай бұрын
99099
@kashmirshadows8150
@kashmirshadows8150 10 ай бұрын
Commenting after one year as I watched it full now 😅 Love it after 31.12 Cleared a huge confusion
@Abhishek_videos1980
@Abhishek_videos1980 5 ай бұрын
Hi can you share the dataset which you have explained in the video
@user-fp5tc1cj2d
@user-fp5tc1cj2d 4 ай бұрын
I seen multiple videos on SQL joins and This is the best video to understanding joins completely really excellent explanation.
@kettianesbitt8670
@kettianesbitt8670 2 жыл бұрын
I’ve watch many videos and none has been as easy as this one. Thank you. Wonderful training.
@techTFQ
@techTFQ 2 жыл бұрын
Glad you liked it :)
@subhrajitsaha2713
@subhrajitsaha2713 2 жыл бұрын
Good content 👌
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Saha 🙏🏼
@chinnapalaiah7907
@chinnapalaiah7907 2 жыл бұрын
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....
@techTFQ
@techTFQ 2 жыл бұрын
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
@eyesmind9312
@eyesmind9312 Жыл бұрын
this is the best video on joins I have ever come across on YT
@vishalpatil-vj8gt
@vishalpatil-vj8gt 3 ай бұрын
wow! From now I will never be confused about joins
@yojanbrandon7753
@yojanbrandon7753 2 жыл бұрын
YOU ARE THE BEST
@techTFQ
@techTFQ 2 жыл бұрын
Thank you buddy 🙏🏼
@I_am_smooth_as_butter
@I_am_smooth_as_butter Жыл бұрын
@@techTFQ it's really good ❤️
@fathimafarahna2633
@fathimafarahna2633 2 жыл бұрын
Awesome..appreciate your efforts to create such precise and clear contents👏
@techTFQ
@techTFQ 2 жыл бұрын
Thank you 😍
@inamdarmohasin992
@inamdarmohasin992 2 жыл бұрын
Agreed✨
@MrSQLifeMrQ
@MrSQLifeMrQ 2 жыл бұрын
Honestly... the most descriptive and explanatory video I have come across. Thank you for making joins so easier to do and understand. Keep up the great work
@MrChero76
@MrChero76 2 жыл бұрын
I agree
@madhupriyanka5943
@madhupriyanka5943 3 ай бұрын
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...!
@sachindixit6170
@sachindixit6170 2 жыл бұрын
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
@laurak5196
@laurak5196 2 жыл бұрын
@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.
@techTFQ
@techTFQ 2 жыл бұрын
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;
@techTFQ
@techTFQ 2 жыл бұрын
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..
@techTFQ
@techTFQ 2 жыл бұрын
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.
@laurak5196
@laurak5196 2 жыл бұрын
@@techTFQ thank you, that makes it very clear! 🙏🏻🙏🏻🙏🏻
@ishitasaxena4245
@ishitasaxena4245 Жыл бұрын
such an underrated channel, these videos are so easy to understand! thank you so much!!
@_kaythebutterfly7828
@_kaythebutterfly7828 11 ай бұрын
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!!!
@techTFQ
@techTFQ 11 ай бұрын
Super glad to know this helped ☺️
@AnishKulkarni-eh3ut
@AnishKulkarni-eh3ut 4 ай бұрын
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
@samuelfrimpong4184
@samuelfrimpong4184 2 жыл бұрын
I know you've heard this for the umpteenth time but allow me to reiterate that you're the best! Thank you
@implementtech9683
@implementtech9683 Жыл бұрын
You did an amazing job, brother, in simplifying the concept of joins to an extreme level.
@minimumeffort1997
@minimumeffort1997 4 ай бұрын
Dude...Great video. I don't think anyone else has a better video on this topic.
@emmaadu5148
@emmaadu5148 3 ай бұрын
Well explained. I am moving on to watch the other videos by you
@markabradley
@markabradley 10 ай бұрын
What a video :) you explained things so completely and so well that I had no questions at the end. Amazing job!!
@Yogi-dc4nw
@Yogi-dc4nw 3 ай бұрын
Excellent Video Sir, thank you for sharing sir
@ritwikabasu7737
@ritwikabasu7737 2 жыл бұрын
Thank you very much. I was unable to understand the concepts. you have simplified so well.
@fazilrahmanz9797
@fazilrahmanz9797 2 ай бұрын
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 !!
@NazCookingDelights
@NazCookingDelights 29 күн бұрын
The best video you can find on joins is this one ! Thank you so much for the clear explanations
@chakash9
@chakash9 4 ай бұрын
Very Nice Explanation ! This video cleared all my doubts about joins.
@lakshmiamulyaramineni2952
@lakshmiamulyaramineni2952 10 ай бұрын
Excellent video this is not just for a comment's sake. This is what I felt while I was watching, moreover, the content was super clear.
@jasjeetsingh3503
@jasjeetsingh3503 Жыл бұрын
Hey I have been looking for some good options to learn joins and suddenly your videos came in my suggestions and booom!! my doubts are super cleared now. Thanks mate!
@SoniaD-fj1nr
@SoniaD-fj1nr 4 ай бұрын
after too many videos now am sure that completely understood and am clear about joins after watching your video thank you sso much.
@ruchikakkar3499
@ruchikakkar3499 2 жыл бұрын
Great explanation. 8 years experienced here, wanted to revise sql joins for a small project. This video really helped.
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Ruchi.. Glad to know that even an experienced professional like you is benefiting from this content 🙏🏼
@IsfhanAhmed
@IsfhanAhmed Жыл бұрын
After almost 6 years in industry finally found someone who know how to teach SQL in easy way
@user-in2ge8qr6q
@user-in2ge8qr6q Жыл бұрын
Thoufiq, Excellent teaching. Thank you for your insights
@shawnlowe1392
@shawnlowe1392 10 ай бұрын
This video has really helped me understand joins! Reading the text im going through I was so confused. Thanks!
@joydarshan6778
@joydarshan6778 Жыл бұрын
Thank you so much sir. I’m glad that I found this channel .
@rajansuhagiya7231
@rajansuhagiya7231 Жыл бұрын
This video has very good knowledge of SQL and teacher is amazing
@writerconnect1596
@writerconnect1596 Ай бұрын
I usually have a problem with Indian tutors due to accent but yours sir is good, well done well explained !
@balinnsimon8430
@balinnsimon8430 Жыл бұрын
Thank you very much, this is very clear now for me and now I really understand joins better. I can't wait to put this into practice.
@marylynkaka5733
@marylynkaka5733 4 ай бұрын
Great Job! Awesome! Well explained and so clear. Thank you.
@rahmankhan4994
@rahmankhan4994 Жыл бұрын
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.
@sohailomeromer4554
@sohailomeromer4554 Жыл бұрын
bhai this is what i was searching salute to you and jazakallah.
@lavanyavempati6689
@lavanyavempati6689 6 ай бұрын
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 😊😊
@abhisheknaik909
@abhisheknaik909 2 жыл бұрын
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 🥰🥰🥰
@techTFQ
@techTFQ 2 жыл бұрын
Glad to hear that Abhishek ☺️
@pam9367
@pam9367 2 жыл бұрын
Your are the great teacher.. I have 3 yrs experience in sql.. Now I got more clear in joins thank you bro 😊
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Lionel .. glad this helped
@cobbynice208
@cobbynice208 10 ай бұрын
I find this very helpful compared to most of the videos I have watched so far. Thank you Taufic
@chandrimakhastagir2402
@chandrimakhastagir2402 Жыл бұрын
Thank you so much!!Your videos are helping me to understand the difference between the different kinds of joins quite well.
@forcloudstorage7777
@forcloudstorage7777 Жыл бұрын
Thank you so much big brother I always scared of join concept but after watching your video i feel so comfortable with join thank you again ❤️
@vivekchandraundirwade7059
@vivekchandraundirwade7059 Жыл бұрын
Bruh, hands down the best way to explain. Cheers bhai!
@nehalhuda6030
@nehalhuda6030 Жыл бұрын
Great Execution. I was confused in this topic but you have solved all my queries related to joins 👍
@satishkumar-lh6kz
@satishkumar-lh6kz 2 жыл бұрын
Wow! what a wonderful explanation, my long time confusion and queries got cleared, you are awesome, Bless you
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 108 МЛН
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 31 МЛН
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 6 МЛН
Самый Молодой Актёр Без Оскара 😂
00:13
Глеб Рандалайнен
Рет қаралды 6 МЛН
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 123 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,1 МЛН
SQL Joins: Difference Between Inner/Left/Right/Outer Joins
10:52
SQL Basics Tutorial for Beginners (Practice SQL Queries)
1:10:21
techTFQ
Рет қаралды 1,1 МЛН
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 108 МЛН