GK6553A Administering Microsoft SQL Server 2014 Databases (20462_D)

0% of 38 hours and 15 minutes completed.

In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.

This course incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server 2014 Databases. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job experience, helps you prepare for the exam.

After completing this course, you will be able to:

  • 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
There are no resources available.
0 attachments
0%
Introduction to SQL Server 2014 Database Administration
3 hours 28 minutes 23 Activities: Article  (0)  |  Lab  (9)  |  Video  (14)
0%
Installing and Configuring SQL Server 2014
2 hours 6 minutes 23 Activities: Article  (0)  |  Lab  (9)  |  Video  (14)
0%
Working with Databases and Storage
2 hours 58 minutes 34 Activities: Article  (0)  |  Lab  (9)  |  Video  (25)
0%
Planning and Implementing a Backup Strategy
3 hours 55 minutes 37 Activities: Article  (0)  |  Lab  (9)  |  Video  (28)
0%
Restoring SQL Server 2014 Databases
2 hours 44 minutes 26 Activities: Article  (0)  |  Lab  (9)  |  Video  (17)
0%
Importing and Exporting Data
2 hours 41 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Monitoring SQL Server 2014
2 hours 55 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Tracing SQL Server Activity
2 hours 14 minutes 25 Activities: Article  (0)  |  Lab  (9)  |  Video  (16)
0%
Managing SQL Server Security
3 hours 37 minutes 30 Activities: Article  (0)  |  Lab  (9)  |  Video  (21)
0%
Auditing Data Access and Encrypting Data
2 hours 26 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Performing Ongoing Database Maintenance
2 hours 8 minutes 27 Activities: Article  (0)  |  Lab  (9)  |  Video  (18)
0%
Automating SQL Server 2014 Management
2 hours 22 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Monitoring SQL Server 2014 with Notifications and Alerts
2 hours 39 minutes 26 Activities: Article  (0)  |  Lab  (9)  |  Video  (17)
0%
Appendix A - Troubleshooting Common Administrative Issues
37 minutes 16 Activities: Article  (0)  |  Lab  (8)  |  Video  (8)
0%
Appendix B - Installation Considerations
47 minutes 20 Activities: Article  (0)  |  Lab  (8)  |  Video  (12)
0%
Course Conclusion: GK6553A Administering Microsoft SQL Server 2014 Databases
2 minutes 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
Knowledge Assessment: End of Course Questions
25 minutes 25 Activities: Article  (0)  |  Lab  (25)  |  Video  (0)
0%
Survey
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)