Basic Course

SQL JOINs

Review and deepen your knowledge of SQL JOINs with 93 exercises. Practice common and less common ways of getting data from multiple tables.

4.83 ★★★★★ ★★★★★ (8250 ratings)

155,979 learners enrolled

Lifetime access

limited to this course only

$39

Want a better deal?

Get unlimited lifetime access to all 76 present and future courses

Save $450

Unlimited lifetime access

to all 76 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 10 h

Coding challenges 93

Skills you will gain

  • 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

Last reviews

Description

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.

Cover image for the course 'SQL JOINs'

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

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

Average rating

4.83/5

★★★★★ ★★★★★ (8250 ratings)

5 stars

84%

4 stars

16%

3 stars

0%

2 stars

0%

1 stars

0%