SQL


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

by Certstaffix® Training


Attend Our Classes From Home - No Software Needed - Learn More...

SQL Server Training

Length: 5 day(s)      Public Class Price: $2925/person (USD)      Group Class Price: Request Quote      Course Category: Microsoft SQL Server


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.


This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 Register ➥   July 18, 2022     
 Register ➥   June 6, 2022     


Group Onsite Training
At Your Organization

OR

Private Online Training
Live Online Instruction

Have a group of several students needing the same training? Then onsite or private online group training is a perfect option for you. We'll either come onsite to your office or deliver a private live online class 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.


  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Course Topics

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
Course Description: Print It | Download PDF | Email It

Microsoft SQL Server Training Reviews by Certstaffix® Training

Certstaffix® Training collects detailed class reviews via a formal post-class evaluation in all our instructor-led courses. Below are a sample of abbreviated reviews from real students from our past classes. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Certstaffix® Class Reviews

Student Average:
4.73 out of 5 from 12 students

4.96 out of 5

Dave Zubal is an excellent teacher.


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

4.96 out of 5


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

4.17 out of 5


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

4.39 out of 5


- attended our Administering Microsoft SQL Server 2012/14/16 Databases (70-462) 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

4.76 out of 5


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

4.47 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) 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



Microsoft SQL Server Courses By City:

AL - Birmingham       GA - Augusta       NC - Greensboro       RI - Providence      
AL - Huntsville       GA - Columbus       NC - Raleigh       SC - Greenville      
AL - Mobile       GA - Savannah       NC - Winston-Salem       SC - Myrtle Beach      
AR - Bentonville       HI - Honolulu       ND - Fargo       SC - North Charleston      
BC - Vancouver       IA - Des Moines       NE - Lincoln       SD - Sioux Falls      
CA - Bakersfield       IA - Iowa City       NE - Omaha       SK - Regina      
CA - Fresno       ID - Boise       NH - Bedford       SK - Saskatoon      
CA - Los Angeles       IL - Chicago       NJ - Bridgewater       TN - Chattanooga      
CA - Modesto       IN - Fort Wayne       NM - Albuquerque       TN - Knoxville      
CA - Oakland       IN - Indianapolis       NS - Halifax       TN - Memphis      
CA - Oxnard       KS - Topeka       NV - Henderson       TN - Nashville      
CA - Rancho Cucamonga       KY - Lexington       NV - Reno       TX - Amarillo      
CA - Sacramento       KY - Louisville       NY - Albany       TX - Austin      
CA - Salinas       LA - Baton Rouge       NY - Buffalo       TX - Beaumont      
CA - San Diego       LA - Lafayette       NY - New York City       TX - Corpus Christi      
CA - San Jose       LA - New Orleans       NY - Rochester       TX - Dallas      
CA - Santa Rosa       LA - Shreveport       NY - Syracuse       TX - El Paso      
CA - Stockton       MA - Burlington       OH - Cincinnati       TX - Fort Worth      
CO - Boulder       MA - Springfield       OH - Columbus       TX - Houston      
CO - Colorado Springs       MA - Westborough       OH - Dayton       TX - Killeen      
CO - Denver       MB - Winnipeg       OH - Highland Heights       TX - Laredo      
CT - Cheshire       MD - Largo       OH - Toledo       TX - Longview      
CT - New Haven       MD - Laurel       OK - Oklahoma City       TX - Lubbock      
CT - Stamford       ME - Portland       OK - Tulsa       TX - McAllen      
DE - Wilmington       MI - Ann Arbor       ON - Ottawa       TX - Midland      
FL - Daytona Beach       MI - Grand Rapids       ON - Toronto       TX - San Antonio      
FL - Fort Lauderdale       MI - Lansing       OR - Beaverton       TX - Tyler      
FL - Fort Myers       MI - Livonia       OR - Bend       TX - Waco      
FL - Gainesville       MN - Minnetonka       OR - Eugene       UT - Ogden      
FL - Jacksonville       MO - Columbia       OR - Medford       UT - Salt Lake City      
FL - Lakeland       MO - Kansas City       PA - Allentown       VA - Glen Allen      
FL - Miami       MO - St. Louis       PA - Erie       VA - Roanoke      
FL - Naples       MS - Biloxi       PA - Harrisburg       VA - Virginia Beach      
FL - Pensacola       MS - Jackson       PA - Philadelphia       VT - Burlington      
FL - Sarasota       MT - Billings       PA - Pittsburgh       WA - Seattle      
FL - Tallahassee       NB - Moncton       PA - Reading       WA - Spokane      
FL - Tampa       NB - Saint John       PA - Scranton-Wilkes Barre       WI - Green Bay      
FL - Winter Park       NC - Asheville       PA - York       WI - Madison      
GA - Atlanta       NC - Charlotte       QC - Montreal       WI - Milwaukee