Microsoft Certification and SQL Server 2008 - PowerPoint PPT Presentation

Microsoft certification and sql server 2008 l.jpg
Download
1 / 19

Microsoft Certification and SQL Server 2008. Agenda. SQL Server 2008: what we know now Scenarios, next steps MCA: Database Questions and answers.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

Microsoft Certification and SQL Server 2008

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Microsoft certification and sql server 2008 l.jpg

Microsoft Certification and SQL Server 2008


Agenda l.jpg

Agenda

  • SQL Server 2008: what we know now

  • Scenarios, next steps

  • MCA: Database

  • Questions and answers

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Number of l.jpg

Number of…

  • MCDBA – 149,590

  • MCTS: SQL Server 2005 – 24,939

  • MCITP: Database Administrator – 4,006

  • MCITP: Database Developer – 1,596

  • MCTS: Business Intelligence – 801

  • MCITP: Business Intelligence Developer – 364

  • MCA: Database – 10

Congratulations!

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Sql server 2008 what we know l.jpg

SQL Server 2008: what we know

  • SQL Server 2008 is coming in third quarter of calendar year 2008; certifications will follow

  • Same format as SQL Server 2005

    • Microsoft Certified Technology Specialist (MCTS)

    • Microsoft Certified IT Professional (MCITP)

  • Three MCTS certifications in development

  • Plan for professional series still being finalized

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Design principles l.jpg

Design Principles

Create more targeted, relevant, and cost-effective certifications

Principle

Principle

Principle

Relevant & Simple

Targeted & Flexible

Rigorous & Credible

  • Technology exams verify depth in using technology

  • Professional exams verify relevant job role skills

  • Create certifications that reflect specific job roles

  • Create credentials that allow individuals to identify custom skill sets

  • Advanced testing technology using simulations, case study, and other complex methodologies

  • Create straightforward exams paths that test more completely and accurately

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


New generation framework l.jpg

New Generation Framework

BUSINESS IT SKILLS

Proven ability to deliver business solutions

  • Rigorous entry process

  • Work closely with mentor

  • Culminates in oral review board

  • Recertification required

PROFESSIONAL SKILLS

Proven ability to perform on the job

  • 1-3 exams

  • Technology Specialist Prerequisite

  • Focused on single Job Role

CORE TECHNICAL SKILLS

Proven skills on Microsoft technologies

  • 1-3 exams

  • Certification retires with product support

  • Focused on key product or technology

  • Does not include job role skills

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Mcts overview l.jpg

MCTS Overview

Then

Now

SQL Server 2005

SQL Server 2005 Business Intelligence

SQL Server 2008, Implementation and Maintenance

SQL Server 2008, Database Development

SQL Server 2008, Business Intelligence Development and Maintenance

Moving from two MCTS certifications in SQL Server 2005 to three MCTS certifications in SQL Server 2008—one more way to stand out, better defined skill sets

SQL Server 2005

SQL Server 2008

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Mcts exam roadmap l.jpg

MCTS Exam Roadmap

SQL Server 2008, Business Intelligence Development and Maintenance

SQL Server 2008, Implementation and Maintenance

SQL Server 2008, Database Development

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

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

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

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Mcitp what we do know l.jpg

MCITP—what we do know

  • No change to job-roles defined with SQL Server 2008

    • Database Administrator

    • Database Developer

    • Business Intelligence Developer

  • Your shortest path to will be from SQL Server 2005 MCITP

  • No upgrade path from MCDBA to SQL Server 2008

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


70 448 l.jpg

70-448

SQL Server 2008, Business Intelligence Development and Maintenance

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

  • Configuring, Deploying, Maintaining and Implementing

  • SSIS

  • SSRS

  • SSAS

Tip: Exam 70-448 is the new MCTS exam that is the SQL 2008 counterpart to 70-445 on SQL 2005

Exam availability: estimated August 2008 and localized into 日本語, Francais, Deutsch, Español

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Exam 70 432 l.jpg

Exam 70-432

SQL Server 2008, Implementation and Maintenance

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

  • Installing and Configuring

  • Maintaining SQL Instances

  • Managing Security

  • Maintaining a database

  • Data Management Tasks

  • Monitoring and Troubleshooting

  • Optimizing

  • Implementing High Availability

