Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

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.

Click here to print this page »

Prerequisites


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