Consolidate your knowledge of operating on two or more data tables in PostgreSQL database. This online practice set consists of 93 interactive exercises and will help you polish your SQL joining skills.
This online practice set is designed for users who already know the basics of PostgreSQL queries. It will be of interest to anyone who wants to polish or refresh their knowledge of JOIN clauses. Keep reading for more details.
PostgreSQL JOIN is one of the most commonly used clauses in relational databases. If you want to successfully process the data stored in multiple tables, learning PostgreSQL JOIN is a must. With this online practice set, you will learn all PostgreSQL JOIN types: LEFT JOIN, RIGHT JOIN, INNER JOIN, and FULL JOIN. You'll also get the hang of non-equi JOIN.
Are you someone who already knows how to write simple queries and wants to learn more? Then this online course is for you!
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.