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

JOINs in MS SQL Server

Review and deepen your knowledge of T-SQL JOINS with this set of 93 great, interactive exercises. Practice the most popular and less common ways of getting data from multiple tables in MS SQL Server.

Table of contents

Ultimate money saver

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

With our Forever plan this course will cost you only

$ 4.12

84% OFF

39 hours left

SEE PRICING
93

Interactive exercises

10 h

Estimated time

3

Users enrolled

☆☆☆☆☆
★★★★★

1 ratings

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

Table of contents

Free

Paid content

0%

Course progress

0/93

Exercises completed

Reviews (0)

Average rating

5.00 / 5

☆☆☆☆☆
★★★★★

1 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%