Click here to login

If you don't have a registration, click here to register

Online course

E-learning- XML on SQL Server

This XML on SQL Server training course shows you how to retrieve and modify XML data, and describes how to convert between XML and relational data. You also see how you can optimize the new XML data type in SQL Server 2005 for data retrieval by using different types of indexes. Unlike relational data, XML data can represent structured, semi structured, and unstructured data. XML support in SQL Server 2005 is fully integrated with the relational engine and query optimizer, allowing the retrieval and modification of XML data and even the conversion between XML and relational data representations.

  • XML structures

    • 1

      XML structures

      In this lesson you will learn about the XML structures, the storage options and the use of text columns to store XML. Watch this video