Overview
This 3-day instructor-led course focuses on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. This course describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.
Prerequisites
Participants who wish to take up 20465: Designing Solutions for SQL Server should 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
Who Should Attend?
This course is intended for database professionals who need to plan, implement, and manage database solutions which includes:
- Planning and implementing database infrastructure
- Planning and implementing consolidation strategies
- Planning and implementing high availability solutions
- Planning and implementing disaster recovery solutions
This course is also designed for customers who are interested in learning SQL Server.
Course Outline
- Considerations for Enterprise Data
- Assessing an Existing Infrastructure
Lab: Assessing an Existing Enterprise Data Infrastructure
- Policy-Based Management
- Microsoft System Center
Lab: Planning and Implementing Policy-Based Management
- Introducing to Health Monitoring
- Data Collector
- SQL Server Utility
Lab: Monitoring SQL Server Health
- Considerations for Database Server Consolidation
- Managing Resources in a Consolidated Database Infrastructure
Lab: SQL Server Consolidation
- Overview of Cloud Computing
- SQL Server in a Private Cloud
Lab: Preparing a SQL Server Installation in a Virtual Machine Template
- High Availability Concepts and Options in SQL Server 2014
- Log Shipping
Lab: Using Log Shipping
- Introduction to Windows Server Failover Clustering
- SQL Server AlwaysOn Failover Cluster Instances
Lab: Implementing an AlwaysOn Failover Cluster Instance
- Introduction to AlwaysOn Availability Groups
- Working with AlwaysOn Availability Groups
- Considerations for Using AlwaysOn Availability Groups
Lab: Implementing and Testing an AlwaysOn Available Group
- High Availability and Disaster Recovery with SQL Server 2014
- SQL Server High Availability and Disaster Recovery Solutions
Lab: Planning High Availability and Disaster Recovery
- SQL Server Replication
- Planning Replication
Lab: Planning and Implementing Replication