Administering SQL Server Database
Course Overview
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.
- Module 1: Introduction to SQL Server 2014 Database Administration
- Module 2: Installing and Configuring SQL Server 2014
- Module 3: Working with Databases and Storage
- Module 4: Planning and Implementing a Backup Strategy
- Module 5: Restoring SQL Server 2014 Databases
- Module 6: Importing and Exporting Data
- Module 7: Monitoring SQL Server 2014
- Module 8: Tracing SQL Server Activity
- Module 9: Managing SQL Server Security
- Module 10: Auditing Data Access and Encrypting Data
- Module 11: Performing Ongoing Database Maintenance
- Module 12: Automating SQL Server 2014 Management
- Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
