Administering Microsoft SQL Server 2014 Databases Training (20462)

This official Microsoft five-day instructor-led Administering Microsoft SQL Server 2014 Databases (20462) course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. While the course focuses on teaching individuals how to use the new SQL Server 2014 product features and tools related to maintaining a database, it also covers the important capabilities across the SQL Server data platform.

Plus, get prepped for Microsoft exam 70-462, a requirement for MCSA: SQL Server 2012/2014.

You Will Learn How To:

• Describe core database administration tasks and tools.
• Install and configure SQL Server 2014.
• Configure SQL Server databases and storage.
• Plan and implement a backup strategy.
• Restore databases from backups.
• Import and export data. Monitor SQL Server.
• Trace SQL Server activity.
• Manage SQL Server security.
• Audit data access and encrypt data.
• Perform ongoing database maintenance.
• Automate SQL Server maintenance with SQL Server Agent Jobs.
• Configure Database Mail, alerts and notifications.

• On-Demand Training Description

  With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.

  PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!

  • Flexibility to take the course on your own time, at your own pace
  • Forever access to the digital course materials – for any refreshers
  • You will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months
  • Upon course activation, the MOC On Demand videos and labs are available for three months
  • 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
  • This delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)
  • NOTE: Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit

• Requirements

  • Before attending this course, students must have:
    • Knowledge and experience working with Windows PowerShell or knowledge equivalent to the content covered in course 8459: Automating Administration With Windows PowerShell Training (10961)
    • Experienced in general Windows Server and Windows Client administration or already have experience in administering and supporting Application servers and services including applications like Exchange, SharePoint, and SQL.

• Exam Information

  This course can help you prepare for the following Microsoft certification exam — 70-462: Administering Microsoft SQL Server 2012/2014 Databases

• Redeem Your Microsoft Training Vouchers (SATV):

  • This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
  • Want to learn more about Microsoft SATVs? Click to view our SATVs infographic.