Get the Right SQL Certifications Pete Harris Chris Testa-O’Neill Christian Bolton Your Agenda! Study and pass your exams Let’s Start with a Poll! Rise Above the Competition of Hiring Managers consider employee certification as a criterion for hiring of IT Leaders indicate it is challenging for IT organizations to secure the necessary skills 60% of IT Cert holders say a certification led to a new job Sources: MCP Program Satisfaction Study 2010; TEKsystems report, Oct 2011; Network World, November 14, 2011; Robert Half Technology Salary Guide, 2011 of IT holders said a cert led to a salary boost or bonus Certification Integrity • Redefine certification audience at a higher level • Increase differentiation between Pro and TS levels • Close the Masters gap • Enhanced test center standards + monitoring • Enhanced exam security • Post-exam analysis and monitoring • Increase difficulty and relevance of skills tested • Include more challenging item types Design Develop Defend Deliver • Improved exam UI • Improved accessibility What Customers Are Saying: “It was more in-depth and challenging than I'd heard and I felt like I'd accomplished a great deal by taking it.” “After completing the exam I felt as though I had accomplished something rather difficult.” “The exam was more rigorous and difficult than I expected, which is a good thing. Passing the exam should mean something, and a tough exam ensures that.” “this was a hard exam, and shows that this certificate will retain its ability to ensure quality recipients.” “It was a well structured exam and I felt proud to pass it as it was not easy.” “Very difficult, which is awesome.” “As it was not an easy exam to pass it shows that the standard of qualification will be upheld.” “It was harder than I expected. I like that though. It means not everyone can attain the certification without really knowing the material.” “Harder questions than expected. (Which is good, because in this way becoming certified actually means something).” “It was very challenging, and therefore rewarding when I passed it.” 20 Years of Certification Microsoft Learning on Facebook Certification Approach Review prep guide Hands on experience • Target audience • Objective domain • Resources • Training • Study groups • Blogs, articles, user groups, Conferences Fill in skills gaps More handson • On the job • Trial versions, betas • TechNet/MSDN labs Choosing a Certification SQL Server 2008 MCTS Exams TS: Microsoft SQL Server 2008, Implementation and Maintenance Exam 70 - 432 TS: Microsoft SQL Server 2008, Database Development Exam 70 - 433 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Exam 70 - 448 SQL Server 2008 MCITP Exams PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008 Exam 70 - 450 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 Exam 70 - 451 PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 Exam 70 - 452 SQL Server MCM, MCA & Maestro Content Planning SQL Business Group TAP customers, MVPs Partners Learning Advisory Councils, Trainers Customers Focus groups & surveys Audience Overview Data Platform Business Intelligence SQL 2012 Exams 7 Exams English, French, German, Japanese, Brazilian Portuguese, Chinese Simplified 2 pro-level certification paths Common skills + Specialty skills Data Platform & BI Upgrade from 2008 certs Re-certification required (3 years) Data Platform Exams Professional Level: Data Platform Exam 70-465: Designing Database Solutions with Microsoft® SQL Server® 2012 Exam 70-464: Developing Microsoft SQL Server 2012 Databases Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012 Exam 70-462: Administering a Microsoft SQL Server 2012 Database Exam 70-461: Querying Microsoft SQL Server Business Intelligence Exams Professional Level: Business Intelligence Exam 70-467: Designing Business Intelligence Solutions with Microsoft® SQL Server® 2012 Platform Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012 Exam 70-462: Administering a Microsoft SQL Server 2012 Database Exam 70-461: Querying Microsoft SQL Server Microsoft Official Courseware Course Number Related Exam Title 10774 70-461 Querying Microsoft® SQL Server® 2012 10775 70-462 Administering Microsoft® SQL Server® 2012 Databases 10776 70-464 Developing Microsoft® SQL Server® 2012 Databases 10777 70-463 Implementing a Data Warehouse with Microsoft® SQL Server® 2012 10778 70-466 Implementing Data Models and Reports with Microsoft® SQL Server® 2012 More SQL Server 2012 Content from MS Learning 23 MS Press Books 10 exam specific titles Free eBook (Introducing SQL Server 2012) 3 Snacks SQL Server 2012: Mission Critical Confidence SQL Server 2012: Breakthrough Insight SQL Server 2012: Cloud On Your Terms Release Timing SQL Server Launch = March 7, 2012 Beta exams = mid-March Certification announcement = mid-April MOC release = May 25 Exams release = mid-June Questions? Pete Harris [email protected] @SQLPete Chris Testa-O’Neill [email protected] @ctesta_oneill Christian Bolton [email protected] @christianbolton Resources • • • • • • SQL Server exams & prep: http://www.microsoft.com/learning/en/us/training/sql-server.aspx Microsoft Learning: http://www.microsoft.com/learning Microsoft Learning community blog: http://borntolearn.mslearn.net/ Register for an exam at Prometric: http://www.prometric.com/Microsoft/default.htm Community resources: http://www.microsoft.com/learning/community/default.mspx Regional Service Center: http://www.microsoft.com/learning/support/worldsites.mspx THANK YOU!