Course Ref: 42131

Course: MS2781 Designing Microsoft SQL Server 2005 Server-Side Solutions

Course Summary

This three-day instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL ServerT 2005.

The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization.

Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.

Course Outline

Modules include:

  • Selecting SQL Server Services to Support Business Needs
  • Designing a Security Strategy
  • Designing a Data Modeling Strategy
  • Designing a Transaction Strategy for a SQL Server 2005 Solution
  • Designing a Notification Services Solution
  • Designing a Service Broker Solution
  • Planning for Source Control, Unit Testing, and Deployment  
  • Evaluating Advanced Query and XML Techniques 
By the end of the course, delegates will be able to:

  • Select SQL Server services to support an organization's business needs.
  • Design a security strategy for a SQL Server 2005 solution.
  • Design a data modeling strategy.
  • Design a transaction strategy for a SQL Server solution.
  • Design a Notification Services solution.
  • Design a Service Broker solution.
  • Plan for source control, unit testing, and deployment to meet an organization's needs.
  • Evaluate advanced query techniques.
  • Evaluate advanced XML techniques.

 

Where & When

LocationWokingham
Start Date1 Dec 08
Price (ex. VAT)£595.00
Venue Info Wokingham - Mulberry Business Park
ResidentialNo
AvailabilitySpaces
Duration3 days
Delivered AsVenue and on-site
Pre-course Reading
No precourse reading is specified.
Exam IncludedNo
Course Ref42131