Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	3 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 describe and show how to create and manage indexes

Topics Covered

Creating SQL Server 2000 indexes Creating and maintaining SQL Server 2000 indexes Using the SQL Server 2000 CREATE INDEX statement Creating SQL Server 2000 indexes using Enterprise Manager Creating a SQL Server 2000 index Managing SQL Server 2000 indexes Viewing SQL Server 2000 index information Dropping, rebuilding, and renaming SQL Server 2000 indexes Renaming a SQL Server 2000 index Using SQL Server 2000 indexes for full text searching

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