It's Autumn! Prices fall like leaves! - 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 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
    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    Includes 41 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, Introduction to R, Tidyverse, Data Visualization 101, 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, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, 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

    Bundle price $199

    37 hours left at this price!

    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

      Comments

      0