SQL Joins With Examples | SQL Joins Tutorial For Beginners | Inner, Left, Right, Full, Self Join
Вставка
- Опубліковано 21 вер 2024
- In this video we have discussed all different types of JOINS.
Inner Join, Left Join, Right Join, Full Outer Join & Self join are explained in details with examples.
Please Find SQL Commands to create Employee and Department table to practice:
drive.google.c...
Thanks for watching. If you want to connect on LinkedIn and stay updated with my professional updates and network with me, here's my LinkedIn profile:
LinkedIn: www.linkedin.com/in/biplabparida
Tables used for Joins and introduction to Joins : 00:13
Inner Join: 1:53
Explanation of how JOIN actually works: 4:45
Left Join & Right Join: 8:56
Full Outer Join : 14:55
Self Join : 15:35
Please like & share the video.
Subscribe the Channel to keep watching interesting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Java Interview Questions and Answers : • JAVA Programs for inte...
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete du...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
Basics of Database : • What is DBMS? Learn B...
SQL OPERATORS : • Operators in SQL || S...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
Solve any Date related query : • How to Solve any SQL Q...
How to use Substring : • Substrings in SQL | L...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Please Find SQL Commands to create Employee and Department table to practice:
drive.google.com/file/d/1pqU1FfjPmRB1JR9MdrE8Jc4I9YpOg1Sx/view
Thanks for watching. If you want to connect on LinkedIn and stay updated with my professional updates and network with me, here's my LinkedIn profile:
LinkedIn: www.linkedin.com/in/biplabparida
Explained very well 👍
I have learnt all these topics earlier from different sources but honestly saying that the way u taught is just the most effective one.
Thanks
What a brilliant explanation seriously! those students who have a confusion or doubt of using joins after watching your video will definitely feel confident for sure, bravo!!!
Thanks 😊. Glad it helped
the explanation was on point . Amazing video🥰🥰🥰
Glad you liked it!!
Sir your teaching is just ❤
I have saw many videos to understand this topics but nothing works but now after watching your videos my all concepts are crystal clear 🫶🩷
Thankyou so much sir
Glad it helped 🙂
loved your explanation
Thanks 👍
Hello Biplab, I am Amritesh Kumar. I have seen your lecture. You have explained well. All the best for your future.
Many many thanks🙂
@@CodingGlitz I hope you remembered my name. We were in GITAM.
Ohhh 🙂.. Bhai let's connect on fb or LinkedIn
Which batch?
@@CodingGlitz I think you have forgotten. I was Asst. Prof. in CSE there. I had taken your Operatng System course.
very nice explained sir thanks a lots
Glad it helped 😄
repect sir... Respect from Ganjam Odisha... Bhali bahut badhia video maja asigala
Dhanyabad 🙏
Great Great Great❤
Thanks 👍
What an explanation sir fabulous ......even a nonmath student can understand each and every corner of contents...
Thanks
Sir you saved my job, was struggling hard to understand joins, Thank you so much sir from Heart :)
You are most welcome
Thanks for this informative video sir.
Thanks. 🙂
doing great jobs...very useful
Thanks alot bro you are really good at explanation, best sql joins video than anyone in UA-cam and even paid course also
Thanks Bro🙂
Best video sir... Please make more videos of complex queries to join more than 2 tables ..... Thanks....
Thanks. Point noted🙂
thanks for the video really helped me understand joins
Glad it helped.
Great Explanation!
Thanks 🙂
Nice 👍
Thanks a lot man
Thanks a lot
Sir how to find students having max. marks in English,Hindi & math
Sir, self join ka syntax samajh mai nahi aaya
Syntax inner join k sath same hi hai bas dono table ka name same hai.
And sir if i want to show deptId it's once then how i can write? Select empid first name....d.deptid.....aise?
Correct kisi v 1 table se deptid select kar sakte ho either e.deptid or d.deptid
Can you tell if there is no match of column in two tables then which join we will use . Self/natural/equi join
Yes we can join using the second syntax without using a where condition for example.
Select * from TableA, TableB;
@@CodingGlitz tell me 1 thing if there are two columns having same value with different column name ,can we use that in join ??
Definitely we can use.
Sir if D have a null department I'd then d.dept.id Virat show hota?
Question samajh me nhn aya..Kahan pe doubt h?
@@CodingGlitz SORRY SIR MY QUESTION VIOLATED THE PRIMARY KEY CONCEPTS (NOT NULL). thank you sir. I understand.. .. and sir i have a another interview Question related to SQL joins. This is have am picture from how can I share with you?
Sir can we use MySQL instead of Oracle database?
Type of database doesn't matter, there might be small changes in syntax but the concept is the same.
And can you explain what is equi join
Equi join is something where we use equality operator for joining. Our inner join query example can be considered as equi join as we have joined on the basis of tableA.id=tableb.id.
@@CodingGlitz we use equality operator in evey join so is all join are considered as equi join?
No we can write joins with other operator as well. Pls try it out.
Can you provide the dataset ?
Please Find SQL Commands to create Employee and Department table to practice:
drive.google.com/file/d/1pqU1FfjPmRB1JR9MdrE8Jc4I9YpOg1Sx/view
Sir I have to ask something related to SQL can I get your contact number ?
@@SK-wp4tm we can connect through mail. biplabparida90@gmail.com or LinkedIn.
E1 wrong hain na
Timestamp bataoge jaban galat hai check karne k liye
Bro if possible pls make videos in english
Added subtitles for most of the videos.