Administering Microsoft SQL Server 2012/14/16 Databases (70-462) Course

Length: 5 day(s)      Public Class Price: $2,925/person (USD)      Group Onsite Price: Request Quote      Course Category: Microsoft SQL Server | 209209 sql-2012-70-462

Course Outline & Dates

Administering Microsoft SQL Server 2012/14/16 Databases (70-462) Course by Certstaffix® Training

This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access.

This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider.. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.

Group Classes for Businesses - Onsite at Your Office

Have a group of employees needing the same training? Onsite training at your office is a great solution. Request Free Quote

Public Corporate Classes - Classes are $2,925 (USD) per employee. - Have a Group?

Click any upcoming class date below to register & view location/attendance options. You must register at least 15 days before class.

 Register ➥    September 17, 2018       Register ➥    May 13, 2019     
 Register ➥    October 29, 2018       Register ➥    June 24, 2019     
 Register ➥    December 10, 2018       Register ➥    August 5, 2019     
 Register ➥    January 7, 2019       Register ➥    September 16, 2019     
 Register ➥    February 18, 2019       Register ➥    October 28, 2019     
 Register ➥    April 1, 2019       Register ➥    December 9, 2019     

Related Certifications

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

Course Outline:

Chapter 1 Planning and Installing SQL Server 2012
Lesson 1: Planning Your Installation
Lesson 2: Installing SQL Server and Related Services

Chapter 2 Configuring and Managing SQL Server Instances
Lesson 1: Configuring SQL Server Instances
Lesson 2: Managing SQL Server Instances

Chapter 3 Configuring SQL Server 2012 Components
Lesson 1: Configuring Additional SQL Server Components
Lesson 2: Managing and Configuring Databases

Chapter 4 Migrating, Importing, and Exporting
Lesson 1: Migrating to SQL Server 2012
Lesson 2: Exporting and Importing Data

Chapter 5 SQL Server Logins, Roles, and Users
Lesson 1: Managing Logins and Server Roles
Lesson 2: Managing Users and Database Roles

Chapter 6 Securing SQL Server 2012
Lesson 1: Managing Database Permissions
Lesson 2: Troubleshooting SQL Server Security
Lesson 3: Auditing SQL Server Instances

Chapter 7 Mirroring and Replication
Lesson 1: Mirroring Databases
Lesson 2: Database Replication

Chapter 8 Clustering and AlwaysOn
Lesson 1: Clustering SQL Server 2012
Lesson 2: AlwaysOn Availability Groups

Chapter 9 Troubleshooting SQL Server 2012
Lesson 1: Working with Performance Monitor
Lesson 2: Working with SQL Server Profiler
Lesson 3: Monitoring SQL Server
Lesson 4: Using the Data Collector Tool
Lesson 5: Identifying Bottlenecks

Chapter 10 Indexes and Concurrency
Lesson 1: Implementing and Maintaining Indexes
Lesson 2: Identifying and Resolving Concurrency Problems

Chapter 11 SQL Server Agent, Backup, and Restore
Lesson 1: Managing SQL Server Agent
Lesson 2: Configuring and Maintaining a Backup Strategy
Lesson 3: Restoring SQL Server Databases

Chapter 12 Code Case Studies

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.

Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.

Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.

Low Cancellation Rate

Most classes run as scheduled.

*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.

Group Training

Have a group of several students needing the same training? Then onsite training is a perfect option for you. We'll come onsite to your office so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.

How Onsite Training Works

  • An expert Instructor will come to your office and personally train the students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Onsite Quote


Here are a sample of Microsoft SQL Server class reviews from past students that have attended our Microsoft SQL Server training courses.

Certstaffix® Class Reviews

Student Average:
4.76 out of 5 from 7 students

4.06 out of 5

- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

5.00 out of 5

- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

5.00 out of 5

- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

4.47 out of 5

- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

4.76 out of 5

- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

5.00 out of 5

- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

5.00 out of 5

- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

Please contact us if we do not yet have any reviews or you would like more.