20465C - Designing Database Solutions for Microsoft SQL Server 2014
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
A more comprehensive course outline is available in the Course Download section, to the right of this page.