Optimizing Physical Database Design by Using Microsoft® SQL Server 2005(4371)

Description:

In this 2-hour workshop, you will learn about how to optimize your schema design to meet the performance requirements of your Microsoft® SQL Server™ 2005 database solutions.

In the lab, you will optimize various schema objects, as well as measure the performance after the objects have been optimized. As a workshop, most of the learning will be done within the lab itself.

Having this experience will enable you to both prevent performance issues form occuring, as well as address issues that arise during deployed database solutions.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.

 

Objectives:

• Describe strategies for optimizing physical database design.
• Create an optimized database design.

 

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.