MP9004: Microsoft - Remote Data Access and XML > SQL Server 2000 Database Design MCSE 70-229

This course explains techniques for accessing heterogeneous data using linked servers, ad hoc queries, and pass-through queries, and shows users how to retrieve and write data using XML. 

Topics:
Linked servers
Ad hoc queries
Pass-through queries
XML and Internet Information Services (IIS)
The FOR XML clause
The OPENXML statement

Objectives:
Create a linked server
Create ad hoc and pass-through queries
Set up the SQL Server to return XML results
Request, retrieve, and parse XML data

Duration:
2 Hours