MS-20465 - Designing Solutions for Microsoft SQL Server

This course describes how to design and monitor high performance, highly available enterprise data solutions with SQL Server 2014. This course focuses on database server infrastructure scenarios, including private, public, and hybrid cloud solutions and high availability techniques. Microsoft Azure is required or used as part of the lab for this course, which may not be available in all countries. Please check with your Microsoft training provider that this cloud service is available in your area. Training Providers please reference the course setup guide for more details.

*This course utilizes higher hosting resources for online labs and therefore, post-class access is limited to 30 days.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


This course requires that you meet the following prerequisites:
  • At least 2 years’ experience of working with relational databases, including:
  • Planning and implementing databases
  • Managing databases
  • Querying with Transact-SQL
  • Some basic knowledge of high availability and disaster recovery

Detailed Class Syllabus

Module 1: Introduction to Enterprise Data Architecture

Considerations for Enterprise Data
Assessing an Existing Infrastructure

Module 2: Multi-Server Configuration Management

Policy-Based Management
Microsoft System Center

Module 3: Monitoring SQL Server 2014 Health

Introduction to Health Monitoring
Data Collector
SQL Server Utility

Module 4: Consolidating Database Workloads with SQL Server 2014c

Considerations for Database Server Consolidation
Managing Resources in a Consolidated Database Infrastructure

Module 5: Introduction to Cloud Data Solutions

Overview of Cloud Computing
SQL Server in a Private Cloud

Module 6: Introduction to High Availability in SQL Server 2014

High Availability Concepts and Options in SQL Server 2014
Log Shipping

Module 7: Clustering with Windows Server and SQL Server 2014

Introduction to Windows Server Failover Clustering
SQL Server AlwaysOn Failover Cluster Instances

Module 8: AlwaysOn Availability Groups

Introduction to AlwaysOn Availability Groups
Working with AlwaysOn Availability Groups
Considerations for Using AlwaysOn Availability Groups

Module 9: Planning High Availability and Disaster Recovery

High Availability and Disaster Recovery with SQL Server 2014
SQL Server High Availability and Disaster Recovery Solutions

Module 10: Replicating Data

SQL Server Replication
Planning Replication