Designing Databases for Performance with Microsoft® SQL Server„¢ 2005(3303)


Description:

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.

 

Objectives:

  • 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



User Reviews

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

Course Info

  • Code: EL-DDPM-SS205
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend