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.

Subscribe to Download


Version1.0
Download2
File Size1,006.49 KB
Create DateOctober 21, 2016
Last UpdatedOctober 21, 2016
SQL Server Showplan Operator Part 2
SQL Server Data Types Part 2