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

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

Length:2.00 hours - Excluding labs and assessments
Published:Aug 25, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This two-hour course provides you with the skills and knowledge required to plan, create and optimise indexes. In this course, you will learn about the different types of indexes that can be implemented in SQL Server 2008 and how each type of index can improve the way you retrieve data. You will learn how to create indexes and how to optimise indexes to get the best performance from them.

Topics covered in this course include:

Overview of Indexes
Creating Indexes
Optimizing Indexes
Managing a SQL Server 2008 Database

Objective: 

Describe indexes.
Create indexes.
Optimize indexes.
Maintain indexes.
Work with spatial indexes..

Prerequisites: 

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.

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