Here is another popular lab from Hands-On-Lab library: Views in SQL Server.
In Transact-SQL (T-SQL) a view allows us to create a virtual representation of table whose contents are defined by the query. The query that defines the view can be joined from one or more tables. Once a view is created we can be reference the view in the FROM clause of the query. This lab is divided into six exercises explaining how to create, modify, and encrypt a view and how to create partitioned and indexed view’s.
Exercise 1: Create and implement a view
Exercise 2: Modify the data using a view
Exercise 3: Encrypt a view
Exercise 4: Create Partitioned and Indexed view’s
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.