Course 10364: Creating and Optimizing Indexes in Microsoft SQL Server 2008 R2
Description
Introduction 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.
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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.
- Describe indexes.
- Create Indexes.
- Optimize Indexes.
- Maintain Indexes.
- Work with Spatial Indexes.
- Describe best practices for creating and optimizing indexes.
- A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
- Microsoft® Windows® 2000 or higher
- Microsoft Internet Explorer 6.0 or higher
- Adobe Flash 7.0 or higher (1MB disk space needed to install)
- Microsoft Silverlight 4.0 or higher
- Microsoft Windows Media Player 7.0 or higher
- Microsoft XML Core Services 3.0 or higher
- A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
- A sound card, and either speakers or headphones (for multi-media audio).
- Internet bandwidth of 56K or faster. Broadband internet access is recommended.
- Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
- Microsoft Internet Explorer 6.0 or higher
- Window-Eyes from GW Micro
- JAWS from Freedom Scientific
- MSAA enabled
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.