Overview

The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Windows Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

Duration

5 Days

Target Audience

This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:

Planning and implementing database infrastructure.
Planning and implementing consolidation strategies.
Implementing SQL Server in on-premises, cloud, and hybrid IT scenarios.
Planning and implementing high availability solutions.
Planning and implementing disaster recovery solutions

Topics

Introduction to Enterprise Data Architecture

Multi-Server Configuration Management

Consolidating Database Workloads with SQL Server 2014

Introduction to Cloud Data Solutions

Introduction to Windows Azure

Windows Azure SQL Database

SQL Server in Windows Azure Virtual Machines

Introduction to High Availability in SQL Server 2014

Clustering with Windows Server and SQL Server 2014

AlwaysOn Availability Groups

Planning High Availability and Disaster Recovery

Replicating Data