Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

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


By:   |   Last Updated: 2016-12-23   |   Comments   |   Related Tips: More > Professional Development Certifications

Problem

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)?

Solution

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!


Last Updated: 2016-12-23


next webcast button


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




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    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools