course-deatils-thumbnail

Designing Solutions for Microsoft SQL Server 2014

Course Code: 5031

|

|

Overview
Schedule classes
What you'll learn
Outline
Prerequisites
Who should attend

Overview

This three-day, instructor-led course discusses about planning and implementing enterprise database infrastructure solutions by using the SQL Server 2014 and other Microsoft technologies. It covers how to consolidate SQL Server workloads, as well as, how to plan and implement high availability and disaster recovery solutions. The course is helpful for participants interested in learning SQL Server 2012 or SQL Server 2014.

Schedule Classes

Looking for more sessions of this class?

Microsoft

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 5 days

Live Virtual Classroom
Duration: 5 days

What You'll learn

Assess an existing enterprise environment
Plan and implement Policy-Based Management
Describe the considerations for consolidating workloads with SQL Server 2014
Describe considerations for including SQL Server 2014 in a private cloud

Outline

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

View More

Prerequisites

Participants for this course need to have –

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

The course is highly recommended for –

System engineers
Software engineers
Database administrators
Software developers
.Net developers

Interested in this course? Let’s connect!

Popular Technologies In Demand

Modeling Techniques for Business Analysts

Introduction to Data Analysis

Developing SQL data models

Red Hat JBoss Data Virtualization Development

5G Essentials

Explore Courses Pink Cheveron Right

Pink Cheveron Right

Get future
Insights

Subscribe to our newsletter for updates on our latest opportunities, courses and events.