Introduction

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.

Pre-Requisites

Before attending this course, students must:

• Have experience reading user requirements and business-need documents.
• Understand Transact-SQL syntax and programming logic.
• Be familiar with the syntax of XML, what elements and attributes are, and how to distinguish them.
• Understand security requirements.
• Be able to design a database to 3NF and know the tradeoffs when backing out of the fully normalized design (denormalization).
• Have basic monitoring and troubleshooting skills.
• Have basic knowledge of the operating system and platform.
• Have basic knowledge of application architecture.
• Have some experience with a reporting tool.
• Be familiar with SQL Server 2005 features, tools, and technologies.
• Have an MCTS: Microsoft SQL Server 2005 credential, or equivalent experience.
• It is recommended, but not required, that students have completed

1. Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
2. Course 2779: Implementing a Microsoft SQL Server 2005 Database.
3. Course 2780: Maintaining a Microsoft SQL Server 2005 Database.

Outcomes

After completing this course, students 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.