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…