Module 1: Introduction to Enterprise Data Architecture
- Considerations for Enterprise Data
- Assessing an Existing Infrastructure
Lab: Assessing an Existing Enterprise Data Infrastructure
Module 2: Multi-Server Configuration Management
- Policy-Based Management
- Microsoft System Center
Lab: Planning and Implementing Policy-Based Management
Module 3: Monitoring SQL Server 2014 Health
- Introduction to Health Monitoring
- Data Collector
- SQL Server Utility
Lab: Monitoring SQL Server Health
Module 4: Consolidating Database Workloads with SQL Server 2014
- Considerations for Database Server Consolidation
- Managing Resources in a Consolidated Database Infrastructure
Lab: SQL Server Consolidation
Module 5: 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
Module 6: Introduction to High Availability in SQL Server 2014
- High Availability Concepts and Options in SQL Server 2014
- Log Shipping
Lab: Using Log Shipping
Module 7: 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
Module 8: 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
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
Lab: Planning High Availability and Disaster Recovery
Module 10: Replicating Data
- SQL Server Replication
- Planning Replication
Lab: Planning and Implementing Replication