SQL Server 2000, XML, and the Web

Overview/Description
To outline the relationship between SQL Server 2000, XML, and the Web

Target Audience
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year’s experience administering SQL Server; at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
95 Minutes

Objectives:

SQL Server 2000, XML, and the Web

  • provide an overview of XML and discuss its main uses.
  • describe how to configure a SQL Server 2000 database as an ODBC source.
  • describe how to configure a virtual directory in IIS to support SQL and XML.
  • create an XML and XSL template to verify IIS virtual directory support for SQL Server.
  • perform simple SQL queries of a database using Internet Explorer.


    • Course Number: 31571_eng