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:

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

Technical Requirements:

200MHz Pentium with 32MB Ram. 800 x 600 minimum screen resolution. Windows 98, NT, 2000, or XP. 56K minimum connection speed, broadband (256 kbps or greater) connection recommended. Internet Explorer 5.0 or higher required. Flash Player 7.0 or higher required. JavaScript must be enabled. Netscape, Firefox and AOL browsers not supported.

Copyright © 2006 Learn It Online. All rights reserved.