title
SQL Joins Tutorial For Beginners | Inner, Left, Right, Full Join | SQL Joins With Examples | Edureka

description
πŸ”₯ Edureka MYSQL DBA Certification Training (Use Code "π˜πŽπ”π“π”ππ„πŸπŸŽ"): https://www.edureka.co/search This Edureka video on SQL Joins will discuss the various types of Joins used in SQL Server with examples. The following topics will be covered in this video: 0:54 Introduction to SQL 1:40 What are Joins? 2:11 Types of Joins 14:58 FAQs about Joins Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV Join Edureka’s Meetup community and never miss any event – YouTube Live, Webinars, Workshops etc. https://bit.ly/2EfTXS1 #edureka #edurekasql #sqljoins -------------------------------------------------------------------------------------------------------- Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka SlideShare: https://www.slideshare.net/edurekaIN ------------------------------------------------------------------------------------------------------- How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project 3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 4. You will get Lifetime Access to the recordings in the LMS. 5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate! - - - - - - - - - - - - - - About the Course MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data. - - - - - - - - - - - - - - Who should go for this course? This course can be beneficial for people having the below professional background: Database Developers Application Developers Database Designers Database Administrators - - - - - - - - - - - - - - Project In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :- β€’ Employee list to be maintained having id, name, designation, experience β€’ Salary details having employee id, current salary β€’ Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee β€’ Salary increment to be given by next year if any depending upon constraints β€’ Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted. - - - - - - - - - - - - - - Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).

detail
{'title': 'SQL Joins Tutorial For Beginners | Inner, Left, Right, Full Join | SQL Joins With Examples | Edureka', 'heatmap': [{'end': 407.285, 'start': 372.066, 'weight': 0.992}, {'end': 535.808, 'start': 515.28, 'weight': 0.722}, {'end': 923.139, 'start': 907.012, 'weight': 0.885}], 'summary': 'This tutorial provides an overview of sql joins, emphasizing their significance in managing data, including the 2.5 quinton bytes of data generated daily. it delves into inner, left, right, and full joins, demonstrating their syntax and application through examples, and also covers other join operations such as natural join, many-to-many relationship mapping, hash join, self join, and cross join.', 'chapters': [{'end': 86.306, 'segs': [{'end': 40.181, 'src': 'embed', 'start': 11.257, 'weight': 1, 'content': [{'end': 17.24, 'text': 'Hi everyone, this is Sahithi on behalf of Edureka and I welcome you to the session on SQL joins.', 'start': 11.257, 'duration': 5.983}, {'end': 21.602, 'text': 'So in this session guys will mainly focus on the different types of joins used in SQL.', 'start': 17.54, 'duration': 4.062}, {'end': 27.485, 'text': "Now before I start telling you about the different types of joins in SQL, let me just take you to the topics for today's session.", 'start': 21.942, 'duration': 5.543}, {'end': 35.098, 'text': "So we'll start today's session by understanding what the sequel and then we'll get into the main topic, that is, what are joints in sequel.", 'start': 28.012, 'duration': 7.086}, {'end': 40.181, 'text': 'once you understand what is a join in sequel, will get into the different types of joints and sequel.', 'start': 35.098, 'duration': 5.083}], 'summary': 'Session on sql joins covering different types of joins in sql.', 'duration': 28.924, 'max_score': 11.257, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I11257.jpg'}, {'end': 86.306, 'src': 'embed', 'start': 47.407, 'weight': 0, 'content': [{'end': 48.428, 'text': "All right, so that's great.", 'start': 47.407, 'duration': 1.021}, {'end': 52.571, 'text': "So now let's move forward with the first topic that is introduction to sequel.", 'start': 48.688, 'duration': 3.883}, {'end': 57.885, 'text': 'Now, in the era of 2.5 Quinton bytes of data being generated every day.', 'start': 53.22, 'duration': 4.665}, {'end': 62.571, 'text': 'data obviously plays a crucial role in decision-making for many business operations.', 'start': 57.885, 'duration': 4.686}, {'end': 67.576, 'text': 'Now this quite quintessentially makes us handle data and various kinds of databases,', 'start': 62.951, 'duration': 4.625}, {'end': 71.481, 'text': 'and this very much gives us the need of using different kinds of databases.', 'start': 67.576, 'duration': 3.905}, {'end': 73.021, 'text': "Now in today's market.", 'start': 71.941, 'duration': 1.08}, {'end': 80.124, 'text': 'There are various kinds of databases like the relational database the hierarchical database the network database and the object-oriented database.', 'start': 73.041, 'duration': 7.083}, {'end': 86.306, 'text': 'But yes sequel is the core of relational database, which is used for accessing and managing the database.', 'start': 80.464, 'duration': 5.842}], 'summary': 'In the era of 2.5 quinton bytes of data being generated every day, data plays a crucial role in decision-making for many business operations, leading to the need for various kinds of databases including the core relational database sql.', 'duration': 38.899, 'max_score': 47.407, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I47407.jpg'}], 'start': 11.257, 'title': 'Sql joins overview', 'summary': 'Introduces sql joins, covering different types of joins used in sql, and the significance of sql in managing data, including the 2.5 quinton bytes of data generated daily and its role in business operations.', 'chapters': [{'end': 86.306, 'start': 11.257, 'title': 'Sql joins overview', 'summary': 'Introduces sql joins, covering different types of joins used in sql, and the significance of sql in managing data, including the 2.5 quinton bytes of data generated daily and its role in business operations.', 'duration': 75.049, 'highlights': ['SQL is the core of relational database, used for accessing and managing the database. SQL is the core of relational database, essential for accessing and managing data.', 'Introduction to sequel: 2.5 Quinton bytes of data being generated every day, playing a crucial role in decision-making for many business operations. Introduces the significance of data in decision-making for business operations, including the 2.5 Quinton bytes of data generated daily.', 'Session focuses on different types of joins used in SQL. The session primarily focuses on explaining the different types of joins used in SQL.']}], 'duration': 75.049, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I11257.jpg', 'highlights': ['Introduction to sequel: 2.5 Quinton bytes of data being generated every day, playing a crucial role in decision-making for many business operations.', 'Session focuses on different types of joins used in SQL.', 'SQL is the core of relational database, used for accessing and managing the database.']}, {'end': 316.45, 'segs': [{'end': 157.121, 'src': 'embed', 'start': 101.681, 'weight': 0, 'content': [{'end': 110.332, 'text': 'what are joints in sequel joints in sequel a commands which are used to combine rows from two or more tables based on the related column between those tables.', 'start': 101.681, 'duration': 8.651}, {'end': 118.102, 'text': 'the joints are predominantly used when a user is trying to extract data from a table which have one too many relationships between them or many,', 'start': 110.332, 'duration': 7.77}, {'end': 119.704, 'text': 'too many relationships between them.', 'start': 118.102, 'duration': 1.602}, {'end': 127.881, 'text': 'Joins in sequel are basically commands guys by which you can join two tables and you can get the rows of two tables based on a related column.', 'start': 120.217, 'duration': 7.664}, {'end': 131.483, 'text': 'Now, if you ask me, what are the different types of joints in sequel?', 'start': 128.281, 'duration': 3.202}, {'end': 137.346, 'text': 'there are mainly four types of joints in sequel, that is, the inner joint, the left joint, the right joint and the full joint.', 'start': 131.483, 'duration': 5.863}, {'end': 140.007, 'text': "So let's look into each one of them one by one.", 'start': 137.686, 'duration': 2.321}, {'end': 141.788, 'text': 'Starting with the inner joint.', 'start': 140.487, 'duration': 1.301}, {'end': 147.653, 'text': 'The inner joint is a type of joint that returns those records which have matching values in both the tables.', 'start': 142.028, 'duration': 5.625}, {'end': 153.017, 'text': 'So if you consider table A and table B and you apply an inner joint on both these tables,', 'start': 148.033, 'duration': 4.984}, {'end': 157.121, 'text': 'then all those records would be returned which have matching values in both these tables.', 'start': 153.017, 'duration': 4.104}], 'summary': 'Sequel joins combine tables based on related columns; 4 types: inner, left, right, full.', 'duration': 55.44, 'max_score': 101.681, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I101681.jpg'}, {'end': 193.928, 'src': 'embed', 'start': 171.767, 'weight': 3, 'content': [{'end': 180.277, 'text': 'So the syntax for inner join is as you can see on the screen that a select table 1 dot column 1 table 2 dot column 2 table 2 dot column 1 and so on.', 'start': 171.767, 'duration': 8.51}, {'end': 188.045, 'text': 'So, basically, these are the various columns that you want to retrieve from the respective tables, from table 1, inner join, table 2.', 'start': 180.557, 'duration': 7.488}, {'end': 193.928, 'text': "that is, basically you're applying the inner join on table 1 and table 2, and then you have to mention the related column.", 'start': 188.045, 'duration': 5.883}], 'summary': 'Syntax for inner join: select table1.column1, table2.column2, table2.column1, etc.', 'duration': 22.161, 'max_score': 171.767, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I171767.jpg'}, {'end': 296.822, 'src': 'embed', 'start': 243.387, 'weight': 4, 'content': [{'end': 251.272, 'text': "So I'll just execute this particular statement and you'll see that you'll get the output as all the details from the employee table that I've already created.", 'start': 243.387, 'duration': 7.885}, {'end': 259.197, 'text': 'I have around five rows with five employee IDs and their first name, last name, age, email ID, phone number, and address feeded into this table.', 'start': 251.653, 'duration': 7.544}, {'end': 265.943, 'text': "So similarly, I'll show you the projects table, right? So let me just remove this and let me type in project.", 'start': 259.498, 'duration': 6.445}, {'end': 272.521, 'text': "and just execute this particular statement and you'll see the different column attributes in the project table.", 'start': 267.194, 'duration': 5.327}, {'end': 278.249, 'text': 'So, as you can see, I have the project ID, the employee ID, the client ID, project name and the project start date.', 'start': 272.541, 'duration': 5.708}, {'end': 280.772, 'text': 'client ID can be basically considered for all those clients.', 'start': 278.249, 'duration': 2.523}, {'end': 283.136, 'text': 'So you can have a separate table for the client IDs.', 'start': 280.792, 'duration': 2.344}, {'end': 288.798, 'text': "So, guys, if you see, in both these tables there's a matching column, that is, the employee ID right?", 'start': 283.656, 'duration': 5.142}, {'end': 296.822, 'text': 'So the basic relation between both these tables is that a specific employee having a specific employee ID can work on n number of projects right?', 'start': 289.118, 'duration': 7.704}], 'summary': 'Demonstrating sql queries on employee and project tables with 5 employee ids and their details, and project attributes.', 'duration': 53.435, 'max_score': 243.387, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I243387.jpg'}], 'start': 86.706, 'title': 'Sql joins and syntax', 'summary': 'Covers sequel joins, exploring inner, left, right, and full joins, with a focus on joining employee and project tables using sql syntax, emphasizing matching values and relationship between tables.', 'chapters': [{'end': 140.007, 'start': 86.706, 'title': 'Understanding sequel joins', 'summary': 'Delves into the concept of sequel joins, which are commands used to combine rows from tables based on related columns, with a focus on the four main types: inner, left, right, and full joins.', 'duration': 53.301, 'highlights': ['The chapter explains that sequel joins are commands used to combine rows from two or more tables based on related columns, particularly when there are one-to-many or many-to-many relationships between the tables.', 'It highlights the four main types of sequel joins: inner, left, right, and full joins, providing an overview of each type and their significance in data extraction and analysis.']}, {'end': 223.219, 'start': 140.487, 'title': 'Understanding inner joins', 'summary': 'Explains the concept of inner joins, using the example of joining employee and project tables, and provides the syntax for applying inner joins in sql, highlighting the importance of matching values in both tables.', 'duration': 82.732, 'highlights': ['The inner join is a type of joint that returns records with matching values in both tables, such as when applying it on the employee and projects tables in SQL.', "The syntax for inner join in SQL involves selecting the desired columns from table 1 and table 2 and specifying the related columns using the 'on' statement.", 'Understanding the concept and syntax of inner joins in SQL is essential for retrieving records with matching values from different tables.']}, {'end': 316.45, 'start': 223.219, 'title': 'Using joins to connect employee and projects tables', 'summary': 'Demonstrates using sql joins to connect the employee and projects tables, showcasing the selection of all details from the employee table and the attributes of the projects table, and highlighting the relationship between employee ids and projects.', 'duration': 93.231, 'highlights': ['The employee table contains five rows with details of five employees, including their IDs, names, age, email, phone number, and address. The employee table contains five rows with details of five employees, including their IDs, names, age, email, phone number, and address.', 'The projects table includes attributes such as project ID, employee ID, client ID, project name, and project start date. The projects table includes attributes such as project ID, employee ID, client ID, project name, and project start date.', 'The relation between the tables is based on the matching employee ID, indicating that a specific employee can work on multiple projects. The relation between the tables is based on the matching employee ID, indicating that a specific employee can work on multiple projects.']}], 'duration': 229.744, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I86706.jpg', 'highlights': ['Sequel joins combine rows from tables based on related columns, useful for one-to-many or many-to-many relationships.', 'Types of sequel joins: inner, left, right, and full joins, each significant in data extraction and analysis.', 'Inner join returns records with matching values in both tables, essential for retrieving records from different tables.', "Syntax for inner join in SQL involves selecting desired columns from table 1 and table 2, specifying related columns using 'on' statement.", 'Employee table contains details of five employees, including IDs, names, age, email, phone number, and address.', 'Projects table includes attributes such as project ID, employee ID, client ID, project name, and project start date.', 'Relation between tables is based on matching employee ID, indicating a specific employee can work on multiple projects.']}, {'end': 685.445, 'segs': [{'end': 343.297, 'src': 'embed', 'start': 316.73, 'weight': 0, 'content': [{'end': 321.072, 'text': "So let's apply the joint statements on these tables and understand what we get as output.", 'start': 316.73, 'duration': 4.342}, {'end': 324.321, 'text': 'So initially I had explained you what the inner joint was.', 'start': 321.559, 'duration': 2.762}, {'end': 330.466, 'text': 'So when you apply inner join and two tables, you can clearly see that, you know, you get matching values from both the tables.', 'start': 324.681, 'duration': 5.785}, {'end': 333.808, 'text': "So what I'm going to do is I'm going to apply inner join on both these tables.", 'start': 330.746, 'duration': 3.062}, {'end': 336.31, 'text': 'So for that you simply have to write a query.', 'start': 333.888, 'duration': 2.422}, {'end': 339.793, 'text': "So what I'll do is I've already executed it before.", 'start': 336.89, 'duration': 2.903}, {'end': 343.297, 'text': "I'll just copy and paste the query over here so that I can explain it for you guys.", 'start': 339.793, 'duration': 3.504}], 'summary': 'Applying inner join on two tables to get matching values.', 'duration': 26.567, 'max_score': 316.73, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I316730.jpg'}, {'end': 407.285, 'src': 'heatmap', 'start': 372.066, 'weight': 0.992, 'content': [{'end': 378.552, 'text': 'employee.mpid is equal to project.mpid, because MPID is basically a matching column in both the tables right?', 'start': 372.066, 'duration': 6.486}, {'end': 381.074, 'text': "So let's just execute this particular query.", 'start': 378.792, 'duration': 2.282}, {'end': 387.786, 'text': 'So when you execute this particular query, you can clearly see that all the matching values from both the tables have been retrieved.', 'start': 381.92, 'duration': 5.866}, {'end': 393.352, 'text': 'That is basically all the employees working on a specific project and the respective employee ID.', 'start': 387.846, 'duration': 5.506}, {'end': 396.956, 'text': 'employee first name, last name, project ID in the project name has been retrieved.', 'start': 393.352, 'duration': 3.604}, {'end': 399.138, 'text': 'So guys that was about inner joint.', 'start': 397.336, 'duration': 1.802}, {'end': 403.202, 'text': "Now let's move forward to our next type of joint, that is, the left joint.", 'start': 399.538, 'duration': 3.664}, {'end': 407.285, 'text': 'now, as you can see on the screen now, the left joint, or the left outer joint,', 'start': 403.202, 'duration': 4.083}], 'summary': 'Employee.mpid matches project.mpid, showing matching values from both tables. explains inner and left join types.', 'duration': 35.219, 'max_score': 372.066, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I372066.jpg'}, {'end': 469.085, 'src': 'embed', 'start': 443.573, 'weight': 1, 'content': [{'end': 448.496, 'text': 'So, basically, if you have around three rows from the left table which have no matching records from the right table,', 'start': 443.573, 'duration': 4.923}, {'end': 450.557, 'text': 'then those records will have null values.', 'start': 448.496, 'duration': 2.061}, {'end': 453.858, 'text': 'So the syntax for left join is as you can see in the screen.', 'start': 450.877, 'duration': 2.981}, {'end': 455.779, 'text': "It's just similar to inner join.", 'start': 454.219, 'duration': 1.56}, {'end': 458.56, 'text': 'You just have to replace the word inner join to left join.', 'start': 456.039, 'duration': 2.521}, {'end': 460.501, 'text': 'You can change the syntax, like you know.', 'start': 458.881, 'duration': 1.62}, {'end': 463.963, 'text': 'select table 1, that column 1, table 2 dot column 2 and so on.', 'start': 460.501, 'duration': 3.462}, {'end': 469.085, 'text': 'that is basically the different column attributes that you want to retrieve from table 1 and then left,', 'start': 463.963, 'duration': 5.122}], 'summary': 'Left join outputs null values for unmatched records, syntax is similar to inner join.', 'duration': 25.512, 'max_score': 443.573, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I443573.jpg'}, {'end': 546.352, 'src': 'heatmap', 'start': 515.28, 'weight': 0.722, 'content': [{'end': 518.542, 'text': 'So, once you execute this query, you can clearly see the output,', 'start': 515.28, 'duration': 3.262}, {'end': 523.645, 'text': 'all the records from the left table and for those records which do not have any matching record, for the right table.', 'start': 518.542, 'duration': 5.103}, {'end': 525.087, 'text': 'We have a null value present.', 'start': 523.706, 'duration': 1.381}, {'end': 529.185, 'text': 'So, if you remember, we had five employees in the employee table right?', 'start': 525.603, 'duration': 3.582}, {'end': 535.808, 'text': 'So, basically, that was Warden Himani, Ayushi Swati and payment, and if you remember, I you, she worked on two projects.', 'start': 529.205, 'duration': 6.603}, {'end': 540.55, 'text': 'So both the project details are present over here and he month worked on no project right?', 'start': 536.108, 'duration': 4.442}, {'end': 546.352, 'text': 'So since he worked on no project, the values present in the project ID and the project name are null values by default.', 'start': 540.77, 'duration': 5.582}], 'summary': 'Executing query reveals 5 employees, 2 projects, and null values for non-matching records.', 'duration': 31.072, 'max_score': 515.28, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I515280.jpg'}, {'end': 576.912, 'src': 'embed', 'start': 548.793, 'weight': 2, 'content': [{'end': 550.914, 'text': "Now, let's move forward to the next type of joint.", 'start': 548.793, 'duration': 2.121}, {'end': 551.995, 'text': 'That is the right joint.', 'start': 550.954, 'duration': 1.041}, {'end': 560.841, 'text': 'So the right join or the right outer join returns all the records from the right table and also those records with satisfy a condition from the left table.', 'start': 552.475, 'duration': 8.366}, {'end': 564.203, 'text': 'So I know guys this sounds quite similar to the left outer join.', 'start': 561.241, 'duration': 2.962}, {'end': 566.045, 'text': 'Yes, it definitely is.', 'start': 564.484, 'duration': 1.561}, {'end': 568.366, 'text': 'the only difference between both of them is that you know,', 'start': 566.045, 'duration': 2.321}, {'end': 574.911, 'text': 'the right outer joint returns all the records from the right table and also the records with satisfy a condition from the left table.', 'start': 568.366, 'duration': 6.545}, {'end': 576.912, 'text': 'Coming to the left outer giant.', 'start': 575.291, 'duration': 1.621}], 'summary': 'The right outer join returns all records from the right table and those satisfying a condition from the left table.', 'duration': 28.119, 'max_score': 548.793, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I548793.jpg'}], 'start': 316.73, 'title': 'Sql joins', 'summary': 'Explains inner join, left join, and right join in sql, highlighting their differences and syntax, with examples. it also covers the process of applying an inner join on two tables, demonstrating how it retrieves matching values using a specific query.', 'chapters': [{'end': 393.352, 'start': 316.73, 'title': 'Understanding inner joins in sql', 'summary': 'Explains the process of applying an inner join on two tables in sql, demonstrating how it retrieves matching values from both tables using a specific query.', 'duration': 76.622, 'highlights': ['The chapter demonstrates how to apply an inner join on two tables in SQL, retrieving matching values by executing a specific query.', 'It explains the process of selecting specific columns like employee ID, first name, last name, project ID, and project name from the employee and project tables.', 'The speaker provides a step-by-step explanation of writing and executing the query to apply an inner join, showcasing the retrieval of all matching values from both tables.']}, {'end': 685.445, 'start': 393.352, 'title': 'Understanding joins in sql', 'summary': 'Explains inner join, left join, and right join in sql, highlighting the differences and syntax for each join type, with examples demonstrating the retrieval of records and handling of null values.', 'duration': 292.093, 'highlights': ['Explaining Left Join The left join retrieves all records from the left table and those records which satisfy a condition from the right table, with the output containing null values for records with no matching values from the right table.', 'Distinguishing Right Join from Left Join The right join returns all records from the right table and records satisfying a condition from the left table, with examples showing the retrieval of records and handling of null values in the result set.', "Syntax Similarity Across Join Types The syntax for left join and right join is similar, with the only difference being the use of 'left' and 'right' keywords, while the rest of the syntax remains the same for both join types."]}], 'duration': 368.715, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I316730.jpg', 'highlights': ['The chapter demonstrates how to apply an inner join on two tables in SQL, retrieving matching values by executing a specific query.', 'Explaining Left Join The left join retrieves all records from the left table and those records which satisfy a condition from the right table, with the output containing null values for records with no matching values from the right table.', 'Distinguishing Right Join from Left Join The right join returns all records from the right table and records satisfying a condition from the left table, with examples showing the retrieval of records and handling of null values in the result set.']}, {'end': 906.372, 'segs': [{'end': 732.917, 'src': 'embed', 'start': 705.864, 'weight': 1, 'content': [{'end': 710.889, 'text': 'then it will return all those records which either have the matching value in table A or in table B.', 'start': 705.864, 'duration': 5.025}, {'end': 713.73, 'text': 'Now the syntax for full join is really simple.', 'start': 711.469, 'duration': 2.261}, {'end': 718.232, 'text': "It's again the same as the other three joints, but you just have to mention the word full joint.", 'start': 714.03, 'duration': 4.202}, {'end': 720.953, 'text': 'So the syntax is select table 1.', 'start': 718.532, 'duration': 2.421}, {'end': 722.313, 'text': 'Column 1 table 2.', 'start': 720.953, 'duration': 1.36}, {'end': 723.614, 'text': 'Column 2 table 2.', 'start': 722.313, 'duration': 1.301}, {'end': 724.614, 'text': 'Column 1 and so on.', 'start': 723.614, 'duration': 1}, {'end': 732.917, 'text': 'basically different column attributes from table 1 full joint table 2 on table 1 dot matching column name equal to table 2 dot matching column name.', 'start': 724.614, 'duration': 8.303}], 'summary': 'Full join returns records with matching values in both tables. syntax: select table1.column1, table2.column2, etc.', 'duration': 27.053, 'max_score': 705.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I705864.jpg'}, {'end': 778.468, 'src': 'embed', 'start': 744.44, 'weight': 0, 'content': [{'end': 747.2, 'text': "Now since I'm showing you how to apply joints on sequel.", 'start': 744.44, 'duration': 2.76}, {'end': 751.762, 'text': 'Let me just tell you that you know on my sequel the full joint is not applicable.', 'start': 747.541, 'duration': 4.221}, {'end': 757.083, 'text': "So that's the reason since I'm showing you on my sequel workbench the word full joint will not work.", 'start': 752.102, 'duration': 4.981}, {'end': 759.744, 'text': 'to just show you the working of full joint.', 'start': 757.543, 'duration': 2.201}, {'end': 763.245, 'text': "I'm just going to use the word Union in between both these queries.", 'start': 759.944, 'duration': 3.301}, {'end': 769.126, 'text': "So what's going to happen is we're going to retrieve all the values from the left table and the matching value to the right table, that is,", 'start': 763.625, 'duration': 5.501}, {'end': 770.346, 'text': 'through the left joint,', 'start': 769.126, 'duration': 1.22}, {'end': 776.628, 'text': "and then we're going to Union it with all the matching values from the right table and also the values with satisfy condition from the left table.", 'start': 770.346, 'duration': 6.282}, {'end': 778.468, 'text': 'So this is nothing but full joint.', 'start': 776.948, 'duration': 1.52}], 'summary': 'Demonstration of applying full joint in sql, using union to retrieve all values from left and right tables.', 'duration': 34.028, 'max_score': 744.44, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I744440.jpg'}, {'end': 895.181, 'src': 'embed', 'start': 867.482, 'weight': 4, 'content': [{'end': 875.646, 'text': 'you mentioned the keyword select and mention the table name dot, column name, and then you mentioned from table 1 left join, table 2 on,', 'start': 867.482, 'duration': 8.164}, {'end': 878.448, 'text': 'and then you mentioned the matching column names from both the tables right?', 'start': 875.646, 'duration': 2.802}, {'end': 882.75, 'text': 'So you mentioned table 1 dot matching column name equal to table 2 dot matching column name.', 'start': 878.468, 'duration': 4.282}, {'end': 885.633, 'text': "So guys, that's how you can use the different types of joints.", 'start': 883.19, 'duration': 2.443}, {'end': 887.935, 'text': "I hope it's really clear to you guys.", 'start': 886.033, 'duration': 1.902}, {'end': 895.181, 'text': 'If you have any further queries, then you can definitely let us know in the comment section now that you know the different types of joints in sequel.', 'start': 888.055, 'duration': 7.126}], 'summary': 'Explained sql joins with examples and encouraged questions.', 'duration': 27.699, 'max_score': 867.482, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I867482.jpg'}], 'start': 687.046, 'title': 'Understanding full joins in sql', 'summary': 'Explains the concept of full joins in sql, detailing how it returns all records with matching values in the left or right table, and the syntax for applying full joins. it also highlights the limitations of using full joins in mysql and demonstrates the use of union as an alternative. furthermore, it provides examples of the output of full joins and concludes with a brief overview of the syntax for different types of joins in sql.', 'chapters': [{'end': 906.372, 'start': 687.046, 'title': 'Understanding full joins in sql', 'summary': 'Explains the concept of full joins in sql, detailing how it returns all records with matching values in the left or right table, and the syntax for applying full joins. it also highlights the limitations of using full joins in mysql and demonstrates the use of union as an alternative. furthermore, it provides examples of the output of full joins and concludes with a brief overview of the syntax for different types of joins in sql.', 'duration': 219.326, 'highlights': ['The full join returns all records with matching values in the left or right table, demonstrated by retrieving values from both tables and using the UNION operation to simulate a full join.', "The syntax for a full join is similar to other types of joins, requiring the keyword 'FULL JOIN' and specifying the column attributes from both tables to join on matching column names.", 'It is noted that full joins are not applicable in MySQL, and the workaround is to use the UNION operator to achieve the same result.', 'Examples are provided to illustrate the output of full joins, showcasing the retrieval of all values from the left table that satisfy a condition from the right table and vice versa.', 'The explanation also includes a brief overview of the syntax for different types of joins in SQL, emphasizing the keyword usage for inner, left, right, and full joins.']}], 'duration': 219.326, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I687046.jpg', 'highlights': ['The full join returns all records with matching values in the left or right table, demonstrated by retrieving values from both tables and using the UNION operation to simulate a full join.', "The syntax for a full join is similar to other types of joins, requiring the keyword 'FULL JOIN' and specifying the column attributes from both tables to join on matching column names.", 'Examples are provided to illustrate the output of full joins, showcasing the retrieval of all values from the left table that satisfy a condition from the right table and vice versa.', 'It is noted that full joins are not applicable in MySQL, and the workaround is to use the UNION operator to achieve the same result.', 'The explanation also includes a brief overview of the syntax for different types of joins in SQL, emphasizing the keyword usage for inner, left, right, and full joins.']}, {'end': 1384.155, 'segs': [{'end': 928.722, 'src': 'heatmap', 'start': 907.012, 'weight': 0.885, 'content': [{'end': 915.356, 'text': 'A natural join is also a join operation that is used to give an output based on the columns in both the tables between which the join operation is implemented.', 'start': 907.012, 'duration': 8.344}, {'end': 917.877, 'text': "So that's what a natural join is guys.", 'start': 915.816, 'duration': 2.061}, {'end': 923.139, 'text': 'It basically aims to give you output based on the columns between which this join is applied.', 'start': 918.197, 'duration': 4.942}, {'end': 928.722, 'text': 'Now basically natural join is used when you want to make sure that you know, the number of columns returned are less.', 'start': 923.5, 'duration': 5.222}], 'summary': 'Natural join outputs data based on common columns between tables, reducing the number of columns returned.', 'duration': 21.71, 'max_score': 907.012, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I907012.jpg'}, {'end': 949.292, 'src': 'embed', 'start': 923.5, 'weight': 0, 'content': [{'end': 928.722, 'text': 'Now basically natural join is used when you want to make sure that you know, the number of columns returned are less.', 'start': 923.5, 'duration': 5.222}, {'end': 935.765, 'text': 'So, for example, if you see on the screen, we have two tables right, that is table one having two columns and table two having two columns.', 'start': 929.142, 'duration': 6.623}, {'end': 942.889, 'text': 'over here the table one had column names column 1, column 2 and table 2 again has column names, column 1 and column tree.', 'start': 935.765, 'duration': 7.124}, {'end': 949.292, 'text': "Now, if you apply a natural join on both these tables, you'll clearly see that you'll get an output as column 1, column 2,", 'start': 943.329, 'duration': 5.963}], 'summary': 'Natural join ensures fewer columns returned, such as joining two tables with 2 columns each results in 2 columns in the output.', 'duration': 25.792, 'max_score': 923.5, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I923500.jpg'}, {'end': 1107.908, 'src': 'embed', 'start': 1082.123, 'weight': 1, 'content': [{'end': 1088.81, 'text': 'So, basically, these are the two tables which have many-to-many relationships between each other, and also we can have an extra table,', 'start': 1082.123, 'duration': 6.687}, {'end': 1090.732, 'text': 'that is the project to Technologies table.', 'start': 1088.81, 'duration': 1.922}, {'end': 1096.057, 'text': 'Now the project to Technologies table will hold the combination of project and technology in every row.', 'start': 1091.112, 'duration': 4.945}, {'end': 1103.604, 'text': "Now, let's say we have a project a let's say this project a has three Technologies that is devops microservices and Hadoop.", 'start': 1096.577, 'duration': 7.027}, {'end': 1107.908, 'text': 'Now you have to map these Technologies to the project right now.', 'start': 1104.064, 'duration': 3.844}], 'summary': 'Explains the many-to-many relationship between project and technology, with an example of mapping three technologies to a project.', 'duration': 25.785, 'max_score': 1082.123, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I1082123.jpg'}, {'end': 1190.909, 'src': 'embed', 'start': 1166.949, 'weight': 4, 'content': [{'end': 1173.275, 'text': 'guys whenever you have an end-to-end relationship between two tables and you want to apply a join operation between these two tables.', 'start': 1166.949, 'duration': 6.326}, {'end': 1178.681, 'text': 'You just have to create another table, you know, which can have all the combinations of the previous table,', 'start': 1173.616, 'duration': 5.065}, {'end': 1183.906, 'text': 'and then you apply a join operation from table a to table C and then table B to table C.', 'start': 1178.681, 'duration': 5.225}, {'end': 1188.508, 'text': "So I hope I'm clear with this point now, let's move forward with our next question.", 'start': 1184.486, 'duration': 4.022}, {'end': 1190.909, 'text': 'That is what is a hash join now.', 'start': 1188.588, 'duration': 2.321}], 'summary': 'Creating a table with all combinations allows for end-to-end join operations between tables a, b, and c.', 'duration': 23.96, 'max_score': 1166.949, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I1166949.jpg'}, {'end': 1263.704, 'src': 'embed', 'start': 1224.012, 'weight': 2, 'content': [{'end': 1228.617, 'text': 'each row at a time, and then find the matches using the index created in the build phase.', 'start': 1224.012, 'duration': 4.605}, {'end': 1235.224, 'text': 'So hash join is again a type of join which is used to join large tables and it has mainly two steps, that is,', 'start': 1229.037, 'duration': 6.187}, {'end': 1237.807, 'text': 'the build phase in the probe phase in the build phase.', 'start': 1235.224, 'duration': 2.583}, {'end': 1244.814, 'text': 'You basically create an in-memory hash index on the left side of input and in the probe phase, you go through the right side of input,', 'start': 1237.827, 'duration': 6.987}, {'end': 1248.819, 'text': 'each row at a time, and find the match using the index created in the build phase.', 'start': 1244.814, 'duration': 4.005}, {'end': 1250.9, 'text': 'So guys that was about the hash join.', 'start': 1249.259, 'duration': 1.641}, {'end': 1253.06, 'text': "Now, let's move forward with our next question.", 'start': 1251.16, 'duration': 1.9}, {'end': 1255.521, 'text': 'That is what is a self join and a cross join.', 'start': 1253.08, 'duration': 2.441}, {'end': 1259.282, 'text': 'So the self join in other words is a join of a table to itself.', 'start': 1255.801, 'duration': 3.481}, {'end': 1263.704, 'text': 'So this basically means that you know, each row in a table is joined with itself.', 'start': 1259.603, 'duration': 4.101}], 'summary': 'Hash join is used to join large tables; self join joins a table to itself.', 'duration': 39.692, 'max_score': 1224.012, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I1224012.jpg'}, {'end': 1364.374, 'src': 'embed', 'start': 1337.632, 'weight': 5, 'content': [{'end': 1343.454, 'text': 'We use to join statements right that is to join table a to table C and then table B to table C.', 'start': 1337.632, 'duration': 5.822}, {'end': 1349.159, 'text': 'So basically to apply a join operation on three tables, you need to use two joint statements.', 'start': 1344.134, 'duration': 5.025}, {'end': 1352.062, 'text': 'So guys with this we come to an end of this session.', 'start': 1349.62, 'duration': 2.442}, {'end': 1356.626, 'text': 'I hope you found this session informative and I hope you understood what sequel joints are.', 'start': 1352.442, 'duration': 4.184}, {'end': 1359.87, 'text': 'If you have any further queries related to sequel joints,', 'start': 1356.987, 'duration': 2.883}, {'end': 1364.374, 'text': "please comment in the comment section below and we'll make sure we reply to you as soon as possible.", 'start': 1359.87, 'duration': 4.504}], 'summary': 'To perform a join operation on three tables, two join statements are needed. session ended, with the hope of better understanding sql joins.', 'duration': 26.742, 'max_score': 1337.632, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I1337632.jpg'}], 'start': 907.012, 'title': 'Sql join operations', 'summary': 'Covers natural join, many-to-many relationship mapping, hash join, self join, and cross join in sql. it emphasizes reduction in columns returned, use of intermediary tables, and performing join operations on three tables.', 'chapters': [{'end': 1183.906, 'start': 907.012, 'title': 'Natural join and many-to-many relationship mapping', 'summary': 'Introduces the concept of natural join and highlights its advantages over inner join, emphasizing the reduction in the number of columns returned. it also provides insights into mapping many-to-many relationships using two join statements and the significance of an intermediary table in the process.', 'duration': 276.894, 'highlights': ['Natural join reduces redundancy and minimizes the number of columns returned compared to inner join, making it favorable when dealing with a large number of tables. The natural join minimizes redundancy and reduces the number of columns returned, providing a simpler output compared to the inner join, which may lead to data redundancy and a higher number of columns.', 'Explanation of mapping many-to-many relationships using an intermediary table (projects to technologies table) and the necessity of using two join statements to link all three tables together. To map many-to-many relationships, an intermediary table (projects to technologies table) is introduced, and two join statements are used to link the projects, technologies, and intermediary tables together, allowing multiple projects to be assigned to one or more technologies.']}, {'end': 1384.155, 'start': 1184.486, 'title': 'Understanding sql joins and joint operations', 'summary': 'Explains the concepts of hash join, self join, cross join, and performing join operations on three tables in sql. it covers the hash join algorithm, self join as a join of a table to itself, cross join behavior with and without a where condition, and the use of two join statements to apply a join operation on three tables.', 'duration': 199.669, 'highlights': ['The hash join algorithm has mainly two steps: the build phase, where an in-memory hash index is created on the left side of input, and the probe phase, where matches are found using the index created in the build phase. The hash join algorithm involves a build phase to create an in-memory hash index on the left side of input and a probe phase to find matches using the index, providing a structured approach to join large tables.', 'A self join is a join of a table to itself, meaning each row in a table is joined with itself. A self join involves joining each row in a table with itself, creating a relationship between the rows within the same table.', 'A cross join applies a join clause to each row of one table to every row of the other table, behaving as an inner join when a where condition is present and as a Cartesian product when the where condition is not present. A cross join applies a join clause to each row of one table to every row of the other table, acting as an inner join with a where condition and as a Cartesian product without a where condition, offering flexibility in defining relationships between tables.', 'To perform a join operation on three tables, two join statements are used to join table A to table C and then table B to table C. Performing a join operation on three tables involves using two join statements to establish relationships between the tables, facilitating the retrieval of relevant data from multiple sources.']}], 'duration': 477.143, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/bLL5NbBEg2I/pics/bLL5NbBEg2I907012.jpg', 'highlights': ['Natural join reduces redundancy and minimizes columns returned, favorable for large tables.', 'Explanation of mapping many-to-many relationships using an intermediary table and two join statements.', 'Hash join involves build phase creating in-memory hash index and probe phase for matches.', 'Self join creates a relationship between rows within the same table.', 'Cross join offers flexibility in defining relationships between tables.', 'Performing a join operation on three tables involves using two join statements.']}], 'highlights': ['Sequel joins combine rows from tables based on related columns, useful for one-to-many or many-to-many relationships.', 'The chapter demonstrates how to apply an inner join on two tables in SQL, retrieving matching values by executing a specific query.', 'The full join returns all records with matching values in the left or right table, demonstrated by retrieving values from both tables and using the UNION operation to simulate a full join.', 'Natural join reduces redundancy and minimizes columns returned, favorable for large tables.']}