Administering Microsoft SQL Server 2014 Databases 70-462

New York City

Administering Microsoft SQL Server 2014 Databases: Course 20462D

Course Objectives:

• Describe core database administration tasks and tools.
• Install and configure SQL Server 2014.
• Configure SQL Server databases and storage.
• Plan and implement a backup strategy.
• Restore databases from backups.
• Import and export data. Monitor SQL Server.
• Trace SQL Server activity.
• Manage SQL Server security.
• Audit data access and encrypt data.
• Perform ongoing database maintenance.
• Automate SQL Server maintenance with SQL Server Agent Jobs.
• Configure Database Mail, alerts and notifications.

Course Content:

Introduction to SQL Server 2014 Database Administration

• Database Administration Overview
• Introduction to the SQL Server Platform
• Database Management Tools and Techniques

Installing and Configuring SQL Server 2014

• Planning SQL Server Installation
• Installing SQL Server 2014
• Post-Installation Configuration

Working with Databases and Storage

• Introduction to Data Storage with SQL Server
• Managing Storage for System Databases
• Managing Storage for User Databases
• Moving Database Files
• Configuring the Buffer Pool Extension

Planning and Implementing a Backup Strategy

• Understanding SQL Server Recovery Models
• Planning a Backup Strategy
• Backing up Databases and Transaction Logs
• Using Backup Options
• Ensuring Backup Reliability

Restoring SQL Server 2014 Databases

• Understanding the Restore Process
• Restoring Databases
• Advanced Restore Scenarios
• Working with Point-in-Time Recovery

Importing and Exporting Data

• Introduction to Transferring Data
• Importing and Exporting Table Data
• Copying or Moving a Database

Monitoring SQL Server 2014

• Introduction to Monitoring SQL Server
• Dynamic Management Views and Functions
• Performance Monitor

Tracing SQL Server Activity

• Tracing SQL Server Workload Activity
• Using Traces

Managing SQL Server Security

• Introduction to SQL Server Security
• Managing Server-Level Security
• Managing Database-Level Principals
• Managing Database Permissions

Auditing Data Access and Encrypting Data

• Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Implementing SQL Server Audit

Performing Ongoing Database Maintenance

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance

Automating SQL Server 2014 Management

• Automating SQL Server Management
• Implementing SQL Server Agent Jobs
• Managing SQL Server Agent Jobs
• Managing Job Step Security Contexts
• Managing Jobs on Multiple Servers

Monitoring SQL Server 2014 by Using Alerts and Notifications

• Monitoring SQL Server Errors
• Configuring Database Mail
• Configuring Operators, Alerts, and Notifications