|
|
| MCITP: Database Developer |
| Microsoft Certified IT Professional: Database Developer (1 MCTS exam + 2 MCITP exams) |
Target Audience/Typical Job Role: Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. Database developers are typically employed by midsize to large organizations. |
| 1) Microsoft SQL Server 2005 - Implementation & Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| |
2778 |
and |
2779 |
and |
2780 |
|
| |
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL |
|
Implementing a Microsoft SQL Server 2005 Database |
|
Maintaining a Microsoft SQL Server 2005 Database |
|
| |
(3 days) |
|
(3 days) |
|
(3 days) |
|
| |
exam 70-431 |
|
| |
|
|
|
|
|
|
| 2) Designing Database Solutions by Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| |
2781 |
and |
2782 |
|
|
|
| |
Designing Microsoft SQL Server 2005 Server-Side Solutions |
|
Designing Microsoft SQL Server 2005 Database |
|
|
|
| |
(3 days) |
|
(2 days) |
|
|
|
| |
exam 70-441 |
|
|
| |
|
|
|
|
|
|
| 3) Designing and Optimizing Data Access Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| |
2783 |
and |
2784 |
|
|
|
| |
Designing the Data Tier for Microsoft SQL Server 2005 |
|
Tuning and Optimizing Queries Using Microsoft SQL Server 2005 |
|
|
|
| |
(1 day) |
|
(3 days) |
|
|
|
| |
exam 70-442 |
|
|
|
|
|
|
|
|
|
|