Chicago area career training

MCSA: 70-462 Administering Microsoft SQL Server 2014 Databases (20462D)


* Pricing and Logistics are subject to change without notice.

This 5-day instructor led course is part of the MCSA SQL Server certification track. It provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. This course prepares students for exam 70-462.

MicroTrain offers Microsoft Certified instructors, in-classroom lessons and labs, supplemental training and study materials, and the MicroTrain Exam Pass Guarantee.

Who benefits from this course?

  • Anyone pursuing MCSA SQL Server certification
  • Anyone who is interested in learning how to administer and maintain SQL Server 2012 or SQL Server 2014
  • Any individuals who have or desire roles that rely on databases and database administration


About This Course

Upon successful completion of this course, students will be able to:

  • Plan and install SQL Server 2014
  • Configure SQL Server databases
  • Describe SQL Server recovery models
  • Back and restore databases
  • Import and export data
  • Authenticate and authorize users
  • Use server and database roles
  • Configure and assign permissions
  • Use encryption and auditing
  • Manage SQL Server Agent and jobs
  • Configure security for SQL Server Agent
  • Use PowerShell to manage SQL Server
  • Configure Database Mail, alerts, and notifications
  • Maintain databases
  • Configure SQL Profiler and SQL Trace and use the Database Engine Tuning Advisor
  • Monitor data by using Dynamic Management Views


Student Prerequisites
This course requires that you meet the following prerequisites:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:
  • 20461C: Querying Microsoft SQL Server 2014

Exam Details

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

The Logistics of Your Exam

  1. The cost of the exam is an additional $165
  2. Locate a Pearson Vue testing center near you

  3. Create a Microsoft Profile and register for your exam

  4. Review Microsoft Exam Policies prior to taking your exam

Exam Information

Exam Code 70-462
Number of Questions 40-60
Passing Score 700 (on a scale of 1-1000)
Types of Questions
  • Case Studies

  • Multiple choice

  • Multiple response

  • Active screen

  • Best answer

  • Build List

  • Drag and drop

  • Hot area

  • Repeated answer choices

  • Short answer

  • Mark review

  • Review screen

Length of Test 120 minutes
Exam Results Provided within minutes of completing exam

Course Schedule

09/09/2019 - 09/20/2019 08:00 am - 11:00 am

Exam Pass Guarantee

At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Learn More