Certifications

MCSA: SQL Server 2012/2014

Certification details

Warning

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page.

 

This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

Skills measured

  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimize
  • Install and configure
  • Maintain instances and databases
  • Optimize and troubleshoot
  • Manage data
  • Implement security
  • Implement high availability
  • Design and implement a data warehouse
  • Extract and transform data
  • Load data
  • Configure and deploy SSIS solutions
  • Build data quality solutions

Download certification skills outline

Job role: Database Administrator

Required exams: 70-461 70-462 70-463

Go to Learn Profile

Two ways to prepare

Items in this collection

  • Learning paths or modules are not yet available for this certification

Certification exams

  • 70-461: Querying Microsoft SQL Server 2012/2014

    Languages: en zh-cn fr de ja pt-br

    Retirement date: **

    This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.

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

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    for Querying Microsoft SQL Server 2012/2014

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

  • 70-462: Administering Microsoft SQL Server 2012/2014 Databases

    Languages: en zh-cn fr de ja pt-br

    Retirement date: **

    This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

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

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    for Administering Microsoft SQL Server 2012/2014 Databases

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

  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

    Languages: en zh-cn fr de ja pt-br

    Retirement date: **

    This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.

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

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    for Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

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

Certification resources

Support for Credentials

Get help through Microsoft Credentials support forums. A forum moderator will respond in one business day, Monday-Friday.

Choose your Microsoft Credential

Microsoft Applied Skills or Microsoft Certifications? Choose the path that fits your career goals, desired skillset, and schedule.

Certification poster

Check out an overview of fundamentals, role-based and specialty certifications.

Exam Replay

Boost your odds of success with this great offer.

Your certifications

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

Share your certification badges

Celebrate your accomplishment with your network. Claim your Microsoft Certification badge, and add it to LinkedIn, your résumé, and more.

* Pricing does not reflect any promotional offers or reduced pricing for 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.