MP9004: Microsoft - Indexes and Views > SQL Server 2000 Database Design MCSE 70-229

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. 

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

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

Duration:
3 Hours