Loading Course Schedule...
PT4565
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.
Prerequisites
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.
Duration
3 Days/Lecture & Lab
Audience
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.
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