MCSA: SQL Server 2012/2014

Important

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page. Any certifications you earn prior to their retirement dates will continue to appear on your transcript in the Certification Dashboard.

 

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

Job role: Database Administrator

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

Important: See details

Go to Certification Dashboard

Certification details

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

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.

    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.

    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.

    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

Training and certification guide

Explore all certifications in a concise training and certifications guide.

Certification poster

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

Exam Replay

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

Support for certifications

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

Certification dashboard

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 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.