This course covers how XML is used in SQL Server, including retrieving and transforming XML data, using XQuery and XPath, and working with XML indexes, the XML schema, and well-formed XML.
Objectives:
Retrieve and transform XML data
Use OPENXML, sp_xml_preparedocument, and sp_xml_removedocument
Employ XQuery and XPath
Work with XML indexes
Explain the purpose of the XML schema and well-formed XML
Topics:
Explaining XML
Technical Requirements:
Minimum 500MHz Processor; 128 MB RAM; Windows 2000, XP, Vista, 7 or Mac OS X v10.4+; Internet Explorer 7.0+ or Firefox 3.0+ or Chrome 3.0+ or Safari 4.0+. 56K minimum connection; Adobe Flash Player 9.0+ or Windows Media Player 9.0+ for IE users who do not have Adobe Flash Player; JavaScript, popup windows and cookies enabled; Sound card with speakers or headphones strongly recommended.
