|
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:
After completing this course, students will be able to:
- 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
|
