MISSION 179

Joining Data in SQL

Learn how to use joins to query data across two or more tables.

Objectives

  • Learn what joins are and how to use the four common join types.
  • Learn how to use joins with subqueries to write intermediate queries.
  • Learn how to use joins to answer business questions.

Mission Outline

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
10. Takeaways

Course Info:

SQL Intermediate: Table Relations and Joins

Intermediate

The average completion time for this course is 10-hours.

This course requires a basic subscription and has six mission including two guided projects. It is the 12th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit