Course Ref: 42163
Course: MS2788 Designing High Availability Database Solutions Using Microsoft SQL Server 2005
Course Summary
This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft® SQL ServerT 2005 the knowledge and skills to evaluate and improve queries and query response times.
The workshop focuses on systematic identification and optimization of database factors that impact query performance.
The workshop focuses on systematic identification and optimization of database factors that impact query performance.
Course Outline
Modules include:
By the end of the course, delegates will be able to:
- Selecting the Appropriate High-availability Solution
- Designing a Clustering Solution
- Designing a Highly Available Database Storage Solution
- Designing a Log Shipping Solution
- Designing a Database Mirroring Solution
- Designing a Highly Available Solution Based on Replication
- Combining High-availability Technologies
- Documenting and Testing a High-availability Strategy
By the end of the course, delegates will be able to:
- Normalize databases.
- Design a normalized database.
- Optimize a database design by denormalizing.
- Optimize data storage.
- Manage concurrency by selecting the appropriate transaction isolation level.
- Select a locking granularity level.
- Optimize and tune queries for performance.
- Optimize an indexing strategy.
- Decide when cursors are appropriate.
- Identify and resolve performance-limiting problems.
Where & When
| Location | Wokingham |
|---|---|
| Start Date | 26 Nov 08 |
| Price (ex. VAT) | £595.00 |
| Venue Info | Wokingham - Mulberry Business Park |
| Residential | No |
| Availability | Limited |
| Duration | 3 days |
| Delivered As | Venue and on-site |
| Pre-course Reading | |
| No precourse reading is specified. | |
| Exam Included | No |
| Course Ref | 42163 |
