20462: Administering Microsoft SQL Server 2014

This forty hours instructor-led 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 features and tools related to maintaining and correctly administer a database.

Audience(s):  IT Professionals
Technology:  Microsoft SQL Server
Duration:  40 hours

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

See Complete Content


Session 1  
Start Date:   April 25
End Date:   May 25
Day(s):   Wed, Fri
Hours: 2:00pm-6:00pm

More Information