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.
Students must complete the following classes and pass the following exam to get certified as MCITP’s
Course Objectives
MCTS: SQL Server 2005 - Implementation and Maintenance
MOC-2779:Implementing a SQL Server 2005 Database
MOC-2780: Maintaining a SQL Server 2005 Database
Prerequisites
Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.
Working knowledge of XML
Course Benefits
After completing this course, students will be able to:
Install and configure SQL Server 2005.
Create databases and database files.
Create data types and tables.
Generate basic SQL Server 2005 queries and XML reports.
