Microsoft has been expanding out the certification offerings around Microsoft Azure. The Provisioning SQL Databases (70-765) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers Azure SQL Databases and hosting SQL Server within Virtual Machines (VMs).
Certification Target Audience
The focus on the Developing SQL Databases (70-762) certification exam is centered around SQL Server and Azure SQL Database. The exam is designed to target candidates who build and implement databases across organizations and who ensure high levels of data availability. The ideal candidates responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
Here is a high level list of the skills and objectives measured on the Developing SQL Databases (70-762) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.
- Design and implement database objects (25-30%)
- Design and implement a relational database schema
- Design and implement indexes
- Design and implement views
- Implement columnstore indexes
- Implement programmability objects (20-25%)
- Ensure data integrity with constraints
- Create stored procedures
- Create triggers and user-defined functions
- Manage database concurrency (25-30%)
- Implement transactions
- Manage isolation levels
- Optimize concurrency and locking behavior
- Implement memory-optimized tables and native stored procedures
- Optimize database objects and SQL infrastructure (20-25%)
- Optimize statistics and indexes
- Analyze and troubleshoot query plans
- Manage performance for database instances
- Monitor and trace SQL Server baseline performance metrics
When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.
At the time of writing this summary of the 70-762 Developing SQL Databases exam, there is a limited amount of Exam preparation material available. You’ll need to focus mostly on the Microsoft documentation surrounding the technologies and skills measured on this exam for now. However, there an Exam Reference book from Microsoft Press being published soon!
Below is a summary of the exam reference book:
Exam Ref 70-762 Developing SQL Databases
Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
- Design and implement database objects
- Implement programmability objects
- Manage database concurrency
- Optimize database objects and SQL infrastructure
This Microsoft Exam Ref:
- Organizes its coverage by exam objectives
- Features strategic, what-if scenarios to challenge you
- Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases
Microsoft continues to expand out their certification program to better fit the newly emerging “cloud-based” world of IT. As a result, the existing Microsoft Azure exams as well as new exams being published are being integrated into the broad spectrum of Microsoft certifications; such as the MCSE. The MCSE: Data Management and Analytics certification has recently been introduced as part of a new redesign and restructuring of the MCSE certifications. This article explains some of the details around how you can go about earning the new MCSE: Data Management and Analytics certification.
On the path to earning the MCSE: Data Management and Analytics an MCSA certification will first be earned.
The MCSA Foundation
On the path to earning the MCSE: Data Management and Analytics certification an MCSA certification will first be earned. It’s really good to have a milestone along the way, instead of having to take a tone of exams before claiming any single certification title / credential. Additionally, instead of just a single MCSA choice to earn, there are actually multiple tracks to choose from based on your unique combination of expertise and interests.
Here’s the list of the MCSA certification tracks, along with the exams you’ll need to pass to achieve each of them:
- MCSA: SQL Server 2012/2014
- 70-461: Querying Microsoft SQL Server 2012/2014
- 70-462: Administering Microsoft SQL Server 2012/2014 Databases
- 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
- MCSA: SQL 2016 Database Administration
- MCSA: SQL 2016 Database Development
- 70-761: Querying Data with Transact-SQL
- 70-762: Developing SQL Databases
- MCSA: SQL 2016 Business Intelligence Development
- MCSA: Machine Learning
- MCSA: BI Reporting
- MCSA: Data Engineering with Azure
- 70-775: Perform Data Engineering on Microsoft HD Insight
- 70-776: Engineering Data with Microsoft Cloud Services (Planned)
- MCSA: Azure Database Development
As you can see the MCSA foundations mostly require 2 exams to be passed; these are the newer MCSA’s. The older MCSA for SQL Server 2012/2014 requires 3 exams to be passed to earn. All these MCSA’s fill provide a solid foundation of SQL Server in the specific track that you choose.
MCSE: Data Management and Analytics
Once a qualifying MCSA certification (as listed above) has been earned, the next path to the MCSE: Data Management and Analytics certification is to pass only 1 more exam. Also, best of all, you get to choose which exam you would like to take from a list of elective exams.
Here’s the list of elective exams to choose from to build on top of the MCSA foundation when achieving the MCSE: Data Management and Analytics certification:
Even if you choose to focus on SQL Server 2012/2014 or SQL Server 2016 with the MCSA you earned, it’s up to you if you want to mix some Azure / Cloud expertise into your certification for the MCSE, Or, you can still with SQL Server for your choice elective exam as well.
Once a qualifying MCSA certification (as listed above) is earned, the next path is to pass 1 more exam to earn the full MCSE: Data Management and Analytics certification!
Updated May 27, 2017: Microsoft announced a renaming of a few of the MCSA certifications and the addition of more elective exams for the MCSE: Data Management and Analytics certification.
Updated Apr 13, 2017: Added info about MCSA Data Science certification.
Along side the Ignite 2016 conference, Microsoft announced some changes to the Microsoft Certified Professional program. These changes outlined 5 new MCSE and MCSD certifications, along with MCSA certifications to go along with them. One of these new MCSD certifications is the new MCSD: App Builder certification. This certification requires 3 exam to be passed to earn, and it also will get you an MCSA certification on your way to earning the full MCSD: App Builder certification. This post gives a brief explanation on the exam that are required and / or qualify for the MCSD: App Builder, as well as the MCSA certifications you can earn on your way to obtaining the full MCSD! Happy studying!
On the path to earning the MCSD: App Builder certification an MCSA certification will first be earned.
On the path to earning the MCSD: App Builder certification an MCSA (Microsoft Certified Solutions Associate) certification will first be earned. It’s really good to have a milestone along the way, instead of having to pass a ton of exams before claiming any single certification title / credential. Additionally, instead of just a single MCSA to earn on the path to MCSD: App Builder, there are 2 tracks to choose from based on your unique combination of expertise and interests.
The list of both MCSA certifications and their required exams are as follows:
- MCSA: Web Applications – pass both of the following exams:
- MCSA: Universal Windows Platform – pass both of the following exams:
- 70-483: Programming in C#
- 70-357: Developing Mobile Apps
As you can see the MCSA foundations for the new MCSD: App Builder certification require you to pass 2 exams. While not an extensive set of choices, the tracks to pick are either Web Application development or UWP (Universal Windows Platform) App development.
MCSD: App Builder
Once a qualifying MCSA certification (as listed above) is earned, the next path is to pass only 1 more exam to earn the full MCSD: App Builder certification! And, the best part is that you get to choose from a fairly long list of exams to make that happen.
Here’s the current list of Elective exams that can be taken to build on an MCSA to earn the new MCSD: App Builder certification:
- 70-532: Developing Microsoft Azure Solutions
- 70-487: Developing Microsoft Azure and Web Services
- 70-488: Developing Microsoft SharePoint Server 2013 Core Solutions
- 70-489: Developing Microsoft SharePoint Server 2013 Advanced Solutions
- 70-354: Universal Windows Platform – App Architecture and UX/UI
- 70-355: Universal Windows Platform – App Data, Services, and Coding Patterns
- 70-496: Administering Microsoft Visual Studio Team Foundation Server
- 70-497: Software Testing with Visual Studio
- 70-498: Delivering Continuous Value with Visual Studio Application Lifecycle Management
Regardless of the MCSA track you choose to start with (Web Apps or UWP Apps) you can continue on with earning the MCSD: App Builder with an exam in that topic area, or any of the other elective exam options.
Blog articles and Technical documentation are nice for learning technologies, but there are times when a good book just can’t be replaced. This is especially true when getting information from blogs that may have a snippet of “found code” that might or might not work as expected. At least properly technically reviewed book will have working code snippets and other directions / information.
So, here’s a bunch of eBooks on Azure topics that are available for the Amazon Kindle. After all, what better to read about the Cloud than with a “Virtual” book! Read More
Build Azure Weekly is a regular series that brings you the latest news, blogs, videos, and other content around the Microsoft Azure ecosystem from the week. The links shared include those from the community as well as from Microsoft as well. The goal of Build Azure Weekly is to help you keep up to date in the latest news and general happenings surrounding Microsoft Azure for the week.
Here’s the list of Azure Service Updates that have been announced by Microsoft over the week:
The trilogy of Microsoft Azure Certification exams first debuted more than one year ago. In that time there have been some tremendous changes and additions to the entire Microsoft Azure Platform. As a result, coming March 10, 2016, Microsoft is updating the exam objectives to reflect some of these changes. But, what are the changes? Read More
The “Building Cloud Apps with Microsoft Azure” book written by Scott Guthrie, Mark Simms, Tom Dykstra, Rick Anderson and Mike Wasson has been made a free eBook by Microsoft Press. This books goes through a pattern-based approach to building real-world solutions with Microsoft Azure. Among these practices covered include topics coving both Architecture and coding practices. The content of this book is based off the presentation Scott Guthrie gave at the Norwegian Developers Conference (NDC) in June, 2013, as well as Microsoft Tech Ed Australia in September, 2013. Read More
The book “Microsoft Azure Essentials: Fundamentals of Azure” has been made available as a Free eBook from Microsoft Press and Microsoft Virtual Academy. This book is written by Michael Collier and Robin Shahan.
The material covered in this book are targeted towards introducing both Developers and IT Professionals to the huge range of features and capabilities within the Microsoft Azure platform. Read More
There’s been a huge increase in the need to get trained in Microsoft Azure, and as a result the interest / need to get certified in Azure has been increasing as well. The only difficulty with the certification is there are 3 primary Microsoft certification exams on Azure and it can be a little unclear which exam is right for “You.” In this article I will outline the differences between the different Azure certification exams / certifications, and hopefully I’ll help you decide which is best for you to start with.
Update 9/30/2016: This week Microsoft announced some really big and amazing changes to the Microsoft Certification program and how the Azure certification exams fit in with MCSD and MCSE certifications. As a result, you want to reference the 2016 Edition of Where to start with Azure Certification article instead.
Microsoft Azure Essentials: Azure Web Apps for Developers
The “Microsoft Azure Essentials: Azure Web Apps for Developers” book written by Rick Rainey has been made available as a Free eBook on the Microsoft Virtual Academy website. This book covers the necessary information to help developers advance their technical skills in developing, deploying and managing Web Applications hosted within the Microsoft Azure platform using the Web Apps feature set. This book is written to target .NET developers from beginner to advanced. Read More