Joins - Illustration

Shaans Training
A free video tutorial from Shaans Training
SDET Project & Job Trainings
4.1 instructor rating • 2 courses • 15,649 students

Learn more from the full course

SDET Training: Selenium WebDriver, Java Project & Code Tests

Complete SDET Training course on Selenium WebDriver with Java Framework, API & Automation Testing, Coding Interview etc

15:42:38 of on-demand video • Updated December 2019

  • Understanding the Realtime Test environments and Agile Implementation
  • Master the Core Java concepts and Datastructures needed to get you hired
  • Functional Testing: UI and API(Web service) Testing using Selenium WebDriver, RestAssured etc
  • Non-functional testing: Cross-browser & Performance testing using SauceLabs, Blazemeter, New Relic APM
  • Integrate Docker + Selenium Grid + Jenkins and run the tests. Jenkins plugins and more
  • Learn Amazon Web Services/ AWS : IAM, EC2 instances, S3 storage, Code deploy that you need as SDET
  • Build and Release Management using Maven and GIT
  • Apply for following roles: SDET / Automation Engineer / Performance Engineer
English [Auto] In this video we'll have a quick illustration on the sequel Joines sequel rescue and Joines and one of the most popular subject in the interviews and in almost all developer and test engineer interviews there will often be asked the questions can be based on popolo they will Slyke employee and our department table or customer and Orders table. For example you will have a given employee and a department table and will be asked a question like. Find the Magsman employee salary within each department. Another example based on customer and orders table is hard to find the number of orders by each customer in a given month. There are a couple of examples in a way but let's start looking at the illustration we how Here we go. Two tables. Table A and Table B table has a column with values 10 20 and 40 while Table B has a column that has values 10 20 and 30. Notice that 10 and 20 of the matching records are numbers between the two tables and table he has 40 that's not there in Table be white table B has 30. That's modern table. We will be learning the Giants using Venn diagrams here. The easiest way to understand the sequel to is visually Joines can be primarily categorized into two types. Inner join and outer join or to join again has three subtypes which are leftover. Don't write up or join an Floatpoint or you can just call them left join right join and full join will begin with. Enoggera and when I get them first the left circle here is table and the right circle. Here it will be 10 and 20 are shown in this overlapping region between the two tables because both the tables how these two matching records 10 and 20. If you see the table Sebo here both table and table B. How are 10 and 20 in common but 40 is present only in table. While Turkey is present only in Table B so 40 and 30 are the non matching records between table and table B in non-German always returns the matching records between the join tables as strike. Note with these blue lines here the matching records between the two tables are 10 and 20. So the output for the inner join would be just 10 and 20. That whole board left join left join returns the matching records between the tables that are joined Plus the non-matching records as one from the left table. So it returns the matching record 10 and 20 plus the non-matching record 40 as well from the left table which is stable here. So the output will be again 10 20 and 40 hardboard join. It's almost similar to left join right join. Returns the matching record between the join tables plus the non-matching records as well from the right table. So it triggers the matching records 10 and 20 plus the non-matching record 30 as well from the right table which is stable B. So basically we get 10 20 and 30 as the output. Finally let's take a look at full join. It's pretty straightforward. It returns everything from the join tables which means it returns the matching record between the tables and the non-matching records as well from the left and right they will. So basically we get 10 20 30 and 40 as part of the output. That's a quick overview on the sequel joins. So based on the given question you need to come up with appropriate join. Inner join are appropriate or the join but also remember out of the join in the tables using one of these joins. Sometimes you may need to use some sequel functions also like max min summits or draw and use GROUP BY class to group the results. Also sometimes you may need to use their conditions as well to filter the results based on the question. So anyway we will look into those specific details are coming really close. But as part of the session what we wanted to know is what are two types of joints that are not a join and what are the three supply of oxygen and what kind of output we get when we join the tables using these joints. That should be good for now. See the next one.