cookies-icon

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.

Basic

Interactive 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.

Table of contents
93

Interactive exercises

9 h

Estimated time

107

Users enrolled

☆☆☆☆☆
★★★★★

3 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.

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 the Vertabelo Academy community through the Discuss tab. You can also drop us a line at academy@vertabelo.com, and we'll be more than happy to answer!

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

Free

Paid content

0%

Course progress

0/93

Exercises completed

Reviews (1)

Average rating

5.00 / 5

☆☆☆☆☆
★★★★★

3 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%