Jump to content Worldwide-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
HP.com home
 Microsoft  >  Certification 

SQL Server 2005 Microsoft Certifications
Content starts here

SQL Server 2005 MS Certifications Tracks
»  Microsoft Certified Technology Specialist
»  Microsoft Certified IT Professional: Database Developer
»  Microsoft Certified IT Professional: Database Administrator

MS Certifications
»  SQL Server 2005 Microsoft Certifications
»  Microsoft Certified Systems Admin Win. Server 2003
»  Microsoft Certified System Engineer (MCSE) Win. Server 2003
»  Microsoft Certified Solution Developer (MCSD) Visual Basic .NET
»  Microsoft Certified Solution Developer (MCSD) C# .Net
»  Microsoft Certified Application Developer (MCAD) Visual Basic .NET
»  Microsoft Certified Application Developer (MCAD) C# .Net

Microsoft Certified Technology Specialist


Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in the various Microsoft specialized technologies. Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. To earn a MCTS certification two courses are required and a completion of one exam. The following rable provides a complete list of courses and the exam.

Microsoft Certified Technology Specialist Curriculum
  HC602S  Implementing a Microsoft SQL Server 2005 Database (MOC 2779)  3 days  » details
  HC595S  Maintaining a Microsoft SQL Server 2005 Database (MOC 2780)  3 days  » details
  Exam  70-431    

» Back to the top

Microsoft Certified IT Professional: Database Developer


Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential 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 using SQL queries or tune and optimize queries. Database developers are typically employed by mid-sized to large-sized organizations. To earn a MCITP: Database Developer three required exams must be passed. The following table provides a complete list of courses and exams.

Microsoft Certified IT Professional: Database Developer Curriculum
  HE570S  Designing Microsoft SQL Server 2005 Server-Side Solutions (MOC 2781)  3 days  » details
  HC596S  Designing Microsoft SQL Server 2005 Databases (MOC 2782)  2 days  » details
  Exam  70-441    
  HE570S  Designing Microsoft SQL Server 2005 Server-Side Solutions (MOC 2781)  3 days  » details
  HC597S  Designing the Data Tier for Microsoft SQL Server 2005 (MOC 2783)  1 day  » details
  HE568S  Tuning and Optimizing Queries Using Microsoft SQL Server (MOC 2784)  3 days  » details
  Exam  70-442    
  HC602S  Implementing a Microsoft SQL Server 2005 Database (MOC 2779)  3 days  » details
  HC595S  Maintaining a Microsoft SQL Server 2005 Database (MOC 2780)  3 days  » details
  Exam  70-431    

» Back to the top

Microsoft Certified IT Professional: Database Administrator


Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-size to large organizations. To earn a MCITP: Database Administrator certification four required exams must be passed. The following table provides a complete list of courses and exams.

Microsoft Certified IT Professional: Database Administrator Curriculum
  HC598S Designing a Microsoft SQL Server 2005 Infrastructure (MOC 2786)  2 days  » details
  HE567S Designing Security for Microsoft SQL Server 2005 (MOC 2787)  2 days  » details
  HE569S Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (MOC 2788)  3 days  » details
  Exam 70-443    
  HE567S Designing Security for Microsoft SQL Server 2005  2 days  » details
  HC599S Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (MOC 2789)  1 day  » details
  HE566S Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server (MOC 2790)  2 days  » details
  Exam 70-444    
  HC598S Designing a Microsoft SQL Server 2005 Infrastructure (MOC 2786)  2 days  » details
  HE567S Designing Security for Microsoft SQL Server 2005 (MOC 2787)  2 days  » details
  HE569S Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (MOC 2788)  3 days  » details
  n/a Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (MOC 2789)  1 day  » n/a
  HE566S  Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (MOC 2790)  2 days  » details
  Exam 70-447    
  HC602S Implementing a Microsoft SQL Server 2005 Database (MOC 2779)  3 days  » details
  HC595S Maintaining a Microsoft SQL Server 2005 Database (MOC 2780)  3 days  » details
  Exam 70-431    

» Back to the top
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2007 Hewlett-Packard Development Company, L.P.