Here is another popular lab from Hands-On-Lab library: Table Expressions in SQL Server.
In Transact-SQL (T-SQL), Table Expressions holds the query expressions as a relational table for data manipulation. This lab is divided into nine exercises explaining different scenarios where table expressions are useful.
Exercise 1: Derived Tables with Inline column aliases
Exercise 2: Derived Tables with Arguments
Exercise 3: Derived Tables with Multiple References
Exercise 4: Common Table Expressions with Inline column aliases
Exercise 5: Common Table Expressions with Arguments
Exercise 6: Common Table Expressions with Multiple References
Exercise 7: Recursive Common Table Expressions
Exercise 8: Self-Assessment
Exercise 9: 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.