Published on HiTech Institute (http://www.htinstitute.com)

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

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

Vendor: 
Microsoft [1]
Subject: 
Database [2]
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

Business Analysis (BA)

Business Analysis (IIBA) Courses
About IIBA
CBAP Certification
CCBA Certification
Business Analysis Certification Benefits
Business Analysis Training at HiTech Institute

-->

Source URL: http://www.htinstitute.com/courses/designing-for-database-performance-with-microsoft-sql-server-2005-e-learning

Links:
[1] http://www.htinstitute.com/vendors/microsoft
[2] http://www.htinstitute.com/htnteam/database