Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

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!

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
  • Bundle deals
  • Table of contents
  • Reviews
Start for free
Gift this course

Bundle deals

86%
off

Reg. price
$1442

One to Rule 'Em All

Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

Bundle price $199

36 hours left at this price!

Buy bundle

63%
off

Reg. price
$324

PostgreSQL Complete Track

Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

Bundle price $119

36 hours left at this price!

Buy bundle

Table of contents

Progress: 0% completed 0 of 93 exercises done

1. Recap of SQL JOIN types

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

More details Less
Start now

0% completed 0 of 21 exercises done

2. Multiple JOINs

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

More details Less
Start now

0% completed 0 of 13 exercises done

3. Joining a table with itself

Learn how to join SQL table with itself.

More details Less
Start now

0% completed 0 of 12 exercises done

4. Non-equi JOINs

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

More details Less
Start now

0% completed 0 of 29 exercises done

5. Challenge

Check your knowledge in the challenge.

More details Less
Start now

0% completed 0 of 18 exercises done

Reviews

Average rating

5/5100.0 (1)

Details

5 Stars 100%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
    Load more reviews