The Developing Microsoft SQL Server Databases (70-464) certification exam is one of the elective exams that counts towards the MCSE: Data Management and Analytics certifications. This exam centers around objectives that cover the areas of developing Microsoft SQL Server databases.

Certification Target Audience

The focus of the 70-464 Developing Microsoft SQL Server Database certification exam is centered around SQL Server technologies. This exam was first published in 2012, with more recent updates done in 2016, so it doesn’t seem to contain the Azure SQL Database topics that other exams cover.

This exam targets those database professionals who build and implement databases across organizations and who ensure high levels of data availability. The database professionals roles would 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.

Skills Measured

Here’s a high level outline of the skill objectives measured on the Developing Microsoft SQL Server Databases (70-464) certification exam. The percentages next to each of the exam objectives represents the percentage of exam questions in that particular exam objective area.

  • Implement database objects (30-35%)
    • Create and alter tables
    • Design, implement, and troubleshoot security
    • Design the locking granularity level
    • Implement indexes
    • Implement data types
    • Create and modify constraints
  • Implement programming objects (15-20%)
    • Design and implement stored procedures
    • Design T-SQL table-valued and scalar functions
    • Create, use, and alter user-defined functions (UDFs)
    • Create and alter views
  • Design database objects (25-30%)
    • Design tables
    • Design for concurrency
    • Design indexes
    • Design data integrity
    • Design for implicit and explicit transactions
  • Optimize and troubleshoot queries (25-30%)
    • Optimize and tune queries
    • Troubleshoot and resolve performance problems
    • Optimize indexes
    • Capture and analyze execution plans
    • Collect performance and system information

When studying for this exam, you’ll definitely want to look at the official exam page from Microsoft for the complete list of objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting the exam successfully.

Training Materials

At the time of writing this summary, the 70-464 Developing Microsoft SQL Databases exam has a limited amount of Exam preparation material available. As a result, you may need to focus primarily on Microsoft documentation surrounding the technologies and skills measured on this exam.

However, there is a bit of overlap between this exam and the 70-762 Developing SQL Databases exam. It’s unclear at this time if this new exam is meant to replace this one, but there seems to be overlap either way. As a result, you may be able to use the study materials for 70-762 when studying for the 70-464 exam. You’ll at least want to check it out.

Posted by Chris Pietschmann

Chris is a Microsoft MVP and has 15+ years of experience building enterprise systems both in the cloud and on-premises. He is also a Microsoft Certified (MCSD) Azure Solutions Architect. He has a passion for technology and sharing what he learns with others to help enable them to learn faster and be more productive.

One Comment

  1. […] 70-464 Developing Microsoft SQL Server Databases Certification Exam (Chris Pietschmann) […]

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s