Creating and Optimizing Indexes in Microsoft SQL Server 2008 R2 (E-Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Feb 15, 2011
Language:English
Audiences:Developer
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This two-hour course provides you with the knowledge and skills to create and optimize indexes in Microsoft SQL Server 2008 R2.

This course covers the following topics.
Describing indexes
Creating indexes
Optimizing indexes
Maintaining indexes
Working with Spatial indexes
Best practices for creating and optimizing indexes

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:
A good general knowledge of database concepts.
Experience working with Windows and programming concepts.
Understanding of server management concepts such as roles and tracing.
A basic understanding of XML.

Objective: 

Describe indexes.
Create Indexes.
Optimize Indexes.
Maintain Indexes.
Work with Spatial Indexes.
Describe best practices for creating and optimizing indexes..

Prerequisites: 

None

For more information on Creating and Optimizing Indexes in Microsoft SQL Server 2008 R2 (E-Learning) please feel free to contact us online or call us at 416-513-1535.