Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

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


By:   |   Last Updated: 2016-12-30   |   Comments   |   Related Tips: 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.



    



Learn more about SQL Server tools