Visual C# XML MCAD 70-320 Series: Accessing and Manipulating XML Data
Product Code: xmc303 Time: 6.0 hour(s) CEUs: Available

Summary:

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 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.



Copyright © 2008 MindLeaders. All rights reserved.