Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Indexes and Views

Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To explain how to create and manage table indexes and views

Learning Objectives

Discuss how indexes improve query performance. Understand the difference between clustered and nonclustered indexes. Discuss how to manage and optimize indexes. Create and maintain views.

Topics Covered

Creating indexes - Using indexes - Using the CREATE INDEX statement - Using Enterprise Manager - Hands-on: Creating an index Managing indexes - Viewing index information - Index dropping, rebuilding, and renaming - Hands-on: Renaming an index - Indexes for text searching Index maintenance - Maintaining indexes - Updating index statistics - Analyzing indexes - Hands-on: Maintaining an index Implementing views - Introducing views - Creating views - Maintaining views - Using views to modify data - Hands-on: Creating and altering a view