Microsoft SQL Server 2012 Certifications and Training
Agenda
http://www.pass4sureexam.co/70-461.html
http://www.pass4sureexam.co/70-461.html
Changes to the Certifications and Exams Relevance
Broader Skill Set
Rigor
Recertification http://www.pass4sureexam.co/70-461.html
Certification Requirements
Deeper Skill Set
SQL Server 2012 Certification paths MCA: SQL Server Master
MCSM: SQL Server
MCSM: Business Intelligence
MCSE: Data Platform
MCSE: Business Intelligence Recertification
Recertification
Expert
Developing Databases (Exam 464)
Designing Database Solutions (Exam 465)
Implementing Data Models and Reports (Exam 466)
Designing Business Intelligence Solutions (Exam 467)
MCSA: SQL Server 2012 Querying (Exam 461)
Associate
Administering Databases (Exam 462)
Implementing a Data Warehouse (Exam 463)
MCSA: SQL Server 2012 Show that you have a minimum set of skills to hit the ground running.
Microsoft Certified Solutions Associate: SQL Server 2012
= Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012
+
Develop and maintain the next wave of mission critical environments and breakthrough insights.
Exam 70-462: Administering a Microsoft SQL Server 2012 Database
+
Exam 461: Querying Microsoft SQL Server 2012
MCSE: Business Intelligence Showcase your expert skills at developing and deploying rich business intelligence solutions.
Deliver more data to more people across the organization.
Microsoft Certified Solutions Expert: Business Intelligence
=
Exam 467: Designing Business Intelligence Solutions with SQL Server 2012
+
Exam 466: Implementing Data Models and Reports with SQL Server 2012
+
Microsoft Certified Solutions Associate: SQL Server 2012
MCSE: Data Platform Demonstrate your expertise at building enterprise-scale data solutions.
Microsoft Certified Solutions Expert: Data Platform
=
Exam 465: Designing Database Solutions for SQL Server 2012
+ Extend your skills beyond traditional database capabilities.
Exam 464: Developing SQL Server 2012 Databases
+ Microsoft Certified Solutions Associate: SQL Server 2012
Database roles convergence On which tools are most DBAs and DBDs proficient?
• 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.
Do DBDs act as DBAs?
• 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.
Which tasks do a majority of both DBAs and DBDs perform?
• Backup and restore • Create tables • Installation
•Performance tuning •Ad-hoc queries •Integration services (data quality)
http://www.pass4sureexam.co/70-461.html
Recertification ensures up-to-date skills
Proves latest skills in the solution area
Recertification
Protects your cert from being devalued
Replaces upgrade at expert level
MCSEs will need In most cases, Transcript will to recertify every requirement will be show upcoming three years one exam inactive date
http://www.pass4sureexam.co/70-461.html
Recertifying also earns you the new MCSA
Expert-level cert names not versioned
More challenging item types
demo
Extending Matching items
Code Review
Case Studies
Choose All That Apply
Active Screen
Drag & Drop
Build Lists
Best Answer
exam item type
Upgrade paths
Upgrade to MCSE: Data Platform
MCITP: Database Developer 2008 or MCITP: Database Administrator 2008
Exam – Transition to SQL Server 2012 Part 1
Exam – Transition to SQL Server 2012 Part 2
Exam- Transition your MCITP to MCSE: Data Platform
MCSE: Data Platform*
NOTE: All Upgrade paths are subject to change until final release.
* Requires recertification
http://www.pass4sureexam.co/70-461.html
Upgrade to MCSE: Business Intelligence
MCITP: Business Intelligence Developer 2008
Exam – Transition to SQL Server 2012 Part 1
Exam – Transition to SQL Server 2012 Part 2
Exam- Transition your MCITP to MCSE: BI
MCSE: Business Intelligence*
NOTE: All Upgrade paths are subject to change until final release.
* Requires recertification
http://www.pass4sureexam.co/70-461.html
Upgrade to MCSA: SQL Server 2012
MCTS on SQL Server 2008
Exam Exam––Transition Transitionto toSQL SQL Srvr Server 2012 - 2012 Part Part 1 1
Exam Exam––Transition Transitionto toSQL SQL Srvr Server 2012 2012 Part- Part 2 2
MCSA: SQL Server 2012
NOTE: All Upgrade paths are subject to change until final release.
* Requires recertification
http://www.pass4sureexam.co/70-461.html
SQL Server InstructorLed Training
Microsoft Official Courseware Querying Microsoft® SQL Server® 2012
Course 10774
Exam 461
Administering Microsoft® SQL Server® 2012 Databases
Course 10775
Exam 462
Developing Microsoft® SQL Server® 2012 Databases
Course 10776
Exam 464
Implementing a Data Warehouse with Microsoft® SQL Server® 2012
Course 10777
Exam 463
Implementing Data Models and Reports with Microsoft® SQL Server® 2012
Course 10778
Exam 466
Microsoft Press—Exam prep Querying Microsoft SQL Server 2012 Administering Microsoft® SQL Server® 2012 Databases Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Developing Microsoft® SQL Server® 2012 Databases Designing Database Solutions for Microsoft SQL Server 2012 Implementing Data Models and Reports with SQL Server 2012 Designing BI Sols with Microsoft SQL Server 2012 Platform Training Kits available mid-August 2012 Rapid Reviews available December 2012 Exam Refs available March 2013
Training Kit, Rapid Review Training Kit, Rapid Review Training Kit, Rapid Review
Exam 462
Exam Ref
Exam 464
Exam Ref
Exam 465
Exam Ref
Exam 466
Exam Ref
Exam 467
Exam 461
Exam 463
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
Frequently asked questions Question
Answer
Why did you change the certification names?
The names were changed to better reflect the experience, knowledge, and skills that IT Professionals and Developers need to build and manage technology solutions that may include multiple technologies, whether on-premise or in the cloud.
When will exams be available to upgrade from SQL Server 2008?
Upgrade exams will be released by August 2012.
My transcript shows that I earned the Microsoft Certified Solutions Associate: SQL Server 2008 certification. How did I get it?
If you passed Exams 70-432 and 70-448, or you have achieved the MCTS: Microsoft SQL Server 2008, Implementation and Maintenance and the MCTS: SQL Server 2008, Business Intelligence Development and Maintenance certifications, you automatically earn the Microsoft Certified Solutions Associate (MCSA) certification on SQL Server 2008.
How do these changes impact my existing Microsoft Certifications?
The existing MCTS, MCITP, and MCPD Certifications are currently valuable in the market and will remain valuable as long as companies are using the technology covered in your certification.
How long will I be able to earn an MCITP or MCTS Certification on SQL Server 2008?
After April 2013, you will no longer be able to achieve an MCTS or MCITP certification on SQL Server 2008. However, the MCSA: SQL Server 2008 will still be available to earn.
What happens if I pass a single exam?
When you pass a single exam, you become a member of the Microsoft Certification Program. You can share your transcript with others to prove that you passed that exam and show your progress towards a specific certification.
http://www.pass4sureexam.co/70-461.html
More frequently asked questions Question
Answer
What is the recertification requirement?
To ensure that our certifications remain a meaningful and valuable indicator of candidate’s skills, Microsoft Certified Solutions Expert (MCSE) certifications will require recertification every three years.
Why is this recertification requirement being implemented?
Recertification ensures that Microsoft Certifications remain a meaningful and valuable indicator of candidate’s skills. Recertification provides assurance to hiring managers and other stakeholders that certified candidates have demonstrated continued competence even as the technology has changed based on service packs, revisions, and new product version releases.
Will MCSA certifications require recertification also?
The recertification requirement does not apply to Microsoft Certified Solutions Associate (MCSA) certifications.
Why did you raise the expectations for minimum skills?
We raised the minimum expectations in order to recognize and validate the full set of skills that a candidate would need to successfully work with across a technology solution and included topics relevant to working with solutions in the cloud. By increasing the minimum expectations and the skills validated, individuals will be more successful in working with Microsoft technologies and better able to satisfy the needs of the organization.
How did you make the exams more challenging?
There are many aspects to a candidate's perception of how challenging an exam is. We made changes to our certification program to address each of those aspects, including setting the bar higher for minimum experience that we expect from successful candidates, validating more difficult skills, using more challenging question types, and implementing security enhancements in our exams and test centers.
MCSA: SQL Server 2008 Microsoft Certified Solutions Associate: SQL Server 2008
The MCSA: SQL Server 2008 certification shows that you have a minimum set of skills to hit the ground running.
= Exam 70-448: Implementing Data Warehouses with Microsoft SQL Server 2012
+
Demonstrate your essential skills on SQL Server 2008 by earning the MCSA: SQL Server 2008 certification.
Exam 70-432: Administering a Microsoft SQL Server 2012 Database
Note: MCSA: SQL Server 2008 certification does not count towards the MCSE: Data Platform or MCSE: Business Intelligence certifications. However, candidates can upgrade from MCSA: SQL Server 2008 to MCSA: SQL Server 2012 by taking two exams.
Reinvented for the Cloud Microsoft has reinvented its certifications by building cloud related skills validation into the industry’s most recognized and respected certification program. Microsoft Certifications remains the method by which IT Pros and Developers stand out from their peers and for employers to recognize candidates/employees who have the skills required to be productive. To ensure Microsoft Certifications remain relevant, they now validate a broader and deeper set of cloud skills and experience across a technology solution.
IT Pro & Developer benefits Get Recognized
Get hired
Get recognized by peers and hiring managers. Microsoft Certification distinguishes the ability of professionals to deploy, design, optimize and operate technologies for critical IT roles.
Get a job building the future. Microsoft ensures its certifications are on the cuttingedge of technology and are valued by businesses, helping professionals get hired in today’s highly competitive market.
A 2011 study showed 86% of hiring managers indicate IT certifications are a high or medium priority during the candidate evaluation process – CompTIA Feb, 2011 Press Release
In a survey of 700 IT professionals, 60% said certification led to a new job – Network World, 11/14/2011
Hiring Manager benefits Get qualified candidates
Get verification employee knowledge is current
.
A certification research report, 64 % of IT hiring managers rate certifications as having extremely high or high value in validating the skills and expertise of job candidates– Channelinsider.com, 2011-10-19
A certification research report, 89% of IT hiring managers say that IT certifications help confirm subject matter knowledge and expertise– Channelinsider.com, 2011-10-19
New Technical Certification Names Microsoft Certified Solutions Master Master (MCSM) Microsoft Microsoft Certified Certified Solutions Solutions Expert Developer Expert (MCSE) (MCSD)
Microsoft Certified Solutions Associate (MCSA) Associate
Hiring Manager
Easy to communicate
Level 2 is the destination
Brand recognition
MS Press—Planned books
Virtual Machine Plan Hardware Level 6 Minimum level – no less than 8GB RAM, more is better Windows Server 2008 R2 SP1 host machines Base 11A (WS2008R2 + HyperV SP1) MIA-DC (domain controller, 512MB) MIA-SQL1 (SQL 2012, no BI components) Used by 10774, 10775, 10776
MIA-SQLBI (SQL 2012, all BI components, Sharepoint) Used by 10777, 10778
Internet access for SQL Azure Introducing the TMG VM‌
MSL Hardware Level 6 • Intel 64bit Virtualization Technology (Intel VT) or AMD Virtualization
• • • • • • •
(AMD-V) processor (2.8 GHz dual core or better recommended) Dual 120 GB hard disks 7200 RPM SATA or better* 4 GB RAM expandable to 8GB or higher DVD drive Network adapter Super VGA (SVGA) 17-inch monitor Microsoft Mouse or compatible pointing device Sound card with amplified speakers
SQL Azure SQL Azure: an integrated story for off-premise data Options for existing SQL training In SQL 2012 Courseware Design approach Labs
Student Azure Accounts
Custom Deliveries Many diverse secondary audiences Modules & Labs designed for modularity Examples T-SQL for Report Developers Four day: first four days of 10774 + 10778 module 3
Data Quality in SQL Server 2012 One day: 10777 modules 7, 9, 10
Building Reports and Visualizations with SQL Server 2012 Two day: 10778 modules 2, 3, 10, 11, 13
Student Azure Accounts
10774: Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL • • • • • • • • • •
Module 1: Introduction to SQL Server 2012 Module 2: Introduction to Transact SQL Querying Module 3: Writing SELECT Statements Module 4: Combining Data from Multiple Tables Module 5: Filtering and Sorting Data Module 6: Working with SQL Server Data Types Module 7: Using Built-In Functions Module 8: Grouping and Aggregating Data Module 9: Using Subqueries Module 10: Using Table Expressions
• Module 11: Use Set Operators • Module 12: Using Window Ranking, • • • • • • • •
Offset and Aggregate Functions Module 13: Pivoting and Grouping Sets Module 14: Writing Specialized Queries Module 15: Executing Stored Procedures Module 16: Programming with T-SQL Module 17: Implementing Error Handling Module 18: Implementing Transactions Module 19: Querying SQL Server Metadata Module 20: Improving Query Performance
10775: Course 10775A: Administering a Microsoft® SQL Server® 2012 Database • • • • • • • • • •
Module 1: Introduction to SQL Server 2012 and its Toolset Module 2: Preparing Systems for SQL Server 2012 Module 3: Installing and Configuring SQL Server 2012 Module 4: Working with Databases Module 5: Understanding SQL Server 2012 Recovery Models Module 6: Backup of SQL Server 2012 Databases Module 7: Restoring SQL Server 2012 Databases Module 8: Importing and Exporting Data Module 9: Authenticating and Authorizing Users Module 10: Assigning Server and Database Roles
• • • • •
• • • • •
Module 11: Authorizing Users to Access Resources Module 12: Auditing SQL Server Environments Module 13: Automating SQL Server 2012 Management Module 14: Configuring Security for SQL Server Agent Module 15: Monitoring SQL Server 2012 with Alerts and Notifications Module 16: Performing Ongoing Database Maintenance Module 17: Tracing Access to SQL Server 2012 Module 18: Monitoring SQL Server 2012 Module 19: Managing Multiple Servers Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
10776: Developing a Microsoft SQL Server 2012 Database •
• • • • • • • •
Module 1: Introduction to SQL Server 2012 and its Toolset Module 2: Working with Data Types Module 3: Designing and Implementing Tables Module 4: Ensuring Data Integrity through Constraints Module 5: Planning for SQL Server 2012 Indexing Module 6: Implementing Table Structures in SQL Server 2012 Module 7: Reading SQL Server 2012 Execution Plans Module 8: Improving Performance through NonClustered Indexes Module 9: Designing and Implementing Views Module 10: Designing and Implementing Stored Procedures
• •
• • • • • • • •
Module 11: Merging Data and Passing Tables Module 12: Designing and Implementing UserDefined Functions Module 13: Creating Highly Concurrent SQL Server 2012 Applications Module 14: Handling Errors in T-SQL Code Module 15: Responding to Data Manipulation via Triggers Module 16: Implementing Managed Code in SQL Server 2012 Module 17: Storing XML Data in SQL Server 2012 Module 18: Querying XML Data in SQL Server 2012 Module 19: Working with SQL Server 2012 Spatial Data Module 20: Working with Full-Text Indexes and Queries
10777: Implementing a Data Warehouse with Microsoft SQL Server 2012 • • • • • • • • • • • • •
Module 1: Introduction to Data Warehouse Concepts Module 2: Data Warehouse Hardware Considerations Module 3: Designing and Implementing a Data Warehouse Module 4: Creating an ETL Solution with SSIS Module 5: Implementing Control Flow in an SSIS Package Module 6: Debugging and Troubleshooting SSIS Packages Module 7: Implementing an Incremental ETL Process Module 8: Incorporating Data from the Cloud in a Data Warehouse Module 9: Enforcing Data Quality Module 10: Using Master Data Services Module 11: Extending SSIS Module 12: Deploying and Configuring SSIS Packages Module 13: Consuming Data in a Data Warehouse
10778: Implementing Data Models and Reports with Microsoft SQL Server 2012 • • • • • • • • • • • • • •
Module 1: Overview of Reporting and Data Modeling Module 2: Implementing Reports with Reporting Services Module 3: Supporting Self-Service Reporting Module 4: Managing a Reporting Infrastructure Module 5: Creating Multidimensional Databases Module 6: Working with Cubes and Dimensions Module 7: Working with Measures and Measure Groups Module 8: Introduction to MDX Module 9: Customizing Cube Functionality Module 10: Implementing a PowerPivot for Excel Workbook Module 11: Introduction to Data Analysis Expression (DAX) Module 12: Implementing a Tabular Database Module 13: Creating Data Visualizations With Crescent Module 14: Performing Predictive Analysis with Data Mining