On-Demand learning...
be In-Demand and earning.

Microsoft 70-462: Administering SQL Server 2012 Databases

Course Description

This trainig 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, 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 QuickCert 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

Language:

English

Type of Course:

Self Paced

eCertIT is committed to ensuring that your investment in IT learning is well rewarded with:

• Expert instructor led training
• Virtual Labs – practice 24 X 7 in your own, live, test environment
• Practice exams, test your knowledge with certification type exam questions
• Community Forum to share experiences and knowledge
• Australian support
• Multiple certification offerings at reduced cost