Get started

By signing up, you agree to our Terms of Use and Privacy Policy.
Reset your password
Enter your email and we'll send you instructions on how to reset your password.

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

2k learners
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.
  • Access to GreyCampus platform

  • GreyCampus Course completion certificate

Subscribe to this course + 29 courses
USD 50

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. 

  • 1-year access to audio-video lectures
  • GreyCampus course completion certificate

Course Outline

  • Introduction to the course
    Course Introduction
    Course Modules
  • Module 1
    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
  • Module 2
    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
  • Module 3
    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
    • Module 4
      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
    • Module 5
      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
    • Module 6
      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
    • Module 7
      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
    • Module 8
      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
    • Module 9
      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
    • Module 10
      Troubleshooting SQL Server
      Service Issues
      Connectivity Issues
      Locking Issues
      Troubleshooting Demo Part1
      Troubleshooting Demo Part2
      Exam Scenarios
      Module Review
      Program Review

Download full course agenda/brochure

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got any queries?
By submitting, you agree to our Terms of Use and Privacy Policy.

Acknowledgements

Our Accreditations

Call us

USA +1 518 302 6767
UK +44 20 8144 4436
IND +91 741 666 4433
HKG +852 8192 9294