Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.



PostgreSQL JOINs

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.

Table of contents

10 free interactive coding challenges

Lifetime access


limited to this course only


Buy now

Want a better deal?


Get unlimited lifetime access to all 66 present and future courses

Save $450

Unlimited lifetime access


to all 66 present and future courses



75% OFF

Buy now

Interactive exercises

9 h

Estimated time


Users enrolled


2103 ratings

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.

Cover image for the course 'PostgreSQL JOINs'

Are you someone who already knows how to write simple queries and wants to learn more? Then this online course is for you!

What's in it for Me?

  • 93 interactive exercises. Learn at your own pace, from any location and at any time. Work through hands-on exercises to help you retain what you have learned so far.
  • Lifetime access to the course. When you purchase the online course, you'll get instant personal access to all of its content forever.
  • Online certificate. After you successfully finish all of the exercises in the online course, you'll receive a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you're not satisfied with the quality of the online course, you can get a refund within 30 days of your purchase.
  • Exercise hints. You can take advantage of ready-made hints for every exercise, or ask questions and share insights with other members of our community through the Discuss tab.

What Are the Requirements?

  • Just a web browser and an Internet connection
  • A basic understanding of PostgreSQL JOIN

Learn How to:

  • JOIN and SELECT data from two or more data tables.
  • JOIN many tables in a single query.
  • JOIN a given table with itself.
  • JOIN tables on non-key columns.
  • Quickly determine which type of JOIN you should use to correctly filter your data: LEFT JOIN, RIGHT JOIN, INNER JOIN or FULL JOIN.
You'll also delve into the interesting topic of SQL's non-equi JOIN.

Who Should Take This Course?

  • Students enrolled in courses involving relational databases
  • Beginner programmers interested in PostgreSQL
  • Analysts who use relational databases
  • Business database users who want to improve their querying skills
  • Anyone who wants to improve or refresh their knowledge of PostgreSQL JOIN

Table of contents


Paid content


Course progress


Exercises completed


Recap of SQL JOIN types

Review the most common types of JOINs. Practice JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and others.


Simple JOINs recap

Various kinds of JOINs

Filtering with LEFT JOIN and RIGHT JOIN



Multiple JOINs

Refine your joining skills. Exercise joining more than two tables in one SQL query.


Healthy Shop database

MULTIPLE JOINs – Exercises


Joining a table with itself

Learn how to join SQL table with itself.



Dictionary database



Non-equi JOINs

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 JOINs

Non-equi self JOINs




Check your knowledge in the challenge.


Challenge time

Reviews (21)

Average rating



2103 ratings


5 stars


4 stars


3 stars


2 stars


1 stars