By: Daniel Calbimonte | 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:
- Professional Microsoft SQL Server 2014 Administration does not cover many topics, but it is a good book to start.
- Pro SQL Server Administration contains some chapters that will be useful for the exam.
- SQL Server 2014 Backup and Recovery is a great book for the Backup and Recovery topics.
- Learn SQL Server Administration in a Month of Lunches is also a good book to cover some areas of the exam.
- Securing SQL Server, Third Edition: Protecting Your Database from Attackers will help with some of the security topics.
- 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.
- 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:
- Course 20464D: Developing Microsoft SQL Server 2014 Databases
- MVA: Designing Solutions for SQL Server
- SQL Server 2014 Administration New Features shows the new SQL Server 2014 features
- Design a Database Environment with SQL Server 2014 (70-465)
- Microsoft MCSE SQL Server 2012 70-465
Which simulation exams do you recommend?
- Microsoft Practice Exam for 70-465 MSCert: Designing Database Solutions for Microsoft SQL Server
- Microsoft 70-465 Certification Exam
- 770-465 exam
Which links do you recommend reading?
The following links will help you pass the exam:
Design a database structure
- Design for business requirements
- Design physical database and object placement
- SQL Server Hardware
- SQL Server Hardware Configuration Best Practices
- Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server
- FileTable Feature in SQL Server 2012
- Filegroups in SQL Server
- Move data between SQL Server database filegroups
- Using Multiple Filegroups for a Database and Changing the Default Filegroup
- Hard Drive Configurations for SQL Server
- SQL Server System Databases
- SQL Server System Databases Tips
- System Databases
- Design a table and index partitioning strategy
- Design a migration, consolidation, and upgrade strategy
- Upgrade to SQL Server 2014
- Create a SQL database and perform common database setup tasks with PowerShell cmdlets
- SQL Server 2012 Contained Database Feature
- Cross-cluster Migration of AlwaysOn Availability Groups
- Installing SQL Server 2012 on Windows Server Core Part 1
- Installing SQL Server 2012 on Windows Server Core Using PowerShell
- SQL Server Virtualization Overview (Part 1 of 5)
- Move User Databases
- Design SQL Server instances
- Hardware and Software Requirements for Installing SQL Server 2014
- Handling workloads on SQL Server 2008 with Resource Governor
- affinity mask Server Configuration Option
- Creating an MSDTC Cluster Resource
- MSDTC Recommendations on SQL Failover Cluster
- Setting a fixed amount of memory for SQL Server
- Install SQL Server 2014 Using SysPrep
- Considerations for Installing SQL Server Using SysPrep
- Install SQL Server 2012 Using SysPrep
- Slipstream Service Packs and Cumulative Updates on a SQL Server Installation
- Slipstreaming SQL Server 2012 and 2014
- Understanding Cross Database Ownership Chaining in SQL Server
- Install SQL Server with SMB Fileshare as a Storage Option
- Design backup and recovery
Design databases and database objects
- Design a database model
- Pro SQL Server 2012 Relational Database Design and Implementation (Expert's Voice in SQL Server)
- Create a Database Schema
- Securing SQL Server
- SQL Server Linked Servers Tips
- Linked Servers (Database Engine)
- Create Linked Servers (SQL Server Database Engine)
- SQL Server Service Broker
- Distributed Partitioned Views / Federated Databases: Lessons Learned
- Appendix A: Providers
- ALTER DATABASE SET Options (Transact-SQL)
- Design tables
- Ten Common Database Design Mistakes
- Pro SQL Server 2012 Relational Database Design and Implementation (Expert's Voice in SQL Server)
- SQL Server: Transact-SQL Common Table Expressions
- Recursive Queries using Common Table Expressions (CTE) in SQL Server
- Using Common Table Expressions
- Columnstore Indexes Guide
- Stairway to Columnstore Indexes
- FILESTREAM (SQL Server)
- FileTables (SQL Server)
- CREATE VIEW (Transact-SQL)
- CREATE FUNCTION (Transact-SQL)
- SQL Server Data Compression
- Data Compression
- Getting started with SQL Server 2014 In-Memory OLTP
- Using Computed Columns in SQL Server with Persisted Values
- Specify Computed Columns in a Table
- Page Compression Implementation
- Row Compression Implementation
- Data Types
- SQL Server Tutorial - Part 2 - Data Types, RDM, Normalization, Primary and foreign keys
- Design for concurrency
- SQLDay 2015 | DBA | From Locks to Dead-locks. Concurrency in SQL Server - Andreas Wolter
- Beware the Hidden Side Effects of SQL Server Triggers
- Reasons to Avoid Triggers
- CREATE TRIGGER (Transact-SQL)
- SQL Server Concurrency: Locking, Blocking and Row Versioning
- Microsoft SQL Server Coding for Maximizing Concurrency in Applications
- Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask
- Design T-SQL stored procedures
- CREATE PROCEDURE (Transact-SQL)
- How to create a SQL Server stored procedure with parameters
- Native Compilation of Tables and Stored Procedures
- SQL Server Stored Procedure Tutorial
- Use Table-Valued Parameters (Database Engine)
- In-Memory OLTP (In-Memory Optimization)
- SQL Server Internals: In-Memory OLTP
- Design a management automation strategy
- Archiving Data in SQL Server
- Partitioning & Archiving tables in SQL Server (Part 1: The basics)
- SQL Server Agent
- Configure SQL Server Agent
- SQL Server Integration Services (SSIS) Tutorial
- Using Change Data Capture (CDC) in SQL Server
- SQL Server DDL Triggers to Track All Database Changes
- Extend SQL Server DDL Triggers for more functionality: Part 2
- Implement DDL Triggers
- SQL Server PowerShell Tips
- SQL Server PowerShell
- How to run a backup on multiple SQL Servers
- Migrating Data from Database to Database
- Load Testing with SQL Server Tools
- What is Staging Database and Why to Use it?
- Design for transactions
- Introduction to the SQL Server Transaction Log Tutorial
- BEGIN TRANSACTION (Transact-SQL)
- COMMIT TRANSACTION (Transact-SQL)
- BEGIN DISTRIBUTED TRANSACTION
- COMMIT WORK
- ROLLBACK TRANSACTION
- Transactions in sql server Part 57
- TTRY...CATCH in SQL Server 2005 An Easier Approach to Rolling Back Transactions in the Face of an Error
Design database security
- Design an application strategy to support security
- Server-Level Roles
- Database-Level Roles
- How to use module signing for SQL Server security
- Tutorial: Signing Stored Procedures with a Certificate
- How to check SQL Server Authentication Mode using T SQL and SSMS
- Granting permission with the EXECUTE AS command in SQL Server
- Understanding GRANT, DENY, and REVOKE in SQL Server
- Permissions (Database Engine)
- Database Mirroring (SQL Server)
- Design database, schema, and object security permissions
- Design instance-level security configurations
- Understanding SQL Server fixed server roles
- Choose an Authentication Mode
- Logon Triggers
- SQL Server Certificates and Asymmetric Keys
- Protecting SQL Server Data
- SQL Server Encryption Tips
- Managing SQL Server Master Keys for Encryption
- Recovering a SQL Server TDE Encrypted Database Successfully
- Implement DDL Triggers
- DDL Triggers
- Configure Windows Service Accounts and Permissions
Design a troubleshooting and optimization solution
- Design a maintenance strategy for database servers
- SQL Server Maintenance Tips
- SQL Server Fragmentation and Index Maintenance Tips
- Index Fragmentation Internals, Analysis, and Solutions
- Rebuilding SQL Server indexes using the ONLINE option
- Brad's Sure Guide to SQL Server Maintenance Plans
- DBCC (Transact-SQL)
- Database Files and Filegroups
- In-Memory OLTP Garbage Collection
- Configure the media retention Server Configuration Option
- Troubleshoot and resolve concurrency issues
- Detecting and Ending Deadlocks
- SQL Server Replication Tips
- SQL Server Concurrency: Locking, Blocking and Row Versioning
- Performance Tuning with SQL Server Dynamic Management Views
- SQL Server Extended Events Tips
- SQL Server Queries With Hints
- Different techniques to identify blocking in SQL Server
- Design and implement a high availability solution
- Managing a Windows and SQL Server Cluster using the Failover Cluster Manager tool
- Failover Cluster
- SQL Server 2012 Multi-Subnet Cluster Part 2
- SQL Server Replication
- SQL Server AlwaysOn Availability Tips
- Overview of AlwaysOn Availability Groups (SQL Server)
- Always On Failover Cluster Instances (SQL Server)
- Design a solution to monitor performance and concurrency
- Design a monitoring solution at the instance level
- SQLDay 2014 | track1 | Bob Ward - Extended Events -- The Next Gen. of Tracing for SQL Server
- SQL Server Profiler - Trace Automation
- Administering Microsoft SQL Server 2012: Using the Performance Monitor
- SQL Server Dynamic Management Views and Functions Tips
- 8 Automating Tasks With SQL Server Agent
- Implement Jobs
- SQL Server tutorial: Monitoring a database's size and integrity | lynda.com
- View the Windows Application Log (Windows)
- Report to Capture Table Growth Statistics for SQL Server
- Monitor SQL Server Database File Growth with WMI Alerts
Next Steps
For more information, refer to these links:
About the author
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
Article Last Updated: 2016-12-30
