Target Audience: This course provides students with the knowledge and skills to design databases for Microsoft SQL Server 2005 using business requirements to guide their decisions. It 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.

Pre-requisites: Before attending this course, students must have the following pre-requisites:

• Be familiar with SQL Server 2005 features, tools, and technologies.
• Have basic knowledge of the operating system and platform.
• Know how to use a data modeling tool.
• 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, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL; Course 2779, Implementing a Microsoft SQL Server 2005 Database; Course 2780, Maintaining a Microsoft SQL Server 2005 Database.

Purpose: After completing this course, students will be able to approach database design from a systematic perspective, gather database requirements, and formulate a conceptual design; analyze and evaluate a logical database design; apply best practices for creating a physical database design; apply best practices when designing for database scalability; design a database access strategy; use best practices to model database dependencies.NB. This is a Preliminary Course Syllabus. Some parts of the course are currently in development, so some elements of this syllabus are subject to change.