Here is another popular lab from Hands-On-Lab library: XML and Xquery in SQL Server.
Extensive markup language(XML) is a language used to encode the documents in such a way that both Humans and Machines can read the data. XML was designed to store and transport the data. XQuery is a query used to retrieve the data from XML document. This lab is divided into four exercise. In the first exercise, we will learn to convert the relational data into XML format. In the second exercise, we learn to query the XML data stored in a particular column using XQuery. In the third exercise, we will learn to improve the performance of the XQuery using Primary XML index. The fourth and fifth exercises are Self-Assessment and T-SQL challenge where a problem is stated that needs to be solved by you.
Exercise 1: Relational composition to XML
Exercise 2: Querying XML using XQuery
Exercise 3: Improving XQuery performance using Primary XML Index
Exercise 4: Self-Assessment
Exercise 5: 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.