Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	5 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

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 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

Course Aim

This learning path describes in detail the new features, tools, and best practices for designing and implementing databases using Microsoft SQL Server 2000.

Learning Objectives

To demonstrate how to utilize transactions and distributed data

Topics Covered

Managing SQL Server 2000 transactions and locks SQL Server 2000 transaction management SQL Server 2000 database locking Displaying locking information in SQL Server 2000 The SQL Server 2000 distributed data environment Setting up distributed environments in SQL Server 2000 Querying data from a linked server in SQL Server 2000 SQL Server 2000 distributed views Querying distributed data in SQL Server 2000

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.