070-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

Description

This course provides students with the knowledge and skills to design server-side solutions and databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions. 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 as well as learn to incorporate security requirements throughout their design.

Entrance Requirements

• Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Implementing a Microsoft SQL Server 2005 Database.
• Maintaining a Microsoft SQL Server 2005 Database.

Who Should Attend

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 Outline

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

Examinations and Assessments

Learners write the CCS IT examination, the pass mark for which is 50%. Learners may elect to write the International Microsoft examinations at CCS IT’s Authorized Prometric Testing Centre at an additional cost.

Learning Materials

All standard learning materials are included in the course fee.