20465 Designing Database Solutions for Microsoft SQL Server
20465 Designing Database Solutions for Microsoft SQL Server
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
20465 Designing Database Solutions for Microsoft SQL Server
- 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
