The Four new SQL MCSA certifications coming out this fall have had a last minute name change. http://bit.ly/2q8lWPj
It is time for another SQL Server User Group. This time it is for Chattanooga, Tennessee. I’m getting close to spelling that correctly. I have attached my most recent presentation on SQL Server certifications with the changes that were announced in April. I hope everyone has a great time.
Just when I thought I had all the certifications figured out, Microsoft announced yesterday the addition of the MCSE: Business Applications (focusing on Dynamics 365) which includes two new supporting MCSA paths – MCSA: Dynamics 365 and MCSA: Dynamics 365 for Operations. Additionally, they’ve added the new MCSA: Data Science, which puts you on a path to earn an MCSE: Data Management & Analytics certification. Check out this new pdf that clearly outlines the requirements for each certification and the electives that can be taken to renew each MCSE annually. Bonus information on the pdf download is some other unannounced MCSA certifications including Cloud Database Development, Big Data Engineering, and BI reporting.
There is a new Know it. Prove it challenge over at the Microsoft Virtual Academy. The challenges are open to developers, data pros, and students, all of whom can pick up valuable skills quickly through video tutorials, assessments, and more.Accept the Know it. Prove it. challenge, earn unique badges, and display them proudly. The challenges run from April 18 through May 17, 2017.
Passed two exams this week during the MCT Summit. I started with the 70-740: Installation, Storage, & Compute with Windows Server 2016. This was the one I studied for on the train, because I thought I was a little rusty on Virtual Machines and Clustering. But it was the simple stuff like REFS and Data Duplication that was tripping me up during the exam. Today, I took the third and final exam needed for the MCSA: Windows Server 2016 certification. Which of course is the 70-741: Networking with Windows Server 2016 exam. Again, I breezed through the difficult parts of the exam only to be hung up on a silly subnetting question. It was like I forgot how to do math. But a few extra minutes double checking my work and I knew I had it right. So that is 9 exams and 9 certifications in the last 6 months. I think I’m going to take the rest of the year off from Microsoft exams.
Tomorrow night, I will be speaking at the Indianapolis SQL Server User Group on “How to get Microsoft Certified”. The meeting starts at 6:00pm at Apparatus HQ 1401 North Meridian St. Indianapolis, IN 46202. More details at http://indiana.pass.org
Last September I took the BETA exams for 70-761: Querying Data with Transact-SQL and 70-762: Developing SQL Databases. Well it looks like I passed them, because today I received an email saying I have earned my MCSA: SQL Server 2016 Database Development. I always like when I pick up a new certification, but it’s really cool to wake up and earn one you were not expecting. I am just now sure to count it towards my 2016 goals or 2017.
Attached is my presentation on SQL Server Certification that will be presented at SQL Saturday Atlanta: BI Edition this weekend. I have also provided useful links in getting certified on SQL Server.
- Mastering Microsoft Certification Exam Prep
- Microsoft Learning – SQL Server Certifications
- Larry Kaye announces New Streamlined Certifications
- MTA – Exam 98-364: Database Fundamentals
- Why get Microsoft Certified
- Online Proctored Exams
- Microsoft Certification Study Groups
- Channel 9 SQL Server videos
- Microsoft Exam Question Types
To help you reach your certification goals, Microsoft Learning is introducing Exam Replay with two purchase options: Exam Replay – An Exam Replay is one exam plus a retake of the same exam. Buy these at the same time to give yourself an extra chance at success. Exam Replay + Practice Test – Pull out all the stops and give yourself every advantage. Buy an exam, a retake, plus a practice test together! The practice test is accessible online and valid for 30 days from activation, so you’ll have plenty of time to prepare. To take advantage of these Exam Replay options, visit the special offers page today.
Today Microsoft has partnered with Pearson VUE to make digital badges widely available for Microsoft Certified Professionals (MCPs). Beginning October 21, 2016, if you have passed a qualifying exam or earned a designated certification, you will be able to share your achievements more effectively with these digital badges. Beginning in November 2016, badges will be retroactively issued to those who have passed exams or achieved certifications prior to October 21st, 2016.
Microsoft is streamlining its expert-level certifications to provide more flexibility and a wider array of starting points towards certification. There will be Four new Microsoft Certified Solutions Expert (MCSE) certifications and One Microsoft Certified Solutions Developer (MCSD) certification.
You will first need to earn a qualifying Microsoft Certified Solutions Associate (MCSA) from one of many qualifying paths and then pass a single additional exam from a list of electives to earn the corresponding MCSE or MCSD.
The MCSA/MCSD you earn will never expire, however each year you will have the chance to re-Earn the certification by passing an additional exam from the ever growing list of electives. This replaces the existing requirement of needing to renew your certification every 3 years and will help you gain new skills on new exams instead of continuing to re-test on older skills over and over again. To find out more, download the list of exams and electives for the Microsoft Streamlined Certification Paths here.
Seems like I like to take my certifications backwards, but I passed my 70-347 exam on Office 365 Services today. Going to take a day or two off and then start studying for the 70-346 exam to complete the MCSA on Office 365. It is really nice to be able to work on the Learn on Demand labs from Microsoft Ignite instead of having to use my private or work Office 365 accounts.
Today, five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties are being released. These credentials are aligned to Centers of Excellence, used by the Microsoft Partner Network to identify technical competencies that are widely recognizable by both Microsoft partners and customers. Learn more here.
Are you interested in becoming a Microsoft Certified Professional (MCP)? Getting ready for a Microsoft Certification exam? Then you already know that having the requisite content knowledge is only part of the complete picture. You also need practical, hands-on technology skills and strong test-taking strategies.In this on-demand Microsoft Certification exam prep session quickly ramp up on what you need to know to conquer Microsoft Certifications. Find out what they are, who they’re for, and how to become a better test-taker. Take a look at different kinds of questions and how to be prepared for them. Plus, get details on special deals, pricing, and registration, along with next steps in your Microsoft Certification journey.
Microsoft announced today that New MCSA certifications are out for both Windows Server 2016 http://bit.ly/295AIN0 and SQL Server 2016 http://bit.ly/295AWUG. Upgrade exams are also available for those who already have earned an MCSA on Windows Server 2012 or SQL Server 2012.
Here is a short 13 minute tutorial I put together on how to use XML within SQL Server. While I made this for the Born to Learn Study Groups, I am sure it will be helpful for others who might be studying for the 70-461 exam.
We all know that getting certified can give your career (and resume) a boost. If you’ve been interested in getting certified – or want to continue to the next level of certification – but were unsure or waiting until you had some wiggle room with studying and practicing for the exam, that time is now. We’re excited to introduce a brand new offer: Microsoft Certification Booster Packs!
Microsoft has also made a commitment to enable choice and support the open source community, allowing customers to leverage the platforms of their choice. To support that, today Microsoft announced the “Microsoft Certified Solutions Associate (MCSA) Linux® on Azure” certification which recognizes the importance of open source-based workloads in the Microsoft cloud.
Microsoft announced the release of the MCSA: Windows 10 certification for IT professionals. This credential demonstrates expertise to configure, manage, and maintain a Windows 10 enterprise system. The new certification incorporates the recently released Exam 697: Configuring Windows Devices, which helps Windows 8 administrators upgrade their skills to Windows 10. The complete MCSA certification is earned by passing all three of the following exams:
- The first step is to Parse the statement into keywords, expressions, and operators. This is where the syntax of your query statement is checked for accuracy. To continue reading click here.