Introduction Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) certification 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 by using SQL queries or tune and optimize queries. Database developers are typically employed by medium-sized to large organizations.
To achieve this certification, you must pass three exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and two Professional Series exams.
| Course Code | Course Name | Duration |
| 70 – 431 | TS: Microsoft SQL Server 2005 – Implementation and Maintenance | 10 Days |
| 70 – 441 | PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 | 7 Days |
| 70 – 442 | PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 | 5 Days |
Course Outline:-
70-431
- Installing and Configuring SQL Server 2005
- Implementing High Availability and Disaster Recovery
- Supporting Data Consumers Maintaining Databases
- Monitoring and Troubleshooting SQL Server Performance
- Creating and Implementing Database Objects
70-441
- Designing Database Testing and Code Management Procedures
- Designing an Application Solution for SQL Server 2005
- Designing Database Objects Designing a Database
- Developing Applications That Use SQL Server Support Services
70-442
- Designing Efficient Access to a SQL Server Service
- Designing a Database Query Strategy
- Designing Error-Handling Routines
- Designing a Transaction Strategy
- Performance Tuning a Database and a Database Application