Tip: Exam 70-431 (from 2005 tracks) has been broken into two exams to again separate DBA and DBD tasks

Exam availability: estimated for August 2008. Localized into 日本語, Francais, Deutsch, Español

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Exam 70 433 l.jpg

Exam 70-433

SQL Server 2008, Database Development

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

  • Design not complete yet

  • T-SQL

  • Connecting to data sources

Tip: Exam 70-431 has been broken into two exams to again separate DBA and DBD tasks

Exam availability: estimated for September 2008 and localized into

日本語, Francais, Deutsch, Español

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Next step guidance l.jpg

Next Step Guidance

I already hold my MCTS/MCITP on SQL Server 2005. What should I do next?

Look for details on our SQL Server 2008 exams—available in next few months—and begin mapping out a learning plan

You have an MCTS on SQL Server 2005

Complete your MCITP track. Your 2005 certifications will hold value for as long as organizations seek those skills. Look for SQL Server 2008 information and upgrade when you’re ready

You are on your way to an MCITP on SQL Server 2005

Watch for announcements about upcoming transition options for SQL Server 2008; work with the 2008 technology as much as you can

You have your MCITP on SQL Server 2005

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Next step guidance14 l.jpg

Next Step Guidance

I’m on the MCDBA certification track, what should I do next?

  • Upgrade your skills to SQL Server 2005, then take advantage of the upcoming transition plans to SQL Server 2008 when appropriate

  • Or, bypass SQL Server 2005 and start your 2008 track planning and studies

You have your MCDBA certification

You can complete your MCDBA certification before March 2009; this certification will not expire. We do not recommend that you begin an MCDBA path today.

You are on your way to an MCDBA certification


Next step guidance15 l.jpg

Next Step Guidance

I’m new to certification, where should I start?

  • If you’re using SQL Server 2005, consider beginning your certification plans on that technology with Exam 70-431 (for database administration or development) or Exam 70-445 (for business intelligence)

  • If you will be working with SQL Server 2008, get to know the technology and look for details—coming soon—on your first exam in the SQL Server 2008 tracks

Just starting out?

Tip: The “Second Shot” offer gives you a free second chance to pass your exam if you fail the first time—available until June 2008

microsoft.com/learning/mcp/offers/secondshot/

Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


Mca database l.jpg

MCA: Database

Mission Statement:

  • Provide top tier training and certification on Microsoft products for building a community of trusted architects who successfully address the most complex customer requirements.

  • Current programs: Messaging, Database (OLTP)

  • In development: Windows Directory

  • Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


    Mca components l.jpg

    MCA Components

    Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


    Program summary l.jpg

    Program Summary

    • Advanced Training – technical only

      • Four weeks in Redmond

      • Instructors are SMEs, Program Managers, MSIT engineers, Industry Experts

      • Hands on labs with enterprise class equipment

      • Focused on Design with deep component level understanding

    • Certification

      • Highly exclusive due to rigor

      • Weekly written tests during training

      • Performance based lab test

      • Review Board (validates technical and non-technical)

    • Community

      • Access to MSIT, Product group, peers, pre-beta software

    • Continued Education

      • Offered twice annually (cost included in program fee)

    • Applications open to:

    • Microsoft Certified Partners

    • Microsoft employees

    Note: This information is a previously recorded presentation and may now be out of date. For the most current information, visit http://www.microsoft.com/learning.


    Slide19 l.jpg

    What’s next?

    • Prep guides coming soon: microsoft.com/learning/exams/70-XXX.mspx

    • SQL 2008 Learning Portal: microsoft.com/learning/sql/2008/default.mspx

    • SQL Server product group: microsoft.com/sql/2008/learning/default.mspx

    • Recording of this presentation: http://blogs.msdn.com/trika

    • Gerry’s blog: http://blogs.msdn.com/gerryo

    • MCA: microsoft.com/learning/mcp/architect/database/default.mspx

    • MCDBA2005: microsoft.com/learning/mcp/mcdba/upgrade/default.mspx

    • MCTS: SQL2005: microsoft.com/learning/mcp/mcts/sql/default.mspx

    • Beta exam info: microsoft.com/learning/mcpexams/status/beta.mspx

    Questions and Answers


  • Login