Publisher: Microsoft

Version: 2005/8
Length: 1 day
Course-ID: SX688GRB

Course Overview

In this course you will learn how to work with XML structures, retrieve XML data using server technolgies, modify XML data, convert between XML data and releational data and create XML indexes.

Target student

Business analysts, developers and administrators.

Prerequisites

Previous exposure to SQL relational database systems and XML.


Working with XML Structures
  • Storage Options for XML Data
  • Storing XML in Text Columns
  • Storing XML in XML Data Type Columns
  • Typing and Validating XML Data with XML Schemas
Retrieving XML Data using SQL Server Server-Side Technologies
  • Converting Relational Data to XML
  • Retrieving XML Data from The XML Data Type
Retrieving XML Data using SQL Server Middle-Tier Technologies
  • Using SQLXML- Annotated XSD Schemas
  • Querying Annotated XML Schemas and XML Views from ,NET
Modifing XML Data
  • Modifying XML Values and XML Structure
  • Using SQLXML Updategrams
Converting between XML Data and Relational Data
  • Shredding XML using OPENXML and XML Stored Procedures
  • Shredding XML by using the XML Data Type’s nodes() Method
  • ShreddingXML using SQLXML
Creating XML Indices
  • Indexing an XML Data Type Instance
  • Creating and XML Data Type Primary Index
  • Creating XML Data Type Secondary Indices