Basic Course

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.

4.74 ★★★★★ ★★★★★ (2104 ratings)

14,065 learners enrolled

Lifetime access

limited to this course only

$19 $39

51% OFF

Buy now

Want a better deal?

Get unlimited lifetime access to all 74 present and future courses

Save $450

Unlimited lifetime access

to all 74 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 9 h

Coding challenges 93

Skills you will gain

  • 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.
  • Delve into the interesting topic of SQL's non-equi JOIN.

Last reviews

Description

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

Course progress 0%

Exercises completed 0/93

  1. Recap of SQL JOIN types

    0/21

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

  2. Multiple JOINs

    0/13

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

  3. Joining a table with itself

    0/12

    Learn how to join SQL table with itself.

  4. Non-equi JOINs

    0/29

    Practice joins with less common conditions: non-equi JOINs and joins between non-key columns.

  5. Challenge

    0/18

    Check your knowledge in the challenge.

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (22)

Average rating

4.74/5

★★★★★ ★★★★★ (2104 ratings)

5 stars

78%

4 stars

22%

3 stars

0%

2 stars

0%

1 stars

0%