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

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