Microsoft SQL Server 7.0: Indexes and Views

Overview/Description
To explain how to create and manage table indexes and views

Target Audience
IT professionals including database administrators, application developers, independent software vendors, 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

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Indexes and Views

  • To describe indexes, and how they are used and created
  • To view, drop, rebuild, and rename SQL Server table indexes, and to use indexes for text searching
  • To describe how to maintain indexes to ensure optimum efficiency and performance
  • To describe views and show how to create and maintain views


    • Course Number: SQ7047E