Designing for Database Performance with Microsoft® SQL Server™ 2005 (E-Learning)

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

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

Course Contents: 

In this 2-hour premium course you will learn how to optimize databases through the use of indexes, table optimizations and database optimizations. In the lab you will design a database using thse optimizations. Using these skills will allow you to design databases that perform well under under heavy stress.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft® SQL Server™ 2005.

Objective: 

Designing Indexes
Use Clustered and Nonclustered Indexes
Use XML Data Type Index
Use Computed Column Index
Optimize Tables
Design Views
Use Alternatives to Views
Use Indexed Views
Partition Tables
Creat Summary Tables
Use Selective Denormalization
Optimize database
Use Snapshot Isolation
Sizing Tempdb
Test the Database

Prerequisites: 

None

For more information on Designing for Database Performance with Microsoft® SQL Server™ 2005 (E-Learning) please feel free to contact us online or call us at 416-513-1535.