In the second lesson of this SQL Intermediate course, you'll focus on how to join data in SQL using more than one table, 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. You will learn concepts such as how to use recursive joins, how to perform pattern matching using LIKE and ILIKE for advanced filtering, and the case statement, which is the clause to perform the same function such as if and else in Python. In addition, you will have practice using each of these concepts along with writing advanced joins 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 joining multiple tables, you'll be working with a version of the Chinook database, a music collection involving track name, album name, artist name, genre, and number of tracks purchased.
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