title
SQL Joins | Joins In SQL | Joins In SQL With Examples | SQL Tutorial For Beginners | Simplilearn

description
🔥 IITM Pravartak Professional Certificate Program In Full Stack Development - MERN (India Only): https://www.simplilearn.com/full-stack-developer-course-and-certification-iitm-pravartak?utm_campaign=SCE-FullstackIITM&utm_medium=DescriptionFF&utm_source=youtube 🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=JoinsInSQL-vncBSUNb4NA&utm_medium=DescriptionFF&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=JoinsInSQL-vncBSUNb4NA&utm_medium=DescriptionFF&utm_source=youtube 🔥 Caltech Coding Bootcamp (US Only) https://www.simplilearn.com/coding-bootcamp?utm_campaign=JoinsInSQL-vncBSUNb4NA&utm_medium=DescriptionFF&utm_source=youtube 🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=JoinsInSQL-vncBSUNb4NA&utm_medium=DescriptionFF&utm_source=youtube This video on Joins in SQL will help you understand the different types of joins with hands-on demonstrations on MySQL Workbench. You will learn SQL Joins with examples about Inner join, Left join, Right join, Self joins, and Full outer join. Let's get started with SQL joins. Following are the topics that you will learn in this video: 00:00:00 - 00:02:27 What are Joins in SQL? 00:02:27 - 00:18:57 Inner Join in SQL 00:18:57 - 00:23:19 Left Join in SQL 00:23:19 - 00:31:43 Right Join in SQL 00:31:43 - 00:35:02 Full Join in SQL ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH To access the slides, click hree: https://www.slideshare.net/Simplilearn/joins-in-sql-joins-in-sql-with-examples-sql-joins-sql-tutorial-for-beginners-simplilearn/Simplilearn/joins-in-sql-joins-in-sql-with-examples-sql-joins-sql-tutorial-for-beginners-simplilearn ⏩ Check out the SQL training videos: https://www.youtube.com/playlist?list=PLEiEAq2VkUUKL3yPbn8yWnatjUg0P0I-Z #JoinsInSQL #SQLJoins #JoingInSQLWithExamples #SQLForBeginners #SQLTutorialForBeginners #LearnSQL #SQLExplained #SQLTraining #Simplilearn What are Joins in SQL? A Join command in SQL is used to combine rows from two or more tables based on a related column between them. There are mainly four types of Join - Inner join, Left join, Right join, and Full join. ➡️ About Post Graduate Program In Full Stack Web Development This program will give you the foundation for building full-stack web apps using the Java programming language. You'll begin with the basics of JavaScript, and then venture into some of the more advanced concepts like Angular, Spring Boot, Hibernate, JSPs, and MVC. Now is the perfect time to get started on your career as a full-stack web developer! ✅ Key Features - Caltech CTME Post Graduate Certificate - Enrolment in Simplilearn’s JobAssist - Receive up to 25 CEUs from Caltech CTME - Simplilearn's JobAssist helps you get noticed by top hiring companies - Attend Masterclasses from Caltech CTME instructors - Live virtual classes led by industry experts, hands-on projects and integrated labs - Online Convocation by Caltech CTME Program Director - 20 lesson-end and 5 phase-end projects - Capstone Project in 4 domains - Caltech CTME Circle Membership - Build your own portfolio on GitHub ✅ Skills Covered - Agile - JAVA - Hibernate and JPA - Spring Core 50 - DevOps - HTML5 and CSS3 - AWS - JavaScript ES6 - Servlets - SOAP and REST - JSP 👉Learn More at: https://www.simplilearn.com/pgp-full-stack-web-development-certification-training-course?utm_campaign=JoinsInSQL-vncBSUNb4NA&utm_medium=Description&utm_source=youtube 🔥Explore Our Free Courses: https://www.simplilearn.com/skillup-free-online-courses?utm_campaign=JoinsInSQL&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'SQL Joins | Joins In SQL | Joins In SQL With Examples | SQL Tutorial For Beginners | Simplilearn', 'heatmap': [{'end': 638.401, 'start': 551.886, 'weight': 0.782}, {'end': 873.856, 'start': 719.856, 'weight': 0.723}, {'end': 1147.259, 'start': 1103.516, 'weight': 0.734}, {'end': 1935.289, 'start': 1887.472, 'weight': 0.846}, {'end': 2039.676, 'start': 2012.29, 'weight': 0.828}], 'summary': 'Tutorial on sql joins covers the significance of joins in sql, inner joins, left joins, right joins, self joins, and various join operations, with practical examples and demonstrations to illustrate their applications in retrieving specific information and merging data from multiple tables.', 'chapters': [{'end': 54.182, 'segs': [{'end': 54.182, 'src': 'embed', 'start': 7.318, 'weight': 0, 'content': [{'end': 7.978, 'text': 'Hello everyone.', 'start': 7.318, 'duration': 0.66}, {'end': 10.52, 'text': 'Welcome to this video tutorial on SQL.', 'start': 8.719, 'duration': 1.801}, {'end': 13.362, 'text': 'Today, we will learn about Joins in SQL.', 'start': 10.84, 'duration': 2.522}, {'end': 18.446, 'text': 'Joins are really important when you have to deal with data that is present on multiple tables.', 'start': 14.143, 'duration': 4.303}, {'end': 25.631, 'text': "I'll help you understand the basics of Joins and make you learn the different types of Joins with hands-on demonstrations on MySQL Workbench.", 'start': 19.566, 'duration': 6.065}, {'end': 28.813, 'text': "So let's get started with what are Joins in SQL.", 'start': 26.431, 'duration': 2.382}, {'end': 35.144, 'text': 'SQL JOIN statement or command is often used to fetch data present in multiple tables.', 'start': 30.78, 'duration': 4.364}, {'end': 42.251, 'text': 'SQL JOINs are used to combine rows of data from two or more tables based on a common field or column between them.', 'start': 36.005, 'duration': 6.246}, {'end': 48.516, 'text': 'Now consider this example where we have two tables, an orders table and a customers table.', 'start': 42.551, 'duration': 5.965}, {'end': 54.182, 'text': 'Now the order table has information about the order ID which is unique here.', 'start': 49.858, 'duration': 4.324}], 'summary': 'Introduction to sql joins, important for dealing with data across multiple tables.', 'duration': 46.864, 'max_score': 7.318, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA7318.jpg'}], 'start': 7.318, 'title': 'Sql joins', 'summary': 'Delves into the significance of joins in sql, elaborating on their role in merging data from multiple tables based on a common field. it includes an illustration of joining orders and customers tables with unique order ids.', 'chapters': [{'end': 54.182, 'start': 7.318, 'title': 'Understanding sql joins', 'summary': 'Discusses the importance of joins in sql, their function in combining data from multiple tables based on a common field, and uses an example of joining orders and customers tables with unique order ids.', 'duration': 46.864, 'highlights': ['The SQL JOIN statement is crucial for fetching data from multiple tables, and it is used to combine rows of data based on a common field or column, as demonstrated with the orders and customers tables.', 'The tutorial provides hands-on demonstrations on MySQL Workbench to help understand the basics of Joins and the different types of Joins.', 'The importance of Joins in dealing with data present on multiple tables is emphasized, highlighting their significance in SQL.', 'The example of joining the orders and customers tables with unique order IDs is used to illustrate the function of Joins in combining data from different tables.']}], 'duration': 46.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA7318.jpg', 'highlights': ['The SQL JOIN statement is crucial for fetching data from multiple tables, and it is used to combine rows of data based on a common field or column, as demonstrated with the orders and customers tables.', 'The example of joining the orders and customers tables with unique order IDs is used to illustrate the function of Joins in combining data from different tables.', 'The tutorial provides hands-on demonstrations on MySQL Workbench to help understand the basics of Joins and the different types of Joins.', 'The importance of Joins in dealing with data present on multiple tables is emphasized, highlighting their significance in SQL.']}, {'end': 281.56, 'segs': [{'end': 172.927, 'src': 'embed', 'start': 142.806, 'weight': 0, 'content': [{'end': 146.288, 'text': 'which you can get from the order date column that is present in the orders table.', 'start': 142.806, 'duration': 3.482}, {'end': 151.311, 'text': "Okay, now let's discuss the different types of joins one by one.", 'start': 146.308, 'duration': 5.003}, {'end': 153.713, 'text': 'So first, we have an inner join.', 'start': 151.892, 'duration': 1.821}, {'end': 160.482, 'text': 'So the SQL inner join statement returns all the rows from multiple tables as long as the conditions are met.', 'start': 155.16, 'duration': 5.322}, {'end': 165.644, 'text': 'From the diagram above, you can see that there are two tables A and B.', 'start': 161.803, 'duration': 3.841}, {'end': 168.465, 'text': 'A is the left table and B is the right table.', 'start': 165.644, 'duration': 2.821}, {'end': 172.927, 'text': 'The orange portion represents the output of an inner join.', 'start': 169.485, 'duration': 3.442}], 'summary': 'Explains sql inner join and its usage with tables a and b.', 'duration': 30.121, 'max_score': 142.806, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA142806.jpg'}, {'end': 218.578, 'src': 'embed', 'start': 187.768, 'weight': 2, 'content': [{'end': 195.649, 'text': 'here is the left table, followed by the inner join keyword and then the name of the table, that is b,', 'start': 187.768, 'duration': 7.881}, {'end': 198.71, 'text': 'on a common key column from both the tables a and b.', 'start': 195.649, 'duration': 3.061}, {'end': 203.706, 'text': 'Now let me take you to the MySQL Workbench and show you how inner join works in reality.', 'start': 199.443, 'duration': 4.263}, {'end': 207.79, 'text': "So here, I'll type MySQL.", 'start': 204.647, 'duration': 3.143}, {'end': 214.575, 'text': "You can see I have got MySQL Workbench 8.0 version installed, I'll click on it.", 'start': 208.65, 'duration': 5.925}, {'end': 218.578, 'text': 'It will take some time to open.', 'start': 214.595, 'duration': 3.983}], 'summary': 'Explanation of inner join using mysql workbench 8.0 version.', 'duration': 30.81, 'max_score': 187.768, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA187768.jpg'}, {'end': 281.56, 'src': 'embed', 'start': 253.825, 'weight': 4, 'content': [{'end': 259.289, 'text': 'if I give a semicolon and hit ctrl enter, this will create a new database.', 'start': 253.825, 'duration': 5.464}, {'end': 262.21, 'text': 'you can see here one row affected.', 'start': 259.289, 'duration': 2.921}, {'end': 268.513, 'text': 'now you can check whether the database was created or not using show databases command.', 'start': 262.21, 'duration': 6.303}, {'end': 277.618, 'text': 'if I run it here, you can see I have SQL joins database created.', 'start': 268.513, 'duration': 9.105}, {'end': 278.979, 'text': "now I'll use this database.", 'start': 277.618, 'duration': 1.361}, {'end': 281.56, 'text': "so I'll write use SQL underscore joins.", 'start': 278.979, 'duration': 2.581}], 'summary': 'Using a semicolon and ctrl enter created a new sql joins database.', 'duration': 27.735, 'max_score': 253.825, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA253825.jpg'}], 'start': 55.002, 'title': 'Sql joins and inner joins', 'summary': "Covers sql joins, demonstrating examples of joining tables to retrieve specific information and discussing different types of joins, with a focus on the inner join. it also explains the concept of inner joins, demonstrating the syntax and practical application in mysql workbench, including creating a new database with the 'create database' command, resulting in the message 'one row affected'.", 'chapters': [{'end': 165.644, 'start': 55.002, 'title': 'Sql joins and data retrieval', 'summary': 'Explains the concept of sql joins, including examples of joining tables to retrieve specific information, such as finding phone numbers of customers who ordered a laptop and customer names who ordered a product in the last 30 days, and discusses the different types of joins, with a focus on the inner join.', 'duration': 110.642, 'highlights': ['The chapter explains examples of joining tables to retrieve specific information, such as finding phone numbers of customers who ordered a laptop and customer names who ordered a product in the last 30 days, emphasizing the practical application of SQL joins.', 'It discusses the different types of joins, with a focus on the inner join, providing a clear understanding of how SQL joins work and their relevance in data retrieval.', 'The transcript provides detailed information about the structure of the orders and customers tables, including the attributes such as order date, shipped date, product name, status of delivery, quantity, price, customer id, phone number, customer name, and address, enhancing the understanding of the data being used for SQL joins.', 'It explains the concept of joining tables by using specific examples, such as finding phone numbers of customers who ordered a laptop and customer names who ordered a product in the last 30 days, showcasing the practical application of SQL joins in real-world scenarios.']}, {'end': 281.56, 'start': 165.644, 'title': 'Understanding inner joins in sql', 'summary': "Explains the concept of inner joins in sql, demonstrating the syntax and practical application in mysql workbench, with a key point being the creation of a new 'sql_joins' database with the 'create database' command in mysql workbench, resulting in the message 'one row affected'.", 'duration': 115.916, 'highlights': ['The chapter explains the concept of inner joins in SQL, demonstrating the syntax and practical application in MySQL Workbench.', "Creation of a new 'sql_joins' database with the 'create database' command in MySQL Workbench, resulting in the message 'one row affected'.", 'Explanation of the inner join syntax, including the select command, list of columns, table names, and common key column from both tables.']}], 'duration': 226.558, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA55002.jpg', 'highlights': ['The chapter explains examples of joining tables to retrieve specific information, emphasizing the practical application of SQL joins.', 'It discusses the different types of joins, with a focus on the inner join, providing a clear understanding of how SQL joins work and their relevance in data retrieval.', 'The chapter explains the concept of inner joins in SQL, demonstrating the syntax and practical application in MySQL Workbench.', 'The transcript provides detailed information about the structure of the orders and customers tables, enhancing the understanding of the data being used for SQL joins.', "Creation of a new 'sql_joins' database with the 'create database' command in MySQL Workbench, resulting in the message 'one row affected'."]}, {'end': 694.688, 'segs': [{'end': 372.408, 'src': 'embed', 'start': 314.568, 'weight': 1, 'content': [{'end': 319.909, 'text': 'the first column is going to be cricket ID.', 'start': 314.568, 'duration': 5.341}, {'end': 327.791, 'text': "then I'm going to give the data type as int and use the auto increment operator.", 'start': 319.909, 'duration': 7.882}, {'end': 333.592, 'text': "I'm using auto increment because my cricket ID is going to be my primary key.", 'start': 327.791, 'duration': 5.801}, {'end': 345.859, 'text': "then I'm going to give the name of the students who are part of the cricket team, And for this I'll use varchar data type and give the length as 30..", 'start': 333.592, 'duration': 12.267}, {'end': 351.462, 'text': "I'll give another comma and I'll assign my cricket ID as primary key.", 'start': 345.859, 'duration': 5.603}, {'end': 356.925, 'text': "Within brackets, I'll give cricket underscore ID.", 'start': 352.623, 'duration': 4.302}, {'end': 363.449, 'text': 'Cricket ID is nothing but a unique identifier for each of the players like you have roll numbers in college.', 'start': 358.546, 'duration': 4.903}, {'end': 367.411, 'text': 'Okay Let me just run it.', 'start': 364.869, 'duration': 2.542}, {'end': 369.166, 'text': 'all right.', 'start': 368.826, 'duration': 0.34}, {'end': 372.408, 'text': 'so we have successfully created our cricket table.', 'start': 369.166, 'duration': 3.242}], 'summary': "Created a cricket table with cricket id as primary key and students' names with varchar data type.", 'duration': 57.84, 'max_score': 314.568, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA314568.jpg'}, {'end': 589.157, 'src': 'embed', 'start': 557.597, 'weight': 0, 'content': [{'end': 562.24, 'text': 'alright, so we have five players in the football team as well.', 'start': 557.597, 'duration': 4.643}, {'end': 569.724, 'text': 'okay, now, the question is suppose you want to find the students that are part of both the cricket and football team.', 'start': 562.24, 'duration': 7.484}, {'end': 572.585, 'text': 'in this case you can use an inner join.', 'start': 569.724, 'duration': 2.861}, {'end': 573.946, 'text': 'so let me show you how to do it.', 'start': 572.585, 'duration': 1.361}, {'end': 582.792, 'text': "so I'll write select star from cricket, as I'm using an alias.", 'start': 574.886, 'duration': 7.906}, {'end': 585.815, 'text': 'name as C, which stands for cricket.', 'start': 582.792, 'duration': 3.023}, {'end': 589.157, 'text': "then I'm going to write inner join.", 'start': 585.815, 'duration': 3.342}], 'summary': 'Five players in the football team. using inner join to find students in both cricket and football team.', 'duration': 31.56, 'max_score': 557.597, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA557597.jpg'}, {'end': 654.229, 'src': 'heatmap', 'start': 551.886, 'weight': 3, 'content': [{'end': 555.09, 'text': "I'll write select star from football.", 'start': 551.886, 'duration': 3.204}, {'end': 562.24, 'text': 'alright, so we have five players in the football team as well.', 'start': 557.597, 'duration': 4.643}, {'end': 569.724, 'text': 'okay, now, the question is suppose you want to find the students that are part of both the cricket and football team.', 'start': 562.24, 'duration': 7.484}, {'end': 572.585, 'text': 'in this case you can use an inner join.', 'start': 569.724, 'duration': 2.861}, {'end': 573.946, 'text': 'so let me show you how to do it.', 'start': 572.585, 'duration': 1.361}, {'end': 582.792, 'text': "so I'll write select star from cricket, as I'm using an alias.", 'start': 574.886, 'duration': 7.906}, {'end': 585.815, 'text': 'name as C, which stands for cricket.', 'start': 582.792, 'duration': 3.023}, {'end': 589.157, 'text': "then I'm going to write inner join.", 'start': 585.815, 'duration': 3.342}, {'end': 597.063, 'text': 'my next table is going to be football as F, which is an alias name for the football table.', 'start': 589.157, 'duration': 7.906}, {'end': 608.921, 'text': "then I'm going to use the on command or operator and then I'll give the common key, that is name here.", 'start': 597.063, 'duration': 11.858}, {'end': 611.562, 'text': 'So C dot name is equal to F dot name.', 'start': 609.001, 'duration': 2.561}, {'end': 617.385, 'text': 'So based on this name column from both the table, my energon operation will be performed.', 'start': 612.743, 'duration': 4.642}, {'end': 619.286, 'text': "So let's just run it.", 'start': 618.146, 'duration': 1.14}, {'end': 621.627, 'text': 'There you go.', 'start': 621.147, 'duration': 0.48}, {'end': 626.83, 'text': 'So Stuart Johnson and Hayden are the only three students who are part of both the teams.', 'start': 622.208, 'duration': 4.622}, {'end': 628.131, 'text': 'All right.', 'start': 627.831, 'duration': 0.3}, {'end': 634.399, 'text': 'you can also individually select each of the columns from both the tables.', 'start': 629.776, 'duration': 4.623}, {'end': 638.401, 'text': "so let's say i write select c dot cricket.", 'start': 634.399, 'duration': 4.002}, {'end': 643.944, 'text': 'underscore id comma c dot name.', 'start': 638.401, 'duration': 5.543}, {'end': 647.526, 'text': 'comma f dot football.', 'start': 643.944, 'duration': 3.582}, {'end': 654.229, 'text': 'underscore id comma f dot name from.', 'start': 647.526, 'duration': 6.703}], 'summary': 'Using inner join, 3 students found in both cricket and football teams.', 'duration': 32.021, 'max_score': 551.886, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA551886.jpg'}], 'start': 283.726, 'title': 'Inner joins in databases', 'summary': 'Covers the process of creating tables for a cricket team in a college with primary keys and data types, inserting player names into both cricket and football tables, and using inner joins in sql to find students part of both teams, identifying three students.', 'chapters': [{'end': 372.408, 'start': 283.726, 'title': 'Understanding inner join in databases', 'summary': 'Explains the process of creating a table for a cricket team in a college, highlighting the use of primary keys and data types.', 'duration': 88.682, 'highlights': ['The chapter explains the process of creating a table for a cricket team in a college, highlighting the use of primary keys and data types.', 'The primary key for the cricket table is the cricket ID, which is set as an auto-increment integer to uniquely identify each player.', 'The chapter demonstrates the use of varchar data type to store the names of the students who are part of the cricket team, with a length restriction of 30 characters.']}, {'end': 484.357, 'start': 372.408, 'title': 'Database table creation and data insertion', 'summary': 'Covers the creation of football and cricket tables, inserting player names into both tables, with examples such as stuart, michael, johnson, hayden, and fleming.', 'duration': 111.949, 'highlights': ['The chapter covers the creation of football and cricket tables, inserting player names into both tables.', 'Examples of player names inserted include Stuart, Michael, Johnson, Hayden, and Fleming.', 'The transcript demonstrates the process of creating a football table and inserting player names into the cricket table.', 'The speaker changes the primary key to football ID and runs the script to create the football table.', 'The speaker uses the insert into command to load data into the cricket table with player names such as Stuart, Michael, Johnson, Hayden, and Fleming.']}, {'end': 694.688, 'start': 484.417, 'title': 'Using inner joins in sql', 'summary': 'Demonstrates the process of using inner joins in sql to find students who are part of both the cricket and football teams, resulting in three students being identified as part of both teams.', 'duration': 210.271, 'highlights': ['The chapter demonstrates the process of using inner joins in SQL to find students who are part of both the cricket and football teams. The chapter provides a practical demonstration of using inner joins in SQL to find students who are part of both the cricket and football teams.', 'Three students are identified as part of both the cricket and football teams. The inner join operation results in the identification of three students who are part of both the cricket and football teams.', 'The demonstration includes a practical example using the classic models database. A practical example using the classic models database is explored to further understand the application of inner joins in SQL.']}], 'duration': 410.962, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA283726.jpg', 'highlights': ['The chapter demonstrates the process of using inner joins in SQL to find students who are part of both the cricket and football teams.', 'The primary key for the cricket table is the cricket ID, which is set as an auto-increment integer to uniquely identify each player.', 'The chapter explains the process of creating a table for a cricket team in a college, highlighting the use of primary keys and data types.', 'Three students are identified as part of both the cricket and football teams.']}, {'end': 1185.223, 'segs': [{'end': 873.856, 'src': 'heatmap', 'start': 719.856, 'weight': 0.723, 'content': [{'end': 729.385, 'text': 'So Let me use my select statement to show what are the columns present in the products table.', 'start': 719.856, 'duration': 9.529}, {'end': 737.248, 'text': 'Okay So this product table has information about different product names.', 'start': 731.846, 'duration': 5.402}, {'end': 738.808, 'text': 'You have the product code.', 'start': 737.508, 'duration': 1.3}, {'end': 740.629, 'text': 'Now this product code is unique here.', 'start': 738.908, 'duration': 1.721}, {'end': 747.391, 'text': 'We also have the product vendor, a little description about the product.', 'start': 742.21, 'duration': 5.181}, {'end': 751.333, 'text': 'Then we have the quantity in stock, buying price and MSRP.', 'start': 747.692, 'duration': 3.641}, {'end': 762.589, 'text': "let's see what we have in product lines.", 'start': 753.243, 'duration': 9.346}, {'end': 768.593, 'text': 'if I run it, you see here we have the product line, which is the primary key for this table.', 'start': 762.589, 'duration': 6.004}, {'end': 772.876, 'text': 'then we have the textual description for each of the products.', 'start': 768.593, 'duration': 4.283}, {'end': 777.058, 'text': 'this is basically some sort of an advertisement.', 'start': 772.876, 'duration': 4.182}, {'end': 778.079, 'text': 'all right.', 'start': 777.058, 'duration': 1.021}, {'end': 785.408, 'text': 'now, suppose you want to find the product code, the product name and the text description for each of the products.', 'start': 778.079, 'duration': 7.329}, {'end': 788.692, 'text': 'you can join the products and product lines table.', 'start': 785.408, 'duration': 3.284}, {'end': 790.514, 'text': 'so let me show you how to do it.', 'start': 788.692, 'duration': 1.822}, {'end': 797.871, 'text': "i'll write my select statement and choose my columns as product code.", 'start': 790.514, 'duration': 7.357}, {'end': 805.276, 'text': "then we have product name and let's say I want the text description.", 'start': 797.871, 'duration': 7.405}, {'end': 808.718, 'text': "so I'll write this column name.", 'start': 805.276, 'duration': 3.442}, {'end': 820.485, 'text': "okay, then I'll use from my first table, that is, products inner join product lines.", 'start': 808.718, 'duration': 11.767}, {'end': 834.325, 'text': 'I can use using the common key column, that is, product line.', 'start': 829.221, 'duration': 5.104}, {'end': 840.21, 'text': 'Close the bracket.', 'start': 839.389, 'duration': 0.821}, {'end': 841.291, 'text': "I'll give a semicolon.", 'start': 840.29, 'duration': 1.001}, {'end': 843.893, 'text': 'And if I run it, there you go.', 'start': 842.051, 'duration': 1.842}, {'end': 846.615, 'text': 'So you can see the different product codes.', 'start': 844.493, 'duration': 2.122}, {'end': 851.699, 'text': 'Then we have the different product names and the textual description for each of the products.', 'start': 847.336, 'duration': 4.363}, {'end': 856.523, 'text': 'So this we did by joining the products table and the product lines table.', 'start': 852.52, 'duration': 4.003}, {'end': 857.924, 'text': 'All right.', 'start': 857.624, 'duration': 0.3}, {'end': 867.952, 'text': 'now, suppose you want to find the revenue generated from each product order and the status of the product.', 'start': 860.848, 'duration': 7.104}, {'end': 873.856, 'text': 'to do this task, we need to join three tables, that is, orders, order details and products.', 'start': 867.952, 'duration': 5.904}], 'summary': 'The transcript demonstrates using sql to join tables and retrieve specific columns, including unique product codes and textual descriptions.', 'duration': 154, 'max_score': 719.856, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA719856.jpg'}, {'end': 762.589, 'src': 'embed', 'start': 731.846, 'weight': 2, 'content': [{'end': 737.248, 'text': 'Okay So this product table has information about different product names.', 'start': 731.846, 'duration': 5.402}, {'end': 738.808, 'text': 'You have the product code.', 'start': 737.508, 'duration': 1.3}, {'end': 740.629, 'text': 'Now this product code is unique here.', 'start': 738.908, 'duration': 1.721}, {'end': 747.391, 'text': 'We also have the product vendor, a little description about the product.', 'start': 742.21, 'duration': 5.181}, {'end': 751.333, 'text': 'Then we have the quantity in stock, buying price and MSRP.', 'start': 747.692, 'duration': 3.641}, {'end': 762.589, 'text': "let's see what we have in product lines.", 'start': 753.243, 'duration': 9.346}], 'summary': 'Product table with unique product codes, vendor, descriptions, quantity in stock, buying price, and msrp.', 'duration': 30.743, 'max_score': 731.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA731846.jpg'}, {'end': 1156.586, 'src': 'heatmap', 'start': 1103.516, 'weight': 0, 'content': [{'end': 1107.781, 'text': "it says classic models dot product doesn't exist.", 'start': 1103.516, 'duration': 4.265}, {'end': 1110.564, 'text': 'so again, the product name is.', 'start': 1107.781, 'duration': 2.783}, {'end': 1113.146, 'text': 'i mean the table name is products and not product.', 'start': 1110.564, 'duration': 2.582}, {'end': 1114.808, 'text': "so let's run it again.", 'start': 1113.146, 'duration': 1.662}, {'end': 1116.29, 'text': 'all right, there you go.', 'start': 1114.808, 'duration': 1.482}, {'end': 1120.995, 'text': 'so we have the order number, the status, the product name and the revenue.', 'start': 1116.29, 'duration': 4.705}, {'end': 1126.914, 'text': 'This we got it using inner join from three different tables.', 'start': 1122.788, 'duration': 4.126}, {'end': 1133.984, 'text': 'If getting your learning started is half the battle, what if you could do that for free? Visit SkillUp by SimplyLearn.', 'start': 1127.635, 'duration': 6.349}, {'end': 1136.607, 'text': 'Click on the link in the description to know more.', 'start': 1134.324, 'duration': 2.283}, {'end': 1139.652, 'text': 'Now talking about left joins.', 'start': 1138.029, 'duration': 1.623}, {'end': 1147.259, 'text': 'SQL left join statement returns all the rows from the left table and the matching rows from the right table.', 'start': 1141.335, 'duration': 5.924}, {'end': 1155.705, 'text': 'so if you see this diagram, you can see we have all the rows from the left table, that is A, and only the matching rows from the right table,', 'start': 1147.259, 'duration': 8.446}, {'end': 1156.586, 'text': 'that is B.', 'start': 1155.705, 'duration': 0.881}], 'summary': 'Demonstrates sql inner join from three tables and explains left join concept. visit skillup by simplylearn for free learning.', 'duration': 46.022, 'max_score': 1103.516, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1103516.jpg'}], 'start': 695.629, 'title': 'Joining and using joins in sql', 'summary': 'Demonstrates how to join tables in sql to retrieve specific columns and information, including product details and revenue, by utilizing select statements and inner join, and covers using sql inner join to join three different tables to find the order number, status, product name, and revenue, and discusses the concept of sql left join returning all rows from the left table and matching rows from the right table.', 'chapters': [{'end': 888.484, 'start': 695.629, 'title': 'Joining tables in sql', 'summary': 'Demonstrates how to join tables in sql to retrieve specific columns and information, including product details and revenue, by utilizing select statements and inner join, and also mentions the number of tables involved in these operations.', 'duration': 192.855, 'highlights': ['The chapter demonstrates how to join tables in SQL to retrieve specific columns and information, including product details and revenue, by utilizing select statements and inner join.', 'The product table contains information such as product names, unique product codes, product vendors, descriptions, quantity in stock, buying price, and MSRP.', 'The product lines table contains the primary key, product line, and textual descriptions for each product, serving as a form of advertisement.', 'The process of joining tables in SQL is illustrated by an example of joining the products and product lines table to retrieve the product code, product name, and text description for each product.', 'It is mentioned that to find the revenue generated from each product order and the status of the product, three tables need to be joined, namely orders, order details, and products.']}, {'end': 1185.223, 'start': 888.504, 'title': 'Sql inner join and left join', 'summary': 'Covers the process of using sql inner join to join three different tables to find the order number, status, product name, and revenue, and also discusses the concept of sql left join returning all rows from the left table and matching rows from the right table.', 'duration': 296.719, 'highlights': ['Using SQL inner join to join three different tables to find the order number, status, product name, and revenue.', 'Explaining the process of using SQL left join to return all rows from the left table and matching rows from the right table.', 'Mentioning the syntax for SQL left join and its functionality.']}], 'duration': 489.594, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA695629.jpg', 'highlights': ['The chapter demonstrates how to join tables in SQL to retrieve specific columns and information, including product details and revenue, by utilizing select statements and inner join.', 'Using SQL inner join to join three different tables to find the order number, status, product name, and revenue.', 'The product table contains information such as product names, unique product codes, product vendors, descriptions, quantity in stock, buying price, and MSRP.', 'Explaining the process of using SQL left join to return all rows from the left table and matching rows from the right table.']}, {'end': 1402.994, 'segs': [{'end': 1213.124, 'src': 'embed', 'start': 1185.223, 'weight': 3, 'content': [{'end': 1190.987, 'text': 'okay, now, in our classic models database we have two tables customers and orders.', 'start': 1185.223, 'duration': 5.764}, {'end': 1196.571, 'text': 'so if you want to find the customer name and their order id, you can use these two tables.', 'start': 1190.987, 'duration': 5.584}, {'end': 1201.974, 'text': 'so first let me show you the columns that are present in customers and orders.', 'start': 1196.571, 'duration': 5.403}, {'end': 1204.977, 'text': 'I think orders we have already seen.', 'start': 1203.095, 'duration': 1.882}, {'end': 1209.121, 'text': "let me first show you what's there in the customers table.", 'start': 1204.977, 'duration': 4.144}, {'end': 1213.124, 'text': 'okay, so you can see we have the customer number, the name of the customer.', 'start': 1209.121, 'duration': 4.003}], 'summary': 'Classic models database has two tables: customers and orders, with customer number and name.', 'duration': 27.901, 'max_score': 1185.223, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1185223.jpg'}, {'end': 1270.442, 'src': 'embed', 'start': 1237.138, 'weight': 1, 'content': [{'end': 1238.819, 'text': "so i'll write select star from orders.", 'start': 1237.138, 'duration': 1.681}, {'end': 1245.923, 'text': 'if i run this, you can see these are the information available in the orders table.', 'start': 1238.819, 'duration': 7.104}, {'end': 1253.907, 'text': "okay, so let's perform a left join where we want to find the customer name and their order ids.", 'start': 1245.923, 'duration': 7.984}, {'end': 1260.099, 'text': "so i'll write select c dot customer name.", 'start': 1253.907, 'duration': 6.192}, {'end': 1264.54, 'text': "or let's say first we'll choose the customer number comma.", 'start': 1260.099, 'duration': 4.441}, {'end': 1266.481, 'text': 'then i want the customer name.', 'start': 1264.54, 'duration': 1.941}, {'end': 1270.442, 'text': "so i'll write c dot customer name.", 'start': 1266.481, 'duration': 3.961}], 'summary': 'Sql query retrieves customer names and order ids from orders table.', 'duration': 33.304, 'max_score': 1237.138, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1237138.jpg'}, {'end': 1402.994, 'src': 'embed', 'start': 1344.467, 'weight': 0, 'content': [{'end': 1353.713, 'text': 'this means for customer number 125 and for this particular customer name there were no orders and similarly, if i scroll down,', 'start': 1344.467, 'duration': 9.246}, {'end': 1356.435, 'text': 'you will find a few more null values.', 'start': 1353.713, 'duration': 2.722}, {'end': 1361.578, 'text': 'you can see here there are two null values here for customer number 168 and 169 there were no orders available.', 'start': 1356.435, 'duration': 5.143}, {'end': 1366.635, 'text': 'all right.', 'start': 1365.635, 'duration': 1}, {'end': 1373.658, 'text': "now, to check those customers who haven't placed any orders, you can use the null operator.", 'start': 1366.635, 'duration': 7.023}, {'end': 1375.699, 'text': "so what i'll do is here.", 'start': 1373.658, 'duration': 2.041}, {'end': 1377.28, 'text': "i'll just continue with this.", 'start': 1375.699, 'duration': 1.581}, {'end': 1387.204, 'text': "i'll use a where clause and write where order number is null.", 'start': 1377.28, 'duration': 9.924}, {'end': 1389.365, 'text': 'now let me run this.', 'start': 1387.204, 'duration': 2.161}, {'end': 1399.693, 'text': "okay. so here you can see there are 24 customers from the table that don't have any orders in their names.", 'start': 1389.365, 'duration': 10.328}, {'end': 1402.994, 'text': 'okay, now talking about right joins.', 'start': 1399.693, 'duration': 3.301}], 'summary': '24 out of 125 customers have no orders in their names.', 'duration': 58.527, 'max_score': 1344.467, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1344467.jpg'}], 'start': 1185.223, 'title': 'Sql left join example', 'summary': 'Explains how to find customer names and order ids using the customers and orders tables, and covers an example of performing a left join in sql, encountering errors during the process, and analyzing customer orders data to identify customers with no orders, with 24 customers found to have no orders.', 'chapters': [{'end': 1237.138, 'start': 1185.223, 'title': 'Database tables customers and orders', 'summary': "Explains how to find customer names and order ids by using the customers and orders tables, detailing the columns present in each table and mentioning the sql query 'select start from orders'.", 'duration': 51.915, 'highlights': ['The tables customers and orders are used to find customer names and order IDs.', 'The customers table contains columns such as customer number, name, contact last name, contact first name, phone number, and address details.', "The orders table is accessed using the SQL query 'select start from orders'."]}, {'end': 1319.751, 'start': 1237.138, 'title': 'Sql left join example', 'summary': "Covers an example of performing a left join in sql to find customer names and their order ids, using the 'customers' and 'orders' tables, and encountering errors during the process.", 'duration': 82.613, 'highlights': ['Performing a left join to find customer names and their order IDs.', "Selecting data from the 'customers' and 'orders' tables.", 'Encountering errors during the execution of the SQL left join query.']}, {'end': 1402.994, 'start': 1319.751, 'title': 'Customer orders analysis', 'summary': 'Discusses analyzing customer orders data, identifying customers with no orders, and using a right join, with 24 customers found to have no orders.', 'duration': 83.243, 'highlights': ['Using a where clause with the null operator, 24 customers from the table were found to have no orders in their names.', 'The transcript discusses the presence of null values in the order number column, indicating customers with no orders, such as customer number 125 and 169.']}], 'duration': 217.771, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1185223.jpg', 'highlights': ['Using a where clause with the null operator, 24 customers from the table were found to have no orders in their names.', 'Performing a left join to find customer names and their order IDs.', 'The transcript discusses the presence of null values in the order number column, indicating customers with no orders, such as customer number 125 and 169.', 'The tables customers and orders are used to find customer names and order IDs.']}, {'end': 1900.383, 'segs': [{'end': 1636.245, 'src': 'embed', 'start': 1607.759, 'weight': 0, 'content': [{'end': 1615.321, 'text': 'so you can see, here we have all the values selected from our right table, which is the employees table.', 'start': 1607.759, 'duration': 7.562}, {'end': 1620.042, 'text': 'you can see right zone, employees, which means your employees table is to the right.', 'start': 1615.321, 'duration': 4.721}, {'end': 1628.723, 'text': 'and then we have the customer name and phone numbers of the customers from the customer table, which is actually your left table.', 'start': 1620.042, 'duration': 8.681}, {'end': 1636.245, 'text': "so you have a few employee numbers such as 1002, there's 1056, which don't have any customer name or phone numbers.", 'start': 1628.723, 'duration': 7.522}], 'summary': 'Displaying employee and customer data from tables, some employees lack customer details.', 'duration': 28.486, 'max_score': 1607.759, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1607759.jpg'}, {'end': 1763.44, 'src': 'embed', 'start': 1731.536, 'weight': 1, 'content': [{'end': 1736.373, 'text': 'Alright Now, suppose you want to know who is the reporting manager for each employee.', 'start': 1731.536, 'duration': 4.837}, {'end': 1738.774, 'text': 'So for that you can use a self-join.', 'start': 1736.773, 'duration': 2.001}, {'end': 1741.976, 'text': 'So let me show you how to join this employees table.', 'start': 1739.495, 'duration': 2.481}, {'end': 1750.141, 'text': "I'll write select, and then I'm going to use a function called concat within brackets.", 'start': 1742.797, 'duration': 7.344}, {'end': 1751.902, 'text': "I'll start with my alias name.", 'start': 1750.221, 'duration': 1.681}, {'end': 1753.002, 'text': 'That is m dot.', 'start': 1751.922, 'duration': 1.08}, {'end': 1755.924, 'text': "Then I'll write last name.", 'start': 1753.943, 'duration': 1.981}, {'end': 1763.44, 'text': 'going to concat last name followed by a comma.', 'start': 1758.115, 'duration': 5.325}], 'summary': 'Use a self-join to find reporting manager for each employee using concat function.', 'duration': 31.904, 'max_score': 1731.536, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1731536.jpg'}], 'start': 1402.994, 'title': 'Sql right joins and self joins', 'summary': 'Explains the usage of sql right joins to retrieve all rows from the right table and matching rows from the left table, demonstrated by selecting customer and employee data, and also discusses the concept of self joins using a detailed example.', 'chapters': [{'end': 1900.383, 'start': 1402.994, 'title': 'Sql right joins and self joins', 'summary': 'Explains the usage of sql right joins to retrieve all rows from the right table and matching rows from the left table, demonstrated by selecting customer and employee data, and also discusses the concept of self joins using a detailed example.', 'duration': 497.389, 'highlights': ['The right join returns all the rows from the right table and only matching rows from the left table, demonstrated using customer and employee data. The right join operation is explained, illustrating the retrieval of all rows from the right table and only matching rows from the left table, showcased through the selection of customer and employee data.', 'Demonstration of using a self-join to find reporting managers for each employee using the employees table. The concept of a self-join is explained, showcasing its usage to find reporting managers for each employee using the employees table.', 'Usage of concat function to display manager and employee details in the self-join example. The usage of the concat function to display manager and employee details in the self-join example is demonstrated, providing a comprehensive understanding of the process.']}], 'duration': 497.389, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1402994.jpg', 'highlights': ['The right join returns all the rows from the right table and only matching rows from the left table, demonstrated using customer and employee data.', 'Demonstration of using a self-join to find reporting managers for each employee using the employees table.', 'Usage of concat function to display manager and employee details in the self-join example.']}, {'end': 2120.183, 'segs': [{'end': 1988.812, 'src': 'embed', 'start': 1902.145, 'weight': 0, 'content': [{'end': 1911.351, 'text': "now let's see what a full join is so SQL full outer join statement returns all the rows when there is a match in either left or right table.", 'start': 1902.145, 'duration': 9.206}, {'end': 1917.855, 'text': "now you must remember that MySQL workbench does not support full outer join by default, but there's a way to do it.", 'start': 1911.351, 'duration': 6.504}, {'end': 1922.778, 'text': 'so by default, this is how the syntax of full outer join looks like.', 'start': 1917.855, 'duration': 4.923}, {'end': 1930.504, 'text': "Now this statement will work on other SQL databases, like Microsoft SQL Server, but it won't work on MySQL Workbench.", 'start': 1923.897, 'duration': 6.607}, {'end': 1935.289, 'text': "I'll show you the right way of using full auto join on MySQL Workbench.", 'start': 1931.024, 'duration': 4.265}, {'end': 1943.493, 'text': "So to show full outer join, I'm going to first use a left join, and then we'll also use a right join.", 'start': 1937.032, 'duration': 6.461}, {'end': 1946.194, 'text': "And finally, we'll use a union operator.", 'start': 1943.553, 'duration': 2.641}, {'end': 1950.815, 'text': 'So the union operator is used to combine the result set of two or more select statements.', 'start': 1946.674, 'duration': 4.141}, {'end': 1957.496, 'text': 'So first of all, let me write C dot customer name.', 'start': 1951.775, 'duration': 5.721}, {'end': 1966.518, 'text': "So for this example, I'm using the customer table and the order table, comma, O dot order number.", 'start': 1958.056, 'duration': 8.462}, {'end': 1974.781, 'text': 'so I just want to know the customer name and the order number related to the customer from.', 'start': 1967.315, 'duration': 7.466}, {'end': 1988.812, 'text': 'I have customers as C left join.', 'start': 1974.781, 'duration': 14.031}], 'summary': 'Sql full outer join returns all rows with match in either table, supported in mysql workbench via left join and right join, with a union operator for combining result sets.', 'duration': 86.667, 'max_score': 1902.145, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1902145.jpg'}, {'end': 2092.828, 'src': 'heatmap', 'start': 2012.29, 'weight': 3, 'content': [{'end': 2019.197, 'text': 'So union operator is used to merge results from two or more tables.', 'start': 2012.29, 'duration': 6.907}, {'end': 2023.541, 'text': 'So basically, this performs a vertical join.', 'start': 2021.158, 'duration': 2.383}, {'end': 2027.245, 'text': 'And next, I am going to use my right join operation.', 'start': 2024.662, 'duration': 2.583}, {'end': 2030.81, 'text': "So here, instead of left join, I'll write right.", 'start': 2027.906, 'duration': 2.904}, {'end': 2034.694, 'text': 'Rest all looks fine.', 'start': 2033.693, 'duration': 1.001}, {'end': 2036.677, 'text': 'Let me just run it.', 'start': 2035.495, 'duration': 1.182}, {'end': 2039.676, 'text': 'there you go.', 'start': 2038.635, 'duration': 1.041}, {'end': 2044.941, 'text': 'so we have successfully run our full outer join operation.', 'start': 2039.676, 'duration': 5.265}, {'end': 2053.73, 'text': 'you can see we have the different customer names and the order that each customer had placed all right.', 'start': 2044.941, 'duration': 8.789}, {'end': 2056.293, 'text': 'so that brings us to the end of our demo session.', 'start': 2053.73, 'duration': 2.563}, {'end': 2060.838, 'text': 'so let me just run through whatever we did in this session.', 'start': 2056.953, 'duration': 3.885}, {'end': 2065.244, 'text': 'so first we created a database called sql joins.', 'start': 2060.838, 'duration': 4.406}, {'end': 2069.208, 'text': 'then we created two tables like cricket and football.', 'start': 2065.244, 'duration': 3.964}, {'end': 2075.255, 'text': 'then we had inserted a few rows to each of these tables.', 'start': 2069.208, 'duration': 6.047}, {'end': 2079.217, 'text': 'then we used this table to learn about inner join.', 'start': 2075.255, 'duration': 3.962}, {'end': 2083.462, 'text': 'next we used a database called classic models.', 'start': 2079.217, 'duration': 4.245}, {'end': 2084.581, 'text': 'it had multiple tables.', 'start': 2083.462, 'duration': 1.119}, {'end': 2092.828, 'text': 'so we explored all of these tables like products there was product lines, orders, customers and employees and learnt how to use inner join, left join,', 'start': 2084.581, 'duration': 8.247}], 'summary': 'Demonstrated various sql join operations using tables from different databases.', 'duration': 59.135, 'max_score': 2012.29, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA2012290.jpg'}], 'start': 1902.145, 'title': 'Sql joins operations', 'summary': 'Explains the usage of union, left join, right join, and full outer join operations in sql, utilizing the customer and order tables to demonstrate how to merge results from multiple tables and explore various join types in sql.', 'chapters': [{'end': 1946.194, 'start': 1902.145, 'title': 'Understanding full outer join in sql', 'summary': 'Explains the concept of a full outer join in sql, where it returns all rows with a match in either left or right table, and highlights how mysql workbench does not support it by default, but provides an alternative method to achieve it using left join, right join, and the union operator.', 'duration': 44.049, 'highlights': ['The SQL full outer join statement returns all the rows when there is a match in either left or right table.', "MySQL Workbench does not support full outer join by default, but there's a way to do it.", 'The explanation includes using left join, right join, and the union operator to achieve the full outer join in MySQL Workbench.']}, {'end': 2120.183, 'start': 1946.674, 'title': 'Sql joins operations', 'summary': 'Explains the usage of union, left join, right join, and full outer join operations in sql, utilizing the customer and order tables to demonstrate how to merge results from multiple tables and explore various join types in sql.', 'duration': 173.509, 'highlights': ['The union operator is used to merge results from two or more select statements, performing a vertical join.', 'Demonstrated the left join, right join, and full outer join operations to combine data from the customer and order tables.', 'Explored various join types such as inner join, left join, self join, right join, and full outer join in the context of multiple tables from the classic models database.']}], 'duration': 218.038, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/vncBSUNb4NA/pics/vncBSUNb4NA1902145.jpg', 'highlights': ['The SQL full outer join statement returns all the rows when there is a match in either left or right table.', 'The explanation includes using left join, right join, and the union operator to achieve the full outer join in MySQL Workbench.', 'The union operator is used to merge results from two or more select statements, performing a vertical join.', 'Explored various join types such as inner join, left join, self join, right join, and full outer join in the context of multiple tables from the classic models database.', "MySQL Workbench does not support full outer join by default, but there's a way to do it.", 'Demonstrated the left join, right join, and full outer join operations to combine data from the customer and order tables.']}], 'highlights': ['The SQL JOIN statement is crucial for fetching data from multiple tables, and it is used to combine rows of data based on a common field or column, as demonstrated with the orders and customers tables.', 'The example of joining the orders and customers tables with unique order IDs is used to illustrate the function of Joins in combining data from different tables.', 'The tutorial provides hands-on demonstrations on MySQL Workbench to help understand the basics of Joins and the different types of Joins.', 'The importance of Joins in dealing with data present on multiple tables is emphasized, highlighting their significance in SQL.', 'The chapter explains examples of joining tables to retrieve specific information, emphasizing the practical application of SQL joins.', 'It discusses the different types of joins, with a focus on the inner join, providing a clear understanding of how SQL joins work and their relevance in data retrieval.', 'The chapter explains the concept of inner joins in SQL, demonstrating the syntax and practical application in MySQL Workbench.', 'The transcript provides detailed information about the structure of the orders and customers tables, enhancing the understanding of the data being used for SQL joins.', 'The chapter demonstrates the process of using inner joins in SQL to find students who are part of both the cricket and football teams.', 'The primary key for the cricket table is the cricket ID, which is set as an auto-increment integer to uniquely identify each player.', 'The chapter explains the process of creating a table for a cricket team in a college, highlighting the use of primary keys and data types.', 'The chapter demonstrates how to join tables in SQL to retrieve specific columns and information, including product details and revenue, by utilizing select statements and inner join.', 'Using SQL inner join to join three different tables to find the order number, status, product name, and revenue.', 'The product table contains information such as product names, unique product codes, product vendors, descriptions, quantity in stock, buying price, and MSRP.', 'Explaining the process of using SQL left join to return all rows from the left table and matching rows from the right table.', 'Using a where clause with the null operator, 24 customers from the table were found to have no orders in their names.', 'Performing a left join to find customer names and their order IDs.', 'The transcript discusses the presence of null values in the order number column, indicating customers with no orders, such as customer number 125 and 169.', 'The tables customers and orders are used to find customer names and order IDs.', 'The right join returns all the rows from the right table and only matching rows from the left table, demonstrated using customer and employee data.', 'Demonstration of using a self-join to find reporting managers for each employee using the employees table.', 'Usage of concat function to display manager and employee details in the self-join example.', 'The SQL full outer join statement returns all the rows when there is a match in either left or right table.', 'The explanation includes using left join, right join, and the union operator to achieve the full outer join in MySQL Workbench.', 'The union operator is used to merge results from two or more select statements, performing a vertical join.', 'Explored various join types such as inner join, left join, self join, right join, and full outer join in the context of multiple tables from the classic models database.', "MySQL Workbench does not support full outer join by default, but there's a way to do it.", 'Demonstrated the left join, right join, and full outer join operations to combine data from the customer and order tables.']}