Microsoft SQL Server 2012 Certifications and TrainingMicrosoft Learning

Agenda

MCSA: SQL Server 2012

MCSE: Business Intelligence

MCSE: Data Platform

Certifications

Value of Certification

Recognition

DifferentiationEmployability

Changes to the Certifications and Exams

Deeper Skill Set

Certification Requirements

Broader Skill Set

Recertification

Relevance Rigor

Hiring Manager

New Technical Certification Names

Consistency across the stack

Value of certification

Level 2 is the destination

Master

Expert

Associate

Microsoft Certified Solutions Master

(MCSM)

Microsoft Certified Solutions

Expert (MCSE)

Microsoft Certified Solutions Associate

(MCSA)

Microsoft Certified Solutions Developer

(MCSD) Easy to communicate

Brand recognition

MCSA: SQL Server 2012

MCSE: Data Platform

Recertification

SQL Server 2012 Certification paths

Destination

Master

Expert

Associate

AdministeringDatabases(Exam 462)

Implementing a Data

Warehouse(Exam 463)

Querying (Exam 461)

Designing Database Solutions

(Exam 465)

Developing Databases(Exam 464)

MCSE: Business IntelligenceRecertification

Implementing Data Models and

Reports(Exam 466)

Designing Business

Intelligence Solutions

(Exam 467)

MCSM: SQL Server

MCA: SQL Server

MCSM: Business Intelligence

MCSA: SQL Server 2012Show that you

have a minimum set of skills to hit

the ground running.

Exam 461: Querying Microsoft SQL Server 2012

Exam 70-462: Administering a Microsoft SQL Server 2012 Database

Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012

+

+Develop and maintain the next wave of mission critical environments and breakthrough insights.

Microsoft Certified Solutions Associate: SQL Server 2012

=

MCSE: Business IntelligenceShowcase your expert skills at developing and deploying rich

business intelligence

solutions.

Exam 466: Implementing Data Models and Reports with SQL Server 2012

Exam 467: Designing Business Intelligence Solutions with SQL Server 2012

+

+Deliver more data to more

people across the

organization.

Microsoft Certified Solutions Expert: Business Intelligence

=

Microsoft Certified Solutions Associate: SQL Server 2012

MCSE: Data PlatformDemonstrate

your expertise at building enterprise-scale data solutions.

Microsoft Certified Solutions Associate: SQL Server 2012

Exam 464: Developing SQL Server 2012 Databases

Exam 465: Designing Database Solutions for SQL Server 2012

+

+Extend your

skills beyond traditional

database capabilities.

Microsoft Certified Solutions Expert: Data Platform

=

Database roles convergence• At least 60% of both DBAs and DBDs were at least minimally proficient at

SSAS and PowerShell.• At least 87% of both DBAs and DBDs were at least minimally proficient at

SSIS, SSRS, and T-SQL.

On which tools are most

DBAs and DBDs

proficient?

• 87% of database developers indicated that they had acted as a database administrator at some point in the past.

• 60% of database developers indicated that they perform database administration tasks as part of their current role, though it is not their primary role.

Do DBDs act as DBAs?

• Backup and restore• Create tables• Installation

Which tasks do a majority of

both DBAs and DBDs perform?

•Performance tuning•Ad-hoc queries•Integration services (data quality)

More challenging item types

Choose All That ApplyCase Studies

Best Answer

Code Review

Extending Matching items

Build ListsDrag & DropActive Screen!Be sure to view the

exam item type demo to see these item types!

Upgrade paths

Upgrade to MCSA: SQL Server 2012

MCTS on SQL Server 2008

Exam – Transition to SQL Srvr 2012 Part 1

+Exam – Transition to SQL Srvr 2012 Part 2

=MCSA: SQL Server 2012

+457 458

NOTE: All Upgrade paths are subject to change until final release.

* Requires recertification

Exam – Transition to SQL Server - 2012 Part 1

+Exam – Transition to SQL Server 2012 - Part 2

=457 458

Upgrade to MCSE: Data Platform

MCITP: Database Developer 2008 or MCITP: Database Administrator 2008

Exam- Transition your MCITP to MCSE: Data Platform

459

Exam – Transition to SQL Server 2012 Part 1

+MCSE: Data Platform*

+457 458

NOTE: All Upgrade paths are subject to change until final release.

* Requires recertification

=Exam – Transition to SQL Server 2012 Part 2

+458

Upgrade to MCSE: Business Intelligence

MCITP: Business Intelligence Developer 2008

Exam- Transition your MCITP to MCSE: BI

460

Exam – Transition to SQL Server 2012 Part 1

+Exam – Transition to SQL Server 2012 Part 2 MCSE: Business Intelligence*

+457 458

NOTE: All Upgrade paths are subject to change until final release.

* Requires recertification

=

SQL Server Instructor-Led Training

Microsoft Official Courseware

Exam 461 Course 10774

Developing Microsoft® SQL Server® 2012 Databases

Implementing a Data Warehouse with Microsoft® SQL Server® 2012

Querying Microsoft® SQL Server® 2012

Administering Microsoft® SQL Server® 2012 Databases

Implementing Data Models and Reports with Microsoft® SQL Server® 2012

Exam 462 Course 10775

Exam 464 Course 10776

Exam 463 Course 10777

Exam 466 Course 10778

Microsoft Press—Exam prepExam 461

Training Kit, Rapid

Review

Developing Microsoft® SQL Server® 2012 Databases

Implementing a Data Warehouse with Microsoft® SQL Server® 2012

Querying Microsoft SQL Server 2012 Administering Microsoft® SQL Server® 2012 Databases

Designing Database Solutions for Microsoft SQL Server 2012

Exam 462

Training Kit,

Rapid Review

Exam 464 Exam Ref

Exam 463 Training Kit,

Rapid Review

Exam 465 Exam Ref

Implementing Data Models and Reports with SQL Server 2012Designing BI Sols with Microsoft SQL Server 2012 Platform

Exam 466 Exam Ref

Exam 467 Exam Ref

Training Kits available mid-August 2012Rapid Reviews available December 2012Exam Refs available March 2013

MS Press—Planned books

Introducing Microsoft SQL Server 2012

Programming Microsoft SQL Server 2012

T-SQL Fundamentals

SQL Server 2012 Step by Step

SQL Server 2012 Administration Inside Out

SQL Server 2012 Integration Services

High Performance T-SQL Using Windows

FunctionsMicrosoft SQL Server 2012 Analysis Services: the BISM

Tabular Model

SQL Server 2012 Reporting Services

SQL Server 2012 Internals

Additional resources

Microsoft.com/learning

Born to Learn

Microsoftvirtualacademy.com

TechNet.com

• SQL Server certifications• SQL Server training• Learning snacks• Free ebook: Introducing Microsoft SQL Server 2012

• SQL Server forums• MCT SQL Server wiki

• Breakthrough Insights using Microsoft SQL Server 2012 - Analysis Services

• Breakthrough Insights using Microsoft SQL Server 2012 - Scalable data warehouse

• Breakthrough Insights using Microsoft SQL Server 2012 - Reporting Services

• Cloud on your terms with Microsoft SQL server 2012: Scale on demand• Download trial version

• Virtual labs• Tutorials• Demos

Questions

© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.