1 – Introduction to Enterprise Data Architecture
- Considerations for Enterprise Data
- Assessing an Existing Infrastructure
- Lab : Assessing an Existing Enterprise Data Infrastructure
2 – Multi-Server Configuration Management
- Policy-Based Management
- Microsoft System Center
- Lab : Planning and Implementing Policy-Based Management
3 – Consolidating Database Workloads with SQL Server 2014
- Considerations for Database Server Consolidation
- Managing Resources in a Consolidated Database Infrastructure
- Lab : SQL Server Consolidation
4 – Introduction to Cloud Data Solutions
- Overview of Cloud Computing
- SQL Server in a Private Cloud
- Lab : Preparing a SQL Server Installation in a Virtual Machine Template
5 – Introduction to Microsoft Azure
- Microsoft Azure Overview
- Microsoft Azure Storage
- Lab : Using Microsoft Azure
6 – Microsoft Azure SQL Database
- Introduction to Microsoft Azure SQL Database
- Microsoft Azure SQL Database Security
- Implementing and Managing Databases
- Lab : Using Microsoft Azure SQL Database
7 – SQL Server in Microsoft Azure Virtual Machines
- Introduction to Microsoft Azure Virtual Machines
- Microsoft Azure Virtual Machine Connectivity and Security
- Creating Databases in a Microsoft Azure Virtual Machine
- Lab : Using Microsoft Azure Virtual Machines
8 – Introduction to High Availability in SQL Server 2014
- High Availability Concepts and Options in SQL Server 2014
- Log Shipping
- Lab : Using Log Shipping
9 – Clustering with Windows Server and SQL Server 2014
- Introduction to Windows Server Failover Clustering
- SQL Server AlwaysOn Failover Cluster Instances
- Lab : Implementing an AlwaysOn Failover Cluster Instance
10 – AlwaysOn Availability Groups
- Introduction to AlwaysOn Availability Groups
- Working with AlwaysOn Availability Groups
- Considerations for Using AlwaysOn Availability Groups
- Lab : Implementing and Testing an AlwaysOn Availability Group
11 – Planning High Availability and Disaster Recovery
- High Availability and Disaster Recovery with SQL Server 2014
- High Availability and Disaster Recovery for Databases in Microsoft Azure
- Lab : Planning High Availability and Disaster Recovery
12 – Replicating Data
- SQL Server Replication Planning Replication
- Lab : Planning and Implementing Replication
