Administering Microsoft® SQL Server® 2014 Databases

5 Weeks
All levels
0 lessons
0 quizzes
0 students

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

What You’ll Learn:

  • 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.