The function of database developers is to design implement relational database both logical and physical models and database storage objects. They program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. Database developers are able to retrieve or modify data using SQL queries or tune and optimize queries.
MCITP Database Developer is one of the certification programs offered by Microsoft under the MCITP. It is the program that leads to certification for database designers and developers. The certification allows database developer the credentials to demonstrate their capabilities of designing a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
As a prerequisite prior to taking the MCITP Database Developer exam, is for the candidate to pass one of the MCTS prerequisite exam on SQL Server 2005 – Implementation and Maintenance. After passing the MCTS exam, the candidate to achieve the MCITP Database Developer certification is to take and pass two Professional Series Exam. These two are Designing Database Solutions by Using Microsoft SQL Server 2005 and Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.
It is expected that candidates for this exam are expert in the following areas:
1. Writing Transact-SQL queries
2. Programming databases
3. Troubleshooting programming objects (stored procedures, triggers, user-defined functions (UDFs), user-defined types (UDTs), and queries)
4. Performing database performance tuning and optimization
5. Designing databases, at both the conceptual and logical levels
6. Implementing databases at the physical level
7. Involved in designing and troubleshooting the data access layer of the application
8. Gathering business requirements
Microsoft provides both classroom training and elearning for the MCITP Database Developer program certification.