Exam news

Exam MCSE 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 became available January 30, 2006. This is a Microsoft Certified IT Professional (MCITP) certification exam.

Audience profile

Candidates for this exam are professional database developers who design and implement database solutions. They have three or more years dedicated to database work, which may include writing Transact-SQL queries, designing and implementing programming objects, optimizing databases, designing databases at both the conceptual and logical levels and implementing databases at the physical level. The typical work environment is an enterprise or a medium-sized organization. Candidates should be experienced in using Microsoft SQL Server 2005.

Candidates for this exam should be an expert in following areas:

• Writing Transact-SQL queries

• Programming databases

• Troubleshooting programming objects (stored procedures, triggers, user-defined functions (UDFs), user-defined types (UDTs), and queries)

• Performing database performance tuning and optimization

• Designing databases, at both the conceptual and logical levels

• Implementing databases at the physical level

• May be involved in designing and troubleshooting the data access layer of the application

• Gathering business requirements

Credit toward certification

When you pass Exam MCSE 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005, you earn credit toward the following certification:

• Microsoft Certified IT Professional: Database Developer