Here is another popular lab from Hands-On-Lab library: SQL Server Joins.
Using joins in SQL Server we can retrieve data from two or more tables based on the relationship between those tables. This lab is divided into six exercises explaining different types of joins such as INNER JOIN, OUTER JOIN, CROSS JOIN and SELF JOIN.
Exercise 1: INNER JOIN
Exercise 2: OUTER JOIN
Exercise 3: CROSS JOIN
Exercise 4: SELF-JOIN
Exercise 5: Self-Assessment
Exercise 6: T-SQL Challenge
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.