Exam 70-464: Developing Microsoft SQL Server Databases

In response to the coronavirus (COVID-19) situation, Microsoft is implementing several temporary changes to our training and certification program. Learn more.

This exam retires on January 31, 2021 at 11:59 PM Central Time. You will no longer be able to take the exam after this date. Learn more about upcoming exam retirements.

This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.


As of February 18, 2016, this exam includes content covering both SQL Server 2012 and 2014. Please note that this exam does not include questions on features or capabilities that are present only in the SQL Server 2012 product. For more information, please download and review this document.

Part of the requirements for: MCSE: Data Management and Analytics

Related exams: none

Important: See details

Go to Certification Dashboard

Schedule exam

  • 70-464: Developing Microsoft SQL Server Databases

    Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)

    Retirement date: none

    This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

    Price based on the country in which the exam is proctored.

    for Developing Microsoft SQL Server Databases

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Skills measured

  • Implement database objects (30-35%)
  • Implement programming objects (15-20%)
  • Design database objects (25-30%)
  • Optimize and troubleshoot queries (25-30%)

Download exam skills outline

Two ways to prepare

Learning paths to gain the skills needed to become certified

    Learning paths are not yet available for this exam

There may be certifications and prerequisites related to "Exam 70-464: Developing Microsoft SQL Server Databases"

  • MCSE: Data Management and Analytics

    Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data - both on-premises and in cloud environments.

Exam resources

Exam Replay

See two great offers to help boost your odds of success.

Certification dashboard

Review and manage your scheduled appointments, certificates, and transcripts.

Request accommodations

Learn more about requesting an accommodation for your exam.

Exam policies and FAQs

Review and manage your scheduled appointments, certificates, and transcripts.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.