20465C - Designing Database Solutions for Microsoft SQL Server 2014

20465C - Designing Database Solutions for Microsoft SQL Server 2014


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.


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


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

A more comprehensive course outline is available in the Course Download section, to the right of this page.

Course Details

Course Ref:


Course Duration:

5 Days

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk