Microsoft 70-462: Administering SQL Server 2012 Databases Training Course

This course is intended for IT professionals and database administrators who want to upskill their methods in storing and managing data in the SQL server, handle performance and troubleshooting problems, connect and organize SQL servers and create a base for all other SQL server related disciplines.

  • 1-year e-learning access

  • Course completion certificate

  • 100% money-back guarantee

Online Self Learning USD 149 (USD 199) Enroll Now
Live Online Training -- Get Quote
Traditional Classroom -- Get Quote

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

The Microsoft 70-462 exam is for those working as SQL Server Database administrators, System engineers, and experienced developers. In this course, learn how to administer and manage SQL Server 2012 – from planning, installing, troubleshooting, recovering, and securing instances and databases. This course helps prepare you for the 70-462 exam. 

Course Outline

Course Introduction
Course Modules
Introduction to SQL Server 2012
SQL Server Part1
SQL Server Part2
SQL Server Part3
SQL Server Part4
SQL Server Tools Part1
SQL Server Tools Part2
SQL Server Tools Part3
Management Studio Demo Part1
Management Studio Demo Part2
Management Studio Demo Part3
Data Tools Part1
Data Tools Part2
Exam Scenarios
Module Review
Installing SQL Server
SQL Architecture
Hardware Requirements Part1
Hardware Requirements Part2
Software Requirements Part1
Software Requirements Part2
Installation Process
Troubleshooting Installation
Upgrading & Unattended Installations Part1
Upgrading & Unattended Installations Part2
Configuration Demo Part1
Configuration Demo Part2
Exam Scenarios
Module Review
Backup and Restore a Database
Database Architecture Part1
Database Architecture Part2
Database Architecture Part3
Database Backup Part1
Database Backup Part2
Database Backup Part3
Restoration Process Part1
Restoration Process Part2
Restoring System Database Part1
Restoring System Database Part2
Backup and Recovery Demo Part1
Backup and Recovery Demo Part2
Exam Scenarios
Module Review
Tracing Access to SQL Server
Auditing Options Part1
Auditing Options Part2
Introduction to SQL Audit Part1
Introduction to SQL Audit Part2
Audit Objects and Implementation
Extended Events Part1
Extended Events Part2
Tracing Activity Demo Part1
Tracing Activity Demo Part2
Tracing Activity Demo Part3
Tracing Activity Demo Part4
Exam Scenarios
Module Review
Importing and Exporting Data
Introduction to Data Transfer Part1
Introduction to Data Transfer Part2
ETL Tools
Improving Data Transfer Part1
Improving Data Transfer Part2
Improving Data Transfer Part3
Improving Data Transfer Part4
Copying Database Methods Part1
Copying Database Methods Part2
Transferring Data Demo Part1
Transferring Data Demo Part2
Exam Scenarios
Module Review
SQL Server Security
Security and Authentication
Server and Database Roles
Permissions Part1
Permissions Part2
Securing SQL Server Demo Part1
Securing SQL Server Demo Part2
Exam Scenarios
Module Review
Automating SQL Server
SQL Server Agent
Database Mail
Operators, Alerts and Jobs
Database Configuration Demo Part1
Database Configuration Demo Part2
Database Configuration Demo Part4
Database Configuration Demo Part3
Exam Scenarios
Module Review
Monitoring SQL Server
Dynamic Management Views and Functions
Profiler Trace
Database Tuning Advisor
Activity and Performance Monitor
Data Collection
Monitoring Demo Part1
Monitoring Demo Part2
Monitoring Demo Part3
Monitoring Demo Part4
Monitoring Demo Part5
Monitoring Demo Part6
Monitoring Demo Part7
Exam Scenarios
Module Review
Maintaining SQL Server
Checking Database Integrity
Indexing Part1
Indexing Part2
Indexing Part3
Ongoing Maintenance
Managing and Maintaining Demo Part1
Managing and Maintaining Demo Part2
Managing and Maintaining Demo Part3
Exam Scenarios
Module Review
Troubleshooting SQL Server
Service Issues
Connectivity Issues
Locking Issues
Troubleshooting Demo Part1
Troubleshooting Demo Part2
Exam Scenarios
Module Review
Program Review

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements