Overview

This five-day 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 product features and tools related to maintaining a database.

Duration

5 Days

Target Audience

This course requires that you meet the following prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.

Topics

Installing SQL Server 2014

Working with Databases

SQL Server 2014 Recovery Models

Backup of SQL Server 2014 Databases

Restoring SQL Server 2014 Databases

Importing and Exporting Data

Authenticating and Authorizing Users

Assigning Server and Database Roles

Authorizing Users to Access Resources

Protecting Data by Using Encryption and Auditing

Automating SQL Server 2014 Management

Configuring Security for SQL Server Agent

Monitoring SQL Server 2014 by Using Alerts and Notifications

Performing Ongoing Database Maintenance

Tracing Access to SQL Server 2014

Monitoring SQL Server 2014