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