Microsoft Certification for SQL Server 2005 • James HippoliteSenior .NET DeveloperTelecom New Zealand Limited
Agenda • Certification Overview • Certification Benefits • Technology Specialist Exams • Professional Exams • SS2005 MC:ITP Roadmap • Database Developer • Database Administrator • Business Intelligence Developer • Questions?
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.
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.
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.
Professional Exams • Focus on technology job-role skills—for 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.
SS2005 MCITP Roadmap • Database Developer • Database Administrator • Business Intelligence Developer
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
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
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
Q&A • http://www.geekzone.co.nz/JamesHip/ • http://www.microsoft.com/learning/mcpexams/