Microsoft 70-462: Administering SQL Server 2012 Databases

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012.

Request a quote Review training schedules

Learn more about the course below.

TRAINING SCHEDULES

Microsoft 70-462: Administering SQL Server 2012 Databases training program overview

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012.

The online self-learning version of this course comes included by default when you register for the online instructor-led version or the in-person classroom version. When you sign up for an instructor-led version (live-online or traditional classroom), you'll additionally get

  • Instructor-led lectures.
  • Recordings of your instructor-led lectures (available after the class within your online self-paced course access), if you've opted for the live-online training format.

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

The course curriculum

The following is a list of broad topics covered

  • Course Introduction
  • Course Modules
  • Introduction to SQL Server 2012
  • SQL Server
  • SQL Server Tools
  • Management Studio Demo
  • Data Tools
  • Exam Scenarios
  • Module Review
  • Installing SQL Server
  • SQL Architecture
  • Hardware Requirements
  • Software Requirements
  • Installation Process
  • Troubleshooting Installation
  • Upgrading & Unattended Installations
  • Configuration Demo
  • Exam Scenarios
  • Module Review
  • Backup and Restore a Database
  • Database Architecture
  • Database Backup
  • Restoration Process
  • Restoring System Database
  • Backup and Recovery Demo
  • Exam Scenarios
  • Module Review
  • Tracing Access to SQL Server
  • Auditing Options
  • Introduction to SQL Audit
  • Audit Objects and Implementation
  • Extended Events
  • Tracing Activity Demo
  • Exam Scenarios
  • Module Review
  • Importing and Exporting Data
  • Introduction to Data Transfer
  • ETL Tools
  • Improving Data Transfer
  • Copying Database Methods
  • Transferring Data Demo
  • Exam Scenarios
  • Module Review
  • SQL Server Security
  • Security and Authentication
  • Server and Database Roles
  • Permissions
  • Securing SQL Server Demo
  • Exam Scenarios
  • Module Review
  • Automating SQL Server
  • SQL Server Agent
  • Database Mail
  • Operators, Alerts and Jobs
  • Database Configuration
  • 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
  • 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
  • Exam Scenarios
  • Module Review
  • Program Review