SQL Server 2000 Database Design MCSE 70-229 Series: Remote Data Access and XML
Product Code: sql206 Time: 2.0 hour(s) CEUs: Available

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.

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


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.



Copyright © 2008 MindLeaders. All rights reserved.