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

JOINs are one of the most fundamental and commonly used features of the SQL language. It's safe to say that at least basic knowledge of querying data from more than one table is an absolute must for every SQL user.

This course covers all important types of SQL JOINs that are widely used by SQL programmers to query databases on a daily basis.

This course is intended for users who have very basic experience with SQL. We assume you know how to write simple queries to select data from a single table.

What Do You Need to Take This Course?

Just a web browser and an Internet connection.

This Course Will Teach You:

  • JOINing and selecting data from more than one table
  • JOINIng many tables in a single query
  • The use cases of LEFT JOIN, RIGHT JOIN, and FULL JOIN
  • How to correctly filter data with different kinds of JOINs
  • How to join a given table with itself
  • How to join tables on non-key columns

You'll also delve into the interesting topic of non-equi JOINs.

Who Should Take This Course?

  • Analysts who use relational databases
  • Students taking courses in relational databases
  • Beginning programmers interested in SQL
  • Business database users who want to improve their querying skills
  • Anyone who wants to improve or practice their knowledge of SQL JOINs
    Start for free
    Gift this course

    Bundle deals

    80%
    off

    Reg. price
    $990

    One to Rule 'Em All

    Includes 30 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Working with Strings in Python, SQL Basics, Standard SQL Functions, SQL Practice Set, Writing User-Defined Functions in PostgreSQL, SQL JOINs, Window Functions, Recursive Queries, How to INSERT, UPDATE, and DELETE Data in SQL, Creating Tables in SQL, PostGIS, 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, 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, How to Read and Write JSON Files in Python, Introduction to Python for Data Science, Lists and Functions in R

    Bundle price $189

    37 hours left at this price!

    71%
    off

    Reg. price
    $330

    SQL Complete Track

    Includes 9 courses SQL Basics, Standard SQL Functions, SQL Practice Set, SQL JOINs, Window Functions, Recursive Queries, How to INSERT, UPDATE, and DELETE Data in SQL, Creating Tables in SQL, PostGIS

    Bundle price $95

    37 hours left at this price!

    68%
    off

    Reg. price
    $304

    Basic Data Analytics

    Includes 8 courses SQL Basics, SQL Practice Set, SQL JOINs, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, Introduction to Python for Data Science

    Bundle price $95

    37 hours left at this price!

    66%
    off

    Reg. price
    $193

    SQL First Aid

    Includes 5 courses SQL Basics, Standard SQL Functions, SQL Practice Set, SQL JOINs, Creating Tables in SQL

    Bundle price $65

    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 (9)

    Details

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

      Comments

      0