This course explains how to use the Function Control Language to access and manipulate XML data. It also explains how to use these classes and T-SQL extensions to access Microsoft SQL Server data as XML data.
Objectives:
Access an XML file by using the DOM and an XmlReader
Transform DataSet data into XML data
Use XPath to query XML data
Generate and use an XSD schema
Write a SQL statement that retrieves XML data from a SQL Server database
Update a SQL Server database by using XML
Validate an XML document
Topics:
The XML File
Using an XmlReader Object
Using the XmlTextReader Class
The XmlNode Class
The XmlDocument Class
Synchronizing DataSet Objects with XML
Synchronizing with an XmlDataDocument Object
Retrieving a DataSet object from an XmlDataDocument Object
Synchronizing with a full DataSet object
Synchronizing with an XML Schema
Understanding XPath
Using the XPathNavigator Class
Navigating Nodes with XPath
Generating an XSD Schema
Validating XML Files against Schemas
Validating XML Files against DTDs
Generating XML with SQL Statements
Retrieving XmlReader objects with SQL Statements
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
