SQL Server 2000 Database Design MCSE 70-229 Series: Indexes and Views
Product Code: sql204 Time: 3.0 hour(s) CEUs: Available

Summary:

This course explains the types of indexes and views available in SQL Server 2000, and shows how they can be used to enhance and control access to data.

Objectives:

  • Create various types of indexes
  • Create and modify table views
  • Modify table data through a view
  • Partition data using views


Topics:

  • Types of indexes
  • Creating indexes
  • Using the Create Index Wizard
  • Analyzing index performance
  • Altering indexes
  • Using views
  • Guidelines for views
  • Creating views
  • Analyzing CREATE VIEW statements
  • Modifying a view
  • Using views to modify data
  • Creating partitioned views
  • Using indexed and XML views

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.



Copyright © 2008 MindLeaders. All rights reserved.