Course Ref: 38906

Course: MS2782 Designing Microsoft SQL Server 2005 Databases

Course Summary

This two-day instructor-led course provides students with the knowledge and skills to design databases for Microsoft® SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.

Course Outline

Modules include:

  • Approaching Database Design Systematically
  • Modeling a Database at the Logical Level
  • Modeling a Database at the Physical Level
  • Designing for Database Performance
  • Designing a Database Access Strategy
  • Modeling Database Dependencies
By the end of the course delegates should be able to:

  • Approach database design from a systematic perspective, gather database requirements, and formulate a conceptual design.
  • Analyze and evaluate a logical database design.
  • Apply best practices for creating a physical database design.
  • Apply best practices when designing for database scalability.
  • Design a database access strategy.
  • Use best practices to model database dependencies.

Where & When

LocationWokingham
Start Date4 Dec 08
Price (ex. VAT)£445.00
Venue Info Wokingham - Mulberry Business Park
ResidentialNo
AvailabilityLimited
Duration2 days
Delivered AsVenue and on-site
Pre-course Reading
No precourse reading is specified.
Exam IncludedNo
Course Ref38906