Administering Microsoft SQL Server 2014 Databases (M20462)

In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.

This course incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server 2014 Databases. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job experience, helps you prepare for the exam.

Delivery Format:
Date:
Location:
Limited Time Offer: This course is 40% off! Use promo code CA40GTR at checkout.
Access Period:
Address:

QTY

Add to Cart Generate a Quote

Class is Full

This session is full. Please select a different session.

View Entire Schedule

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

Viewing outline for:

Classroom Live Outline

1. Introduction to SQL Server 2014 Database Administration

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

2. Installing and Configuring SQL Server 2014

Plan SQL Server Installation
Install SQL Server 2014 and Post-Installation Configuration

3. Work with Databases and Storage

Introduction to Data Storage with SQL Server
Manage Storage for System Databases and User Databases
Move Database Files
Configure the Buffer Pool Extension

4. Plan and Implement a Backup Strategy

SQL Server Recovery Models
Plan a Backup Strategy
Backup Databases and Transaction Logs
Backup Options and Backup Reliability

5. Restore SQL Server 2014 Databases

Restore Process and Databases Restoration
Advanced Restore Scenarios
Point-in-Tim Recovery

6. Import and Export Data

Transferring Data
Import and Export Table Data
Copy or Move a Database

7. Monitor SQL Server 2014

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

8. Tracing SQL Server Activity

Trace SQL Server Workload Activity and Use Traces

9. Manage SQL Server Security

Introduction to SQL Server Security
Manage Server-Level Security and Database-Level Principals
Manage Database Permissions

10. Audit Data Access and Encrypt Data

Audit Data Access in SQL Server
Implement SQL Server Audit
Encrypt Databases

11. Perform Ongoing Database Maintenance

Ensure Database Integrity
Maintain Indexes
Automate Routine Database Maintenance

12. Automate SQL Server 2014 Management

Implement and Manage SQL Server Agent Jobs
Manage Job Step Security Contexts
Manage Job on Multiple Servers

13. Monitor SQL Server 2014 Using Alerts and Notifications

Monitor SQL Server Errors
Configure Database Mail
Configure Operators, Alerts, and Notifications

Viewing labs for:

Classroom Live Labs

Lab 1: Use SQL Server Administrative Tools

SQL Server Management Studio and sqlcmd Utility
Windows PowerShell with SQL Server

Lab 2: Install SQL Server 2014

Prepare, Install, and Perform Post-Installation Configuration

Lab 3: Manage Database Storage

Configure tempdb Storage
Create and Attach a Database

Lab 4: Backup SQL Server Databases

Perform Database, Differential, Transaction Log, and Partial Backups

Lab 5: Restore SQL Server Database

Restore Database, Differential, and Transaction Log Backups
Piecemeal Restorations

Lab 6: Import and Export Data

SQL Server Import and Export Wizard
bcp Utility
BULK INSERT Statement and OPENROWSET Function

Lab 7: Monitor SQL Server 2014

Collect Baseline Metrics
Monitor a Workload

Lab 8: Trace SQL Server Workload Activity

Capture a Trace in SQL Server Profiler
Generate Database Tuning Recommendations
SQL Trace

Lab 9: Manage SQL Server Security

Manage Server-Level and Database-Level Security
Test Database Access

Lab 10: Audit Data Access and Encrypting Data

Implement and Manage SQL Server Audit
Implement Transparent Data Encryption

Lab 11: Perform Ongoing Database Maintenance

Manage Database Integrity and Index Fragmentation
Implement a Maintenance Plan

Lab 12: Automate SQL Server Management

Create and Schedule a Job
Configure Job Step Security Contexts

Lab 13: Monitor SQL Server Using Alerts and Notifications

Configure Database Mail
Implement Operators, Notifications, and Alerts

Basic knowledge of Microsoft Windows operations systems and its core functionality
Working knowledge of Transact-SQL and relational databases
Experience with database design

Querying Microsoft SQL Server 2014 (M20461)

Database professionals who administer and maintain SQL Server databases including database maintenance
Database professionals who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from SQL Server databases

This course also offers Microsoft SATVs

Training Exclusives

This course comes with 12 months access to the following benefits:

Practice Labs
Indexed Class Recordings
Unlimited Retakes
Digital Courseware

Find out more

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

5 SATVs for a Classroom Live or Virtual Classroom Live session
2 SATVs for an individual On-Demand course
5 SATVs for an individual On-Demand course plus digital Microsoft Official Courseware (dMOC)

Find out more

Course Delivery

This course is available in the following formats:

Request this course in a different delivery format.

Download Course Details

Cart () Loading...

Subtotal

Topics

Brands

Topics

Brands

Subtotal