|
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:
After completing this course, students will be able to:
- 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
|
