Hands-On-Lab: XML and Xquery in SQL Server

Home/HOLs/Hands-On-Lab: XML and Xquery in SQL Server

Hands-On-Lab: XML and Xquery in SQL Server

Hello Friends,

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.

Learn More
 

 
Happy Learning – The Practical Way.

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

By |2020-09-01T12:01:38+05:30August 10th, 2020|HOLs|0 Comments

About the Author:

Leave A Comment