SQL Server 2008 Technical Certification RoadmapTrainCanada.com

Microsoft Certification

Microsoft Certifications feature succinct paths to help you become Microsoft Certified.

Different series highlight technology expertise by job function.

Provides a clear, concise way to highlight your specific skill set and validates your abilities at every stage of your professional development.

Technical Certification path

ASSOCIATEMicrosoft Technology

TECHNOLOGY SPECIALISTMicrosoft Certified

IT PROFESSIONAL / PROFESSIONAL DEVELOPER

Microsoft Certified

MASTERMicrosoft Certified

ARCHITECTMicrosoft Certified

Web based Academic classroom Validates foundational knowledge

(what) Student Certification

Computer Based exams Prometric Testing Centers

Worldwide Validates job ready skills (how)

Computer Based exams Prometric Testing Centers Worldwide Validates job role skills (why & when)

Computer Based and Hands –on Exams Select Prometric Testing Centers Worldwide Validates expert level skills

Board Review Validates expert level skills

within a specific technology Trusted Advisor/Leader/Consultant

ASSOCIATEMicrosoft Technology

Microsoft Technology Associate (MTA) certifications validate the fundamental knowledge essential to prepare students for advanced technology classes and successful careers in IT.

Associate

TECHNOLOGY SPECIALISTMicrosoft Certified

Microsoft Technology Specialist Series (MCTS) certifications are designed to demonstrate in-depth knowledge of a key product or technology, validating the ability to implement, build, troubleshoot, and debug a particular Microsoft technology

IT PROFESSIONAL / PROFESSIONAL DEVELOPER

Microsoft CertifiedMicrosoft Professional certifications, which include the Microsoft Certified IT Professional (MCITP) and Microsoft Certified Professional Developer (MCPD) certifications, are designed to demonstrate a comprehensive set of job-related skills, such as project management, system design, operations management, and planning.

MASTERMicrosoft Certified

Microsoft Certified Master (MCM) certifications demonstrate the in-depth technical skills of senior IT experts who have demonstrated mastery of a core Microsoft Server technology through rigorous training and the passing of knowledge and lab-based certification exams.

ARCHITECTMicrosoft Certified

Microsoft Certified Architect (MCA) certifications are designed to help validate your skills as a qualified professional in IT architecture.

Why Certify?Improve career opportunities

Organizations take certification into consideration when hiring candidates and tend to view certification as a more objective measure of a candidate’s skills than self reported skills and competency *Microsoft certification can lead to more earning power with average salaries for Microsoft Certified Professionals showing a notable increase over the previous year.** The added market value that a certification can be as high

as 30% - 40%. The average salary uplift reported across all certifications in the study was in the 5% - 11% range.*

Why Certify?

Add value and gain recognitionIndustry recognition of technical proficiency and proof of technical leadership With every certification achieved, individuals add value to organization through increased productivity and the ability to deploy technologies effectively.Earn respected place within the organization as a specialist in roles or technologies

Why Certify?Stay ahead - take advantage of career and technical tools *

Exclusive technical information through Microsoft Product Support Knowledge baseMarket technical talents to employers looking for certified professionals in the MCP Career CenterManage your skills development path using the Microsoft Certification Planner

SQL Server 2008 Overview

ASSOCIATEMicrosoft Technology

TECHNOLOGY SPECIALISTMicrosoft Certified

IT PROFESSIONAL / PROFESSIONAL DEVELOPER

Microsoft Certified

MASTERMicrosoft Certified

ARCHITECTMicrosoft Certified

Microsoft Certified Architect (MCA)1. SQL Server 2008

Microsoft Certified Master (MCM)1. SQL Server 2008

Microsoft Certified IT Professional (MCITP)1. Database Administrator 20082. Database Developer 20083. Business Intelligence Developer 2008

Microsoft Certified Technology Specialist (MCTS)1. SQL Server 2008, Implementation and Maintenance2. SQL Server 2008, Database Development3. SQL Server 2008, Business Intelligence Development and

Maintenance

Microsoft Certified Technical Associate (MTA)1. Database Fundamentals

Exam 98-364: Database Fundamentals

Database Fundamentals

SQL Server 2008 - MTA RequirementsTe

chno

logy

Ass

ocia

te

SQL Server 2008, Database Development

Exam 70-433: TS: Microsoft SQL Server 2008, Database Development

Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance

SQL Server 2008, Implementation and Maintenance

SQL Server 2008 – TS Requirements

SQL Server 2008, Business Intelligence Development and Maintenance

Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Tech

nolo

gy S

peci

alis

t

Exam 70-453: Upgrade: Transition your MCITP SQL Server 2005 DBA to Administrator Skills to MCITP SQL Server 2008OR

 Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008and

Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance

Database Developer 2008

Database Administrator 2008

SQL Server 2008 – IT Pro RequirementsIT

Pro

Exam 70-454: Upgrade: Transition your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD OR

 Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008and

Exam 70-433: TS: Microsoft SQL Server 2008, Database Development

Exam 70-455: Upgrade: Transition your MCITP SQL Server 2005 BI Developer Skills to MCITP SQL Server 2008 BI Developer OR Exam 70-452: PRO: SQL Server 2008, Business Intelligence Development and MaintenanceandExam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Developmentand Maintenance

Business Intelligence Developer 2008

SQL Server 2008 – IT Pro RequirementsIT

Pro

Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008and

Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance}OR

{Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005and

Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005and

Exam 70-431: TS: Microsoft SQL Server 2005, Implementation and Maintenance} AND

 {Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008and

Exam 70-433: TS: Microsoft SQL Server 2008, Database Development}OR

{Exam 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

SQL Server 2008 - MCM RequirementsM

aste

r Microsoft Certified Master

MCM: SQL Server 2008ANDPass board certification. Additional information here.

Microsoft Certified Architect

SQL Server 2008 - MCA RequirementsAr

chite

ct

Recommended Learning Resources: MCTS Exams

Certification Exams Microsoft Official Courses Microsoft Press Books Microsoft E-LearningExam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance

Course 6231: Maintaining a Microsoft SQL Server 2008 Database (5 days)andCourse 6232: Implementing a Microsoft SQL Server 2008 Database (5 days, partial coverage)

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008– Implementation and MaintenanceISBN: 9780735626058

Collection 6369: Implementing and Maintaining a Microsoft SQLServer 2008 Database (16 hours)andCollection 2778: Writing Queries Using Microsoft SQL Server2008 Transact-SQL (18 hours)

Exam 70-433: TS: Microsoft SQL Server 2008, Database Development

Course 6232: Implementing a Microsoft SQL Server 2008 Database (5 days)andCourse 2778: Writing Queries Using Microsoft SQL Server 2008 andTransact-SQL (3 days)Course 6231: Maintaining a Microsoft SQL Server 2008 Database (5 days, partial coverage)

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008– Database DevelopmentISBN: 9780735626393

Collection 6370: SQL Server 2008 Database Development(20 hours)andCollection 2778: Writing Queries Using Microsoft SQL Server2008 Transact-SQL (18 hours)

Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Developmentand Maintenance

Course 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services (3 days)andCourse 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (3 days)andCourse 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 days)

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008– Business IntelligenceDevelopment and MaintenanceISBN: 9780735626362

Collection 6233: Implementing and Maintaining BusinessIntelligence in SQL 2008: Integration Services, Reporting Servicesand Analysis Services (24 hours)

• For more information, visit:www.microsoft.com/learning/career

• Microsoft Learningwww.microsoft.com/learning