Administering Microsoft SQL Server 2014 Databases

IT Certification Courses

Why Microsoft SQL Server Training

Opportunities: Learn to manage your organization’s data and reap the rewards of a lucrative and challenging role as a database manager.
High-Demand: The ability to store, manage and protect data is a highly-demanded skill set. Earn the MCSA SQL Server certification and meet the demand.
Globally Recognised: Microsoft certifications are globally renowned qualifications that provide endless opportunities for database managers.

Administering Microsoft SQL Server 2014 Databases Training

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.

Skills Gained

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

Who Can Benefit

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

Prerequisites

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

Course Details

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

2016-02-25 08:26:00.593000000