- Courses & IT Certifications
- Microsoft Office Training
- Application Courses
- Microsoft Technical
- Technical Courses
- Business Courses
- Resources & Solutions
- News & Events
20462 Administering Microsoft SQL Server Databases
This five-day 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.
After completing this course, students will be able 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.