Designing Microsoft SQL Server 2005 Server-Side Solutions

Training Summary
This instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 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.
Before attending this course, students must have experience reading user requirements and business-need documents, understand Transact-SQL syntax and programming logic and understand XML.
3 Days/Lecture & Lab
This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.
Course Topics
  • Selecting SQL Server Services to Support Business Needs
  • Selecting SQL Server Services to Support Business Needs
  • 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

Related Scheduled Courses