Designing Microsoft SQL Server 2005 Server-Side Solutions

This 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.

Voor wie

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.

Voorkennis
Before attending this course, students must: • Have experience reading user requirements and business-need documents. • Understand Transact-SQL syntax and programming logic. • Understand XML. • Understand security requirements. • Be able to design a database to 3NF and be familiar with design models. • 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 a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential - or equivalent experience. In addition, it is recommended, but not required, that students have completed Course 2778, 2779 and 2780.