SQL Server 2000 Database Design MCSE 70-229

Synopsis
SQL Server 2000 Database Design MCSE 70-229: Remote Data Access and XML 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.

Audience
This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Time
2 hours

Product Code: SQL206

SQL Server 2000 Database Design MCSE 70-229: Remote Data Access and XML covers the following topics:

Linked servers

Ad hoc queries

Pass-through queries

XML and Internet Information Services (IIS)

The FOR XML clause

The OPENXML statement

This course has the following features:

Exercises that allow users to practice course techniques

A file containing the text of the exercises

Activities that allow users to apply course concepts in an interactive questioning environment

A glossary

A Skill Assessment

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation (SQL201)

SQL Server 2000 Database Design MCSE 70-229: Database Objects (SQL202)

SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data (SQL203)

SQL Server 2000 Database Design MCSE 70-229: Indexes and Views (SQL204)

SQL Server 2000 Database Design MCSE 70-229: Database Programming (SQL205)

Microsoft® is a registered trademark of Microsoft Corporation.
SQL Server 2000 is a trademark of Microsoft Corporation.