Study material for exam 70-464 Developing Microsoft SQL Server Databases

By:   |   Comments (4)   |   Related: More > Professional Development Certifications


I would like to know what books, videos, links and advice you would recommend to pass the Developing Microsoft SQL Server Databases (Exam 70-464)?


In this tip, we will provide links to articles, books and other training material to help you pass the 70-462 exam.  Also check out these other tips related to these exams: 70-463, 70-466 and 70-462.

What is the Microsoft 70-464 certification exam?

This is exam is related to T-SQL related to advanced features about this query language.

Is this exam oriented to developers?

It is not only developers, it also includes useful topics for DBAs too.

What are the requirements to take this exam?

Anyone can take this exam. However, it is recommended for professionals with 1 or more years of experience in SQL Server.

Can I take this exam directly or there is previous exam?

You can take it directly, but we recommend taking 70-461 first. Specially if you are not an expert.

What books do you recommend for this exam?

Unfortunately, there are no Microsoft Training Kit books for this exam. However, here are some books that might be useful:

  1. T-SQL Querying (Developer Reference) this is my favorite book for this exam. It will help you a lot with the 70-461 and 70-464 exam.
  2. Microsoft SQL Server 2014 Query Tuning & Optimization is a great book for the last topic of the exam about Optimizing and Troubleshooting Queries.
  3. Hexa Marathon Guide: MCSA/MCSE 70-464 is a book with some questions to practice for the exam. We recommend this book when you are almost ready to take the exam.
  4. Microsoft SQL Server 2012 Internals (Developer Reference) is a great book, but it is for advanced users. I recommend you read this one after the other 3. In many chapters it exceeds the knowledge required to pass the exam, but it does not cover all the exam topics.
  5. SQL Server Execution Plans, Second Edition by Grant Fritchey is the best book to cover the execution plan topic. Reading this book exceeds the knowledge required for this topic.
  6. SQL Server Concurrency: Locking, Blocking and Row Versioning will help you in the topic related to design for concurrency. It exceeds the knowledge required for this topic.

Which courses do you recommend for this exam?

The following courses will help you pass the exam:

Which simulation exams do you recommend?

Here are other recommended links to read?

Implement database objects

Implement programming objects

Design database objects

Optimize and troubleshoot queries

Next Steps
  • Get ready and start studying!

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Friday, April 14, 2023 - 1:37:35 AM - prudviraju Back To Top (91105)
Nice Article!

Thanks for sharing with us 🙂

Saturday, April 8, 2023 - 3:03:48 AM - prudviraju Back To Top (91088)
Nice Article!

Thanks for sharing with us 🙂

Friday, March 31, 2023 - 2:29:02 AM - uday Back To Top (91070)
Nice Article!

Thanks for sharing with us 🙂

Monday, June 7, 2021 - 8:49:13 PM - Hanshith Back To Top (88812)
Thanks for the great list of resources to learn sql server for certification. I hope the following SQL resource also very good for learning.

get free sql tips
agree to terms