Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Study materials for Developing SQL Databases exam 70-762


By:   |   Read Comments   |   Related Tips: 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 Update:






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





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools