Microsoft 70-462: Administering SQL Server 2012 Databases

Course details

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.

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, columnstores 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 Adminstering 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

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.