In this challenge lab, your will write several Transact-SQL queries to join data from multiple tables by using outer joins. First, you will launch Microsoft® SQL Server® Management Studio (SSMS), and then you will compare inner and outer joins. Next, you will develop more specific queries that include joining tables by using multiple outer joins. Finally, you will explore queries that join tables using multiple join type Note: Once you begin the challenge lab, you will not be able to pause, save, or exit and then return to your challenge lab. Please ensure that you have set aside enough time to complete the challenge lab before you start
Learning Objectives
In this challenge lab, your will write several Transact-SQL queries to join data from multiple tables by using outer joins. First, you will launch Microsoft® SQL Server® Management Studio (SSMS), and then you will compare inner and outer joins. Next, you will develop more specific queries that include joining tables by using multiple outer joins. Finally, you will explore queries that join tables using multiple join type Note: Once you begin the challenge lab, you will not be able to pause, save, or exit and then return to your challenge lab. Please ensure that you have set aside enough time to complete the challenge lab before you start