Duration: 19:49 min
Summary: In this video, we will discuss selecting data from more than one table. We will join additional tables to our query. To start, we will create a test database with couple of tables: Course and Student. We will add few columns to each table. We will also add few records using the UI. Once we are done with that, we will answer the question of finding all the students who are taking courses. We will also see how to find the students who are not enrolled in addition to the courses that do not have students. All of this is done using join, left join and right join. We will also explore all the combinations of students and courses.