Modular Course (Select your Modules)


   In this course students will provided by 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.

Introduction, Installation & Configuration (1 day)

• Introduction to SQL Server 2014 Database Administration

• Installing and Configuring SQL Server 2014

• Working with Databases and Storage

Backup/Restore & Import/Export (1 day)

• Planning and Implementing a Backup Strategy

• Restoring SQL Server 2014 Databases

• Importing and Exporting Data

Monitoring and Tracing (1 day)

• Monitoring SQL Server 2014

• Tracing SQL Server Activity

Security, Audit & Encryption (1 day)

• Managing SQL Server Security

• Auditing Data Access and Encrypting Data

Automation (1 day)

•Performing Ongoing Database Maintenance

•Automating SQL Server 2014 Management

•Monitoring SQL Server 2014 by Using Alerts and Notifications