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.
Course Objectives
Designing Database Solutions Using Microsoft SQLServer 2005
MOC-2781:DesigningMicrosoft SQL Server 2005 Server-Side Solutions.
MOC-2782:DesigningMicrosoft SQL Server 2005 Databases.
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.
