70-462 Administering MS-SQL server 2012 Databases

Exam 70-462 Administering Ms-Sql server 2012 Databases is designed for the professionals who wanted to brush their knowledge and skills in maintaining a Microsoft SQL Server 2012 database. Mostly, the audiences who attend this course are the ones who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

Whereas, the secondary audience for this course are those professionals who develop applications that deliver content from SQL Server databases.

Added as a prerequisite, candidates who like to attend this course shall have the following technical knowledge, alongside their professional experience:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

Mentioned below pointers shows the topics being covered in the examination, with the relevant percentage: Install and configure (19%)

• Plan installation
• Install SQL Server and related services
• Implement a migration strategy
• Configure additional SQL Server components
• Manage SQL Server Agent

Maintain instances and databases (17%)

• Manage and configure databases
• Configure SQL Server instances
• Implement a SQL Server clustered instance
• Manage SQL Server instances

Optimize and Troubleshoot (14%)

• Identify and resolve concurrency problems
• Collect and analyze troubleshooting data
• Audit SQL Server instances

Manage data (19%)

• Configure and maintain a back-up strategy
• Restore databases
• Implement and maintain indexes
• Import and export data

Implement security (18%)

• Manage logins and server roles
• Manage database permissions
• Manage users and database roles
• Troubleshoot security

Implement high availability (12%)
Implement AlwaysOn

• Implement a mirroring solution using AlwaysOn; failover

Implement database mirroring

• Set up mirroring; monitor the performance of database mirroring
• Troubleshoot replication problems; identify appropriate replication strategy

Nettech India

Contact us

If you want more information fill in this form. You will be contacted as soon as possible. Please fill in all required fields.

Name*
Email*
Mobile*
Message*
Send a copy to my own email address