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

Are you working with data? The ability to use JOINs will definitely come in handy. This is one of the most basic and useful functions of the SQL language. If you want to work freely with databases and harness the full potential of MS SQL Server, you should learn JOINs. Expand your skill set with SQL JOINS. This will allow you to combine data from multiple tables and much more.

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

We have created this interactive course for people who already have, at least, a very basic level of SQL experience. We assume you know how to write simple queries to select data from one table. If you're completely green and don't know what we're talking about, take the SQL Basics in MS SQL Server first and come back here later. If you already know the basics of SQL, don't hesitate to start having fun with JOINs now.

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
  • How to JOIN many tables in a single query
  • How to use 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 this course

    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