SQL Server 2000 Transactions and Distributed Data

Overview/Description
To demonstrate how to utilize transactions and distributed data

Target Audience
Database administrators, application developers, and system administrators; 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 years experience administering SQL Server; at least one years 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
100 Minutes

Objectives:

SQL Server 2000 Transactions and Distributed Data

  • describe and use transactions.
  • discuss database locking.
  • obtain locking information using both Query Analyzer and Enterprise Manager.
  • set up a link and establish security between remote servers.
  • query data from linked servers.
  • use partitioned views.
  • configure a link to a remote server and execute queries on a remote server.


    • Course Number: 31917_eng