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.
Ultimate money saver
With our Forever plan this course will cost you only
39 hours left
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.
Just a web browser and an Internet connection.
You'll also delve into the interesting topic of non-equi JOINs.
Review the most common types of JOINs. Practice JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and others.
Simple JOINs recap
Filtering with LEFT JOIN and RIGHT JOIN
Refine your joining skills. Exercise joining more than two tables in one SQL query.
Healthy Shop database
Learn how to join SQL table with itself.
Practice joins with less common conditions: non-equi JOINs and joins between non-key columns.
Medical Center database
Non primary-foreign key JOINs
Non-equi self JOINs
Check your knowledge in the challenge.