The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge of and expertise in the technologies with which they work.

Microsoft Certified Technology Specialists in SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to navigate the user interface. Technology Specialists are typically pursuing careers as a database administrator, database developer, or business intelligence developer. They may also be individuals such as developers and systems administrators who do not work with SQL Server on a daily basis but wish to show their breadth of technology experience.

The Application Architect Program Level I combines topics from following the following two courses and presents them in a coherent fashion.

2779 Implementing a Microsoft® SQL Server 2005 Database
2780 Maintaining a Microsoft SQL Server 2005 Database

At course completion 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.

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

For a complete course outline for MOC 2779 click here .

For a complete course outline for MOC 2780 click here.