Administering Microsoft SQL Server 2012 Databases (Microsoft 70-462 Course)

Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$376

Course Overview

Microsoft 70-462: Administering Microsoft SQL Server 2012 Databases

Expand and prove your ability to work with Microsoft SQL Server 2012 with our engaging, tutor-led course.

Administering Microsoft SQL Server 2012 Databases 70-462 exam is part two of a three part series of courses to validate your skills and knowledge essential to install, maintain, and configure Windows SQL Server 2012.

Microsoft 70-462: Administering Microsoft SQL Server 2012 Databases

What will I 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 analyse 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

What do I Get?

  • Expert, instructor-led training delivered via video streaming
  • Extensive demonstrations and presentations delivered in a multimedia format
  • Practice tests and full exam simulators
  • Unlimited access to the course for 1 year

Who should take this course

Anyone interested to learn this course.

Accreditation

Administering Microsoft SQL Server 2012 Databases, Accredited by Microsoft

Course content

Course Outline

  • Module 1 - Introduction to SQL Server 2012
  • Module 2 - Installing SQL Server
  • Module 3 - Backup and Restore a Database
  • Module 4 - Tracing Access to SQL Server
  • Module 5 - Importing and Exporting Data
  • Module 6 - SQL Server Security
  • Module 7 - Automating SQL Server
  • Module 8 - Monitoring SQL Server
  • Module 9 - Maintaining SQL Server
  • Module 10 - Troubleshooting SQL Server

About Course Provider

Located in Sittingbourne, Kent in the United Kingdom, ITonlinelearning was founded by Jeremy Dargie in 2009. Our aim is to help both aspiring and seasoned professionals gain internationally recognised, accredited certifications that enable them to begin and develop their careers and develop into sought after and well-versed professionals.

We are able to tailor your courses to your specific needs, giving you the opportunity to study courses on offer from world-leading companies such as Microsoft, Cisco, CompTIA, PRINCE2, Adobe, NEBOSH and CIW, to name but a few. These certifications will help you, like thousands others, reach your certification goals and beyond, ensuring that you develop your chosen career into a lucrative and rewarding profession.