MP9004: Microsoft - Accessing and Manipulating XML Data > Visual C# XML MCAD 70-320

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. 

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

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

Duration:
6 Hours