Microsoft Certified IT Professional (MCITP): Database Developer

ICT Curriculum Roadmap for Database Administrator

Updated: June 27, 2007

Microsoft products

The Microsoft Certified IT Professional (MCITP): Database Developer credential applies to these products:

Microsoft SQL Server 2000
Windows Server 2003
Windows XP or Windows Vista

Step 1. Assess your foundational knowledge

Before beginning the MCITP: Database Developer curriculum, view the following table and move through each prerequisite in the order presented. Assess your knowledge against this list to determine your starting point. If you have knowledge gaps, use the learning and assessment resources to learn more. In some cases, a certification exam is available to validate your knowledge.

Prerequisites skills and knowledge —Self-assess checklist	Classroom training	E-Learning	Related study	Assessment resources	Certification exam
Fundamental understanding of computers, the Internet, and personal productivity programs: Digital literacy curriculum	Microsoft Digital Literacy*	Microsoft Digital Literacy*		Microsoft Digital Literacy certificate test*
Knowledge of computer hardware and components as in the CompTIA A+ Essentials Certification: Download file from Comptia.org (PDF, 164 KB)	Microsoft Official Academic Course (MOAC): ALS A+ Certification Package, Third Edition (Wiley.com)		Faster Smarter A+ Certification		CompTIA A+ Certification (Comptia.org)
Knowledge of computer networking and components as in the CompTIA Network+ Certification: Download file from Comptia.org (PDF, 60 KB)	MOAC: ALS Network+ Certification Package, Fourth Edition (Wiley.com)		Faster Smarter Network + Certification		CompTIA Network+ Certification (Comptia.org)
Knowledge of desktop operating systems, such as Windows XP (may substitute Windows Vista-roadmap below)	Microsoft Official Courseware (MOC) Course 2272: Implementing and Supporting Microsoft Windows XP Professional or MOC Course 2285: Installing, Configuring, and Administering Microsoft Windows XP Professional or MOAC: 70-270 Installing, Configuring, and Administering Microsoft Windows XP Professional Package, Second Edition Package (Wiley.com)	Courses 4119 and 4122: Core Training and What's New in Microsoft Windows XP Professional Service Pack 2 or Course 2285*: Installing, Configuring, and Administering Microsoft Windows XP Professional Service Pack 2	Microsoft Windows XP Step by Step Deluxe, Second Edition	Assessment tools for Course 2285*: Installing, Configuring, and Administering Microsoft Windows XP Professional Service Pack 2	MCP Exam 70-270: Installing, Configuring, and Administering Microsoft Windows XP Professional (Exam 70-270 is available at an academic discount)
Experience with database design	Beginning Database Design (Wiley.com)	Collection 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL		Assessment tools for Collection 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Knowledge of relational databases and Transact-SQL		Collection 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL	A Visual Introduction to SQL, Second Edition (Wiley.com) Beginning Transact-SQL with SQL Server 2000 and 2005 (Wiley.com) Beginning SQL (Wiley.com)	Assessment tools for Collection 2778*: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL