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.