Sizzling Minerals
A unique Life-Changing Product that Everyone Needs

We can reveal a Critical Health Secret most people are not aware of…

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

Total Time: 3 hour(s)

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.

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

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.

  Home | Privacy | Contact Us