In the first mission of this SQL Intermediate course, you'll focus on how to join data in SQL, and unlocking the true power of SQL. Often times when you're working with SQL, the data you'd like to be working with is spread out across multiple tables.
You'll learn about the four basic types of joins: the inner join, the outer join, the left join, and the right join. Each join covered in this mission serves a specific purpose, and knowing about the different types of joins increases what you can do with SQL ten-fold. Not only will you learn about the joins, you will learn what makes them different from each other both syntacticly and conceptually. In addition, you will have practice using each type of join so that you can feel confident in your SQL ability so you can be on your way to becoming proficient in writing queries to solve any problem or answer any question.
To facilitate your learning of the different types of joins, you'll be working with a version of the CIA World Factbook data and using that to find the capital cities that are the most populated.
1. Introducing Joins
2. Understanding Inner Joins
3. Practicing Inner Joins
4. Left Joins
5. Right Joins and Outer Joins
6. Finding the Most Populous Capital Cities
7. Combining Joins with Subqueries
8. Challenge: Complex Query with Joins and Subqueries
9. Next Steps