Series - Using-XML-in-SQL-Server-and-Azure-SQL-Database


Using XML in SQL Server and Azure SQL Database: (05) Creating Relational Data from XML[MP4] [0:27:02] [2015/04/26]
Get the details on how to use the OPENXML function to convert XML data to a relational structure.​ [01:26] - Options for Shredding XML[03:34] - The Nodes Method[09:35] - OPENXML[16:31] - OPENXML with…


Using XML in SQL Server and Azure SQL Database: (06) Creating XML from Relational Data[MP4] [0:29:44] [2015/04/16]
Find out how to use the FOR XML clause to generate XML from relational data structures. [00:17] - The FOR XML Clause[00:58] - RAW MODE[05:20] - AUTO MODE[09:44] - EXPLICIT MODE[18:02] - PATH…


Using XML in SQL Server and Azure SQL Database: (04) Working with Typed XML[MP4] [0:24:32] [2015/04/16]
Take a look at the concept of typed XML and the XML schema specification used to implement it. See how to define and use Schema Collections to implement typed XML in a database. [01:04] - XML…


Using XML in SQL Server and Azure SQL Database: (03) Implementing XML Indexes[MP4] [0:11:05] [2015/04/16]
Find out how to define and use XML indexes on XML columns in a database.​ [00:35] - Intro to XML Indexes and Primary XML index[03:03] - Secondary XML Indexes


Using XML in SQL Server and Azure SQL Database: (02) Storing and Querying XML[MP4] [0:46:47] [2015/04/16]
Explore the XML data type. Plus, learn how to use XQuery and to query XML data in Transact-SQL.​ [00:56] - The XML data Type[06:29] - Xquery[12:55] - Querying the XML Data Type[36:24] - Modifying the…


Using XML in SQL Server and Azure SQL Database: (01) Introduction to XML Data[MP4] [0:28:44] [2015/04/16]
Get an introduction to XML as a language for defining data structures, and hear about scenarios for storing and working with XML in a relational database.​ [03:45] - What is XML[14:35] - Representing…