SQL Server 2000 Database Design MCSE 70-229

Synopsis
SQL Server 2000 Database Design MCSE 70-229: Indexes and Views 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.

Audience
This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Time
3 hours

Product Code: SQL204

SQL Server 2000 Database Design MCSE 70-229: Indexes and Views covers the following 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

This course has the following features:

Exercises that allow users to practice course techniques

A file containing the text of the exercises

Activities that allow users to apply course concepts in an interactive questioning environment

Simulations that allow users to practice course skills, even if they don't have access to SQL Server 2000

A glossary

A Skill Assessment

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation (SQL201)

SQL Server 2000 Database Design MCSE 70-229: Database Objects (SQL202)

SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data (SQL203)

Microsoft® is a registered trademark of Microsoft Corporation.
SQL Server 2000 is a trademark of Microsoft Corporation.