merger merger

Welcome to your new course portal!

On October 15th, moved to - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show as: Mobile

Microsoft 70-462: Administering SQL Server 2012 Databases

Course summary
229 GBP
e-learning / Online / Distance

Course description

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 unauthorized access is also a candidate for this training course on SQL 2012.

Below is a partial list of job functions associated to this training course:
  • Audit SQL Server instances
  • Back up databases
  • Configure additional SQL Server components, Instances and Services
  • Deploying a SQL Server
  • Implementing strategies, column stores and High-Availability and Disaster Recovery solutions
  • Importing/exporting
  • Install SQL Server and related services.
  • Maintenance
  • Management, configuration, permissions, alerts, logins and roles.
  • Optimization
  • Installation Planning
  • Restoring
  • Troubleshooting
The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 - As the participant in the SQL 2012 Administering course will learn:
  • Installation Planning
  • Installing SQL Server and related services
  • Implementation of a migration strategy
  • How to configure additional SQL Server components
  • Managing the SQL Server Agent
  • Database management and configuration
  • How to configure SQL Server instances
  • Implementing a SQL Server clustered instance
  • SQL Server instances management
  • How to properly Identify and resolve concurrency problems
  • The collection of and how to analyze troubleshooting data
  • Auditing SQL Server instances
  • Configure and maintain a back up strategy
  • Database restoration
  • Implementing and maintaining indexes
  • Importing and exporting data
  • Managing logins and server roles
  • Managing database permissions
  • Managing users and database roles
  • Troubleshooting security
  • Implementing AlwaysOn, database mirroring and replication


Module 1
  • Introduction to SQL Server 2012
  • SQL Server
  • SQL Server Tools
  • Management Studio Demo
  • Data Tools
  • Exam Scenarios
  • Module Review

Module 2
  • Installing SQL Server
  • SQL Architecture
  • Hardware Requirements
  • Software Requirements
  • Installation Process
  • Troubleshooting Installation
  • Upgrading and Unattended Installations
  • Configuration Demo
  • Exam Scenarios
  • Module Review
Module 3
  • Backup and Restore a Database
  • Database Architecture
  • Database Backup
  • Restoration Process
  • Restoring System Database
  • Backup and Recovery Dem0
  • Exam Scenarios
  • Module Review
Module 4
  • Tracing Access to SQL Server
  • Auditing Option
  • Introduction to SQL Audit
  • Audit Objects and Implementation
  • Extended Events
  • Tracing Activity Demo
  • Exam Scenarios
  • Module Review

Module 5
  • Importing and Exporting Data
  • Introduction to Data Transfer
  • ETL Tools
  • Improving Data Transfer
  • Copying Database Methods
  • Transferring Data Demo
  • Exam Scenarios
  • Module Review
Module 6
  • SQL Server Security
  • Security and Authentication
  • Server and Database Roles
  • Permissions
  • Securing SQL Server Demo
  • Exam Scenarios
  • Module Review
Module 7
  • Automating SQL Server
  • SQL Server Agent
  • Database Mail
  • Operators, Alerts and Jobs
  • Database Configuration Demo
  • 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
  • Exam Scenarios
  • Module Review
Module 9
  • Maintaining SQL Server
  • Checking Database Integrity
  • Indexing
  • Ongoing Maintenance
  • Managing and Maintaining Demo
  • Exam Scenarios
  • Module Review
Module 10
  • Troubleshooting SQL Server
  • Service Issues
  • Connectivity Issues
  • Locking Issues
  • Troubleshooting Demo
  • Exam Scenarios
  • Module Review
  • Program Review
Course Delivery:    Online

About provider

Hudson - Leaders in Learning

Hudson provide high spec e-learning to the consumer and corporate market all over the world. The majority of our online training is accessible across most devices including laptop, desktop, tablet, and smart phones. Our courses are designed to fit around...

Read more and show all courses with this provider

Customer Outreach Award 2019


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Request info

Fill out your details to find out more about Microsoft 70-462: Administering SQL Server 2012 Databases.

  Contact the provider

  Get more information

  Register your interest

Request Information

Find out more about this Microsoft 70-462: Administering SQL Server 2012 Databases course - simply fill out your details:


There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in's second annual U.K. L&D Report!


Learn more