Study material for exam 70-762 Developing SQL Databases


By:   |   Updated: 2017-02-08   |   Comments (2)   |   Related: More > Professional Development Certifications


Problem

There is a new Microsoft exam for SQL Server 2016 or later, which is exam 70-762 and it is for developing SQL databases. What are some of the materials I can use to study for this exam?

Solution

In this tip, we will give you some links, tips, books, and training exams to pass the 70-762 exam.

What is the 70-762 certification exam?

This is exam is related to creating indexes, views, constraints, columnstore indexes, stored procedures, user defined functions (UDFs), triggers, transactions, handling performance and more.

Is it an exam for database developers?

This exam is for DBAs and database developers.

Is it an exam oriented to SQL Server 2016?

Yes, if you pass this exam and 70-761, you will get the MCSA title (Microsoft Certified Solution Associate) in SQL Sever 2016 Database Development. However, this certification includes some topics like SQL Azure, because SQL Server has a lot of functionality that interacts with SQL Azure.

Which SQL Server 2012/2014 exam is similar to this one?

The 70-464 is similar to this new exam, but there were changes related to Azure and columnstore which is more important in this new exam. The security and CLR topics were removed.

Is this exam difficult?

The 70-761 exam is a piece of cake compared with this exam. This exam, is much harder and requires more effort and knowledge to pass.

Which books would you recommend for this exam?

There is no Training Kit book yet, but old books for older exams may help. Here are some:

  1. SQL Queries 2012 Joes 2 Pros. Volume 4: Query Programming Objects for SQL Server 2012 (SQL Exam Prep Series 70-461 Volume 4 of 5 Kindle Edition) is useful for the for implementing programmability objects topic.
  2. SQL Server Concurrency: Locking, Blocking and Row Versioning is a great book for the manage database concurrency topic.
  3. SQL Server Execution Plans, Second Edition is a good book for the optimize database objects and SQL infrastructure section.
  4. Inside the SQL Server Query Optimizer also helps for the optimize database objects and infrastructure.
  5. Performance Tuning with SQL Server Dynamic Management Views is also a good book for the dynamic management objects topics.
  6. Obviously, the books online in MSDN is the main book in SQL Server.
  7. Pro SQL Server Internals 2nd ed. Edition is also a great book that covers 60% of all the topics.

Which courses would you recommend for this exam?

The official Microsoft course is 20762B, Developing SQL Databases.

There will be a specific MVA course in the future, but not yet.

Other courses that could help are:

What links do you recommend for these exam?

Design and implement database objects

Implement programmability objects

Manage database concurrency

Optimize database objects and SQL infrastructure

Next Steps

Here are several links that will be useful:



Last Updated: 2017-02-08


get scripts

next tip button



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources





Comments For This Article




Saturday, February 03, 2018 - 9:46:03 AM - Jan-Willem Back To Top (75096)

 Hi,

Thank you very much. I've taken the 761 exam. The first chapter in the reference for 762 seem to show a lot of overlap with 761. Is it true that a lot of the topics mentioned are in both 761 and 762?

Thanks.


Sunday, January 14, 2018 - 3:47:54 AM - Lackshu Back To Top (74953)

The reference book for the exam is out: https://blogs.msdn.microsoft.com/microsoft_press/2017/01/20/new-book-exam-ref-70-762-developing-sql-databases/  

 



download





Recommended Reading

Study material for exam 70-761 Querying Data with Transact-SQL

Study material for exam 70-764 Administering a SQL Database Infrastructure

Study material for exam 70-767 Implementing a SQL Data Warehouse

Study material for exam 98-364 Database Fundamentals

Study material for exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI (beta)














get free sql tips
agree to terms