Here is another popular lab from Hands-On-Lab library: Logical and Physical Query Processing in SQL Server.
In this lab, we’ll learn about how a query is logically and physically processed in SQL Server. In the first exercise, we will learn about logical execution order of the statements in select clause. In the second exercise, we will learn how the query is physically processed.
Exercise 1: Logical Query Processing
Exercise 2: Physical Query Processing
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.