Microsoft 70-462: Administering SQL Server 2012 Databases

Buy Now

Price: $94.99

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.