Microsoft Certification for SQL Server 2005

1
Microsoft Certification for SQL Server 2005

• James HippoliteSenior .NET DeveloperTelecom New
  Zealand Limited

2
Agenda

• Certification Overview
• Certification Benefits
• Technology Specialist Exams
• Professional Exams
• SS2005 MCITP Roadmap
• Database Developer
• Database Administrator
• Business Intelligence Developer
• Questions?

3
Certification Overview

• Show off your unique skills!
• Validate your hands-on experience by obtaining a
  certification that matches your current or
  desired job role with an existing or evolving
  technology.
• Start by exploring Specialist certifications,
  designed to validate your expertise using a
  specific technology.
• Then consider earning a Professional series
  certification or becoming a Microsoft-authorized
  trainer.

4
Certified individuals realize the following
benefits

• Increased opportunities on the job. These
  opportunities range from salary and bonus
  increases to project involvement and promotion.
• Increased breadth of knowledge. Certification is
  a catalyst for learning new technologies in a
  structured and comprehensive way.
• Increased value to the organization.
  Organizations with 25 percent or more of their
  staff certified have been shown to deploy
  projects on time and within budget more often,
  rely less on external support, have less
  downtime, and have higher user satisfaction with
  their IT staff.

5
Technology Specialist Exams

• Go into greater depth on technology features,
  functions, and how-to skills than previous exams.
  
• Are targeted to a specific technology so that you
  can demonstrate your expertise in that area.
• A Microsoft Certified Technology Specialist
  (MCTS) is consistently capable of implementing,
  building, troubleshooting, and debugging a
  particular technology.
• The Technology Specialist has the depth of skills
  to fully support the technology.

6
Professional Exams

• Focus on technology job-role skillsfor example,
  deployment, planning, and project management
  skills.
• Candidates should have direct, hands-on
  experience with a technology and job role before
  taking these exams.
• A Microsoft Certified IT Professional (MCITP) or
  a Microsoft Certified Professional Developer
  (MCPD) are consistently and fully capable of
  deploying, building, designing, optimizing, and
  operating technologies for a particular job role.
  
• They have demonstrated the comprehensive skills
  that are required to perform the job
  successfully, and they must remain current in
  best practices and technologies.

7
SS2005 MCITP Roadmap

• Database Developer
• Database Administrator
• Business Intelligence Developer

8
SS2005 MCITP Roadmap (cont)
70-431 TS Microsoft SQL Server 2005
Implementation and Maintenance
SQL Server 2005
70-441 PRO Designing Database Solutions by
Using Microsoft SQL Server 2005
70-442 PRO Designing and Optimizing Data Access
by Using Microsoft SQL Server 2005
DatabaseDeveloper
9
SS2005 MCITP Roadmap (cont)
70-431 TS Microsoft SQL Server 2005
Implementation and Maintenance
SQL Server 2005
70-443 PRO Designing a Database Server
Infrastructure by Using Microsoft SQL Server 2005
70-444 PRO Optimizing and Maintaining a
Database Administration Solution by Using
Microsoft SQL Server 2005
DatabaseAdministrator
10
SS2005 MCITP Roadmap (cont)
70-445 TS Microsoft SQL Server 2005 Business
Intelligence Implementation and Maintenance
SQL Server 2005 Business Intelligence
70-446 PRO Designing a Business Intelligence
Infrastructure by Using Microsoft SQL Server 2005
Business Intelligence Developer
11
QA

• http//www.geekzone.co.nz/JamesHip/
• http//www.microsoft.com/learning/mcpexams/