• Online, Self-Paced
Course Description

Backup and recovery planning are key to any organizations who implement SQL Server 2014. This course covers backup and recovery, how to create and maintain a disaster recovery plan, and configuration and management of SQL Server replication. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform.

Learning Objectives

SQL Server 2014 Backup

  • start the course
  • recognize the various backup types available in SQL Server 2014
  • describe the different SQL Server 2014 recovery models
  • describe the different backup strategies available in SQL Server 2014
  • perform a backup of a SQL Server 2014 database
  • perform a backup of a SQL Server 2014 database to Azure Blob Storage

SQL Server 2014 Restore

  • describe the SQL Server 2014 restore process
  • recognize the process sequences for restoring SQL Server 2014 databases
  • restore a SQL Server 2014 database
  • restore a SQL Server 2014 database to a point in time
  • restore a SQL Server 2014 database from Windows Azure Blob Storage
  • backup and restore a Windows Azure SQL database

Disaster Recovery Planning

  • describe the considerations for creating a disaster recovery plan
  • describe the considerations for verifying a disaster recovery plan
  • describe the considerations for maintaining a disaster recovery plan

Replication Overview

  • describe SQL Server 2014 replication
  • describe SQL Server 2014 snapshot and transactional replication
  • describe SQL Server 2014 peer-to-peer transactional and merge replication
  • describe the function of agents in SQL Server 2014 replication
  • describe the considerations for security in SQL Server 2014 replication

Implementing Replication

  • configure SQL Server 2014 replication
  • validate a SQL Server 2014 replication configuration

Practice: SQL Backup and Recovery

  • Plan SQL Server Backup and Recovery

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.