Review and deepen your knowledge of SQL JOINs with 93 exercises. Practice common and less common ways of getting data from multiple tables.
JOINs are one of the most fundamental and commonly used features of the SQL language. It's safe to say that at least basic knowledge of querying data from more than one table is an absolute must for every SQL user.
This course covers all important types of SQL JOINs that are widely used by SQL programmers to query databases on a daily basis.
This course is intended for users who have very basic experience with SQL. We assume you know how to write simple queries to select data from a single table.
Just a web browser and an Internet connection.
You'll also delve into the interesting topic of non-equi JOINs.
Review the most common types of JOINs. Practice JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and others.
Simple JOINs recap
Filtering with LEFT JOIN and RIGHT JOIN
Refine your joining skills. Exercise joining more than two tables in one SQL query.
Healthy Shop database
Learn how to join SQL table with itself.
Practice joins with less common conditions: non-equi JOINs and joins between non-key columns.
Medical Center database
Non primary-foreign key JOINs
Non-equi self JOINs
Check your knowledge in the challenge.