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.
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.
Refine your joining skills. Exercise joining more than two tables in one SQL query.
Learn how to join SQL table with itself.
Practice joins with less common conditions: non-equi JOINs and joins between non-key columns.
Check your knowledge in the challenge.