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

By:   |   Comments   |   Related: More > Professional Development Certifications


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.


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?


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:

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

get free sql tips
agree to terms