MOC On-Demand: Administering Microsoft SQL Server 2014 Databases

MOC On-Demand 

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Administering Microsoft® SQL Server® 2014 Databases

About this course

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 data-base. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a data-base. 

Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server data-bases. These individuals perform data-base administration and maintenance as their primary area of responsibility, or work in environments where data-bases play a key role in their primary job.

At Course Completion:

At the completion of this course participants will be able to:

  • describe core data-base administration tasks and tools
  • install and configure SQL Server 2014
  • configure SQL Server data-bases and storage
  • plan and implement a backup strategy
  • restore data-bases 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 data-base maintenance
  • automate SQL Server maintenance with SQL Server Agent Jobs
  • configure Data-base Mail, alerts and notifications.
  • Additional Resources:

    Instructor-led Training: 20462 Administering Microsoft SQL Server 2014 Databases

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: OD20462
  • Duration: 90 Days
  • Price: $1,089.00

Next Step

Enquire Now
Tell a Friend