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
| Session 1 | ||||
| Start Date: | April 25 | |||
| End Date: | May 25 | |||
| Day(s): | Wed, Fri | |||
| Hours: | 2:00pm-6:00pm | |||
