Study material for exam 70-465 Designing Database Solutions for Microsoft SQL Server


By:   |   Updated: 2016-12-30   |   Comments   |   Related: More > Professional Development Certifications

Problem

I am studying for Microsoft exam 70-465, Designing Database Solutions for Microsoft SQL Server and I'd like to know what materials I can use to study to pass this exam.

Solution

In this tip, we will talk about study materials to use for exam 70-465; including tips, videos, books and other links.

Who should take this exam?

This is exam is for advanced DBAs, however, there are topics that may be useful for Developers.

Is this exam difficult?

It is not the most difficult exam, but it is difficult.

What is the score to pass?

700/1000

Which exam would you recommend taking before this exam?

Exam 70-462 is recommended.

Can you recommend books for this exam?

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

  1. Professional Microsoft SQL Server 2014 Administration does not cover many topics, but it is a good book to start.
  2. Pro SQL Server Administration contains some chapters that will be useful for the exam.
  3. SQL Server 2014 Backup and Recovery is a great book for the Backup and Recovery topics.
  4. Learn SQL Server Administration in a Month of Lunches is also a good book to cover some areas of the exam.
  5. Securing SQL Server, Third Edition: Protecting Your Database from Attackers will help with some of the security topics.
  6. SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) will help with topics to related to designing, troubleshooting and optimizing a solution.
  7. SQL Architecture Basics Joes 2 Pros: Core Architecture concepts contains several chapters that will be useful for this exam.

Which courses do you recommend for this exam?

The following courses will help you pass the exam:

Which simulation exams do you recommend?

Which links do you recommend reading?

The following links will help you pass the exam:

Design a database structure

Design databases and database objects

Design database security

Design a troubleshooting and optimization solution

Next Steps

For more information, refer to these links:



Last Updated: 2016-12-30


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




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.






download

























get free sql tips

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