MCITP: Database Developer 2008

Candidates for this exam typically work in an enterprise environment that has more than 500 personal computers and more than 100 servers and mostly create solutions for all types of enterprise issues. Candidates should have experience with the following:

• Writing transact SQL queries
• Programming the database
• Troubleshooting programming objects (for example, stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs], and queries)
• Database performance tuning and optimization
• Designing databases at both the conceptual and logical levels
• Implementing databases at the physical level
• Might be involved in designing and troubleshooting the data access layer of the application
• Gathering business requirements