MISSION 189

Intermediate Joins in SQL

Learn how to join data from more complex databases and write more complex queries.

Objectives

  • Understand how to write queries that join three or more tables.
  • Learn to use recursive joins, pattern matching, and the case statement.
  • Practice writing advanced joins.

Mission Outline

1. Working With Larger Databases
2. Joining Three Tables
3. Joining More Than Three Tables
4. Combining Multiple Joins with Subqueries
5. Recursive Joins
6. Pattern Matching Using Like
7. Generating Columns With The Case Statement
8. Next Steps
9. Takeaways

sql-joins-relations

Course Info:

SQL Intermediate: Table Relations and Joins

Intermediate

The median completion time for this course is 6.8 hours.

This course requires a basic subscription and has four 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