Administering Microsoft® SQL Server® 2014 Databases

Current Status

Not Enrolled

Price

$1500

Get Started

Take this Course

Course Content

Expand All

MODULE 1

Database Administration Overview 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

What Makes a Good Database Administrator?

Common Database Administration Tasks

Documenting Database Management Procedures

Introduction to the SQL Server Platform 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

SQL Server Components

SQL Server Instances

SQL Server Editions

SQL Server Versions

Database Management Tools and Techniques 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

SQL Server Tools

SQL Server Management Studio

The sqlcmd Utility

Using Transact-SQL to Perform Management Tasks

Using Windows PowerShell to Manage SQL Server

MODULE 2

Planning SQL Server Installation 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Considerations for SQL Server Installation

Minimum Hardware and Software Requirements

Assessing CPU and Memory Requirements

Storage I/O Considerations

Planning Service Accounts

Installing SQL Server 2014 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Options for Installing SQL Server 2014

Performing an Installation of SQL Server 2014

Performing an Unattended Installation

Upgrading SQL Server

Post-Installation Configuration 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Performing Post-Installation Checks

Configuring Services and Network Protocols

Managing SQL Server Updates

MODULE 3

Introduction to Data Storage with SQL Server 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

How Data Is Stored in SQL Server

Considerations for Disk Storage Devices

RAID Levels

Determining File Placement and Number of Files

Ensuring Sufficient File Capacity

Managing Storage for System Databases 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

SQL Server System Databases

Moving System Databases

Considerations for tempdb

Demonstration: Moving tempdb Files

Managing Storage for User Databases 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Creating User Databases

Configuring Database Options

Demonstration: Creating Databases

Altering User Databases

Managing Database Files

Introduction to Filegroups

Creating and Managing Filegroups

Moving Database Files 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Moving User Database Files

Detaching and Attaching Databases

Demonstration: Detaching and Attaching a Database

Configuring the Buffer Pool Extension 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Introduction to the Buffer Pool Extension

Considerations for Using the Buffer Pool Extension

Configuring the Buffer Pool Extension

Demonstration: Configuring the Buffer Pool Extension

MODULE 4

Understanding SQL Server Recovery Models 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Overview of SQL Server Transaction Logs

Transaction Log File Structure

Working with Recovery Models

Capacity Planning for Transaction Logs

Working with Checkpoint Options

Demonstration: Logs and Full Recovery

Planning a Backup Strategy 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Backup Types

Determining Recovery Objectives

Full Database Backup Strategies

Transaction Log Backup Strategies

Differential Backup Strategies

Partial Backup Strategies

Discussion: Planning Backup Strategies

Backing up Databases and Transaction Logs 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Introduction to SQL Server Backup

Media Sets and Backup Sets

Performing Database Backups

Performing Transaction Log Backups

Performing Partial and Filegroup Backups

Demonstration: Performing Backups

Using Backup Options 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Copy-Only Backups

Compressing Backups

Demonstration: Using Backup Compression

Encrypting Backups

Demonstration: Using Backup Encryption

Ensuring Backup Reliability 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Determining a Retention and Testing Policy for Backups

Options for Ensuring Backup Integrity

Viewing Backup History

Retrieving Backup Metadata

Demonstration: Verifying Backups

MODULE 5

Understanding the Restore Process 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Phases of the Restore Process

Types of Restores

Preparations for Restoring Backups

Discussion: Determining Required Backups to Restore

Restoring Databases 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Restoring a Full Database Backup

Restoring a Differential Backup

Restoring Transaction Log Backups

Demonstration: Restoring Databases

Advanced Restore Scenarios 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Restoring File or Filegroup Backups

Restoring an Encrypted Backup

Demonstration: Restoring an Encrypted Backup

Restoring Data Pages

Recovering System Databases

Point-in-Time Recovery 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Overview of Point-in-Time Recovery

STOPAT Option

STOPATMARK Option

Performing a Point-in-Time Recovery by Using SQL Server Management Studio

Demonstration: Performing a Point-in-Time Recovery

1 of 3