Total Time: 2 hour(s)

Summary: 
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.

Ojectives: 
After completing this course, students will be able to:
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

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

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.