Microsoft Certified IT Professional (MCITP) Database Developer
Computer certification programs are setting the standards for the information technology (IT) industry worldwide. Although most careers in the IT and communications fields are lucrative and lead to rapid advancement, you can move ahead even more rapidly if you have been certified. In fact, you often can earn a salary increase of 20% or more once you become certified. Nowadays, having a degree in computer science just isn't enough. Companies are demanding that their IT professionals be certified as a way to measure their skills as well as to guarantee that they can perform their jobs successfully. In short, certification will help a computer professional get a good job and stay competitive in what is now a highly demanding IT environment.
This training would be beneficial for individuals looking for IT job positions such as: Database Administrators or Microsoft Database Developers.
Microsoft Certified IT Professional (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.
Exam 70-431: Microsoft SQL Server 2005: Implementation and Maintenance
This course provides students with the knowledge to:
- Install and configure SQL Server
- Set up tables, indexes, columns, and constraints
- Use Transact-SQL to implement functions, stored procedures, and triggers
- Work with relational and XML data
- Monitor, troubleshoot, and tune queries
- Maintain database availability with log shipping, mirroring, and replication
- Prepare a backup strategy and restore a database
Exam 70-441 PRO: SQL Server 2005: Designing Database Solutions
This course provides students with the knowledge to:
- Design Database Testing and Code Management Procedures
- Design an Application Solution for SQL Server 2005
- Design Database Objects
- Design a Database
- Develop Applications That Use SQL Server Support Services
Exam 70-442 PRO: SQL Server 2005: Designing and Optimizing Data Access
This course provides students with the knowledge to:
- Design Efficient Access to a SQL Server Service
- Design a Database Query Strategy
- Design Error-Handling Routines
- Design a Transaction Strategy
- Performance Tune a Database and a Database Application