SQL-2005  Designing (070-441)

Designing Database Testing and Code Management Procedures
Design a unit test plan for a database.
Create a performance baseline and benchmarking strategy for a database.
Create a plan for deploying a database.
Control changes to source code.
Designing an Application Solution for SQL Server 2005
Select and design SQL Server services to support business needs.
Design a logical database.
Design an application solution to support security.
Design an application solution that uses appropriate database technologies and techniques.
Design an application solution that supports reporting.
Design data distribution.
Designing Database Objects
Design objects that define data.
Design objects that retrieve data.
Design objects that extend the functionality of a server.
Design objects that perform actions.
Designing a Database
Design attributes.
Design entities.
Design entity relationships (ER).
Design database security.
Developing Applications That Use SQL Server Support Services
Develop applications that use Reporting Services.
Develop applications for Notification Services.
Develop packages for Integration Services.