Microsoft 20465 – Designing a Data Solution with Microsoft SQL Server

In this course you will learn how to plan and implement enterprise database infrastructure solutions making use of Microsoft SQL Server 2012 and 2014.

You will also take a look at Enterprise Data Architecture along with multi-server configuration management.

Other topics covered in this course include consolidating database workloads, cloud data, Microsoft Azure services, high availability, clustering AlwaysOn Availability, disaster recovery and data replication.

Who needs to attend

Who needs to attend?
This course is aimed at anyone whose responsibilities include designing database solutions.

what you will learn

What you will learn
Upon completion you will know how to:

  • Access an Existing Enterprise Environment
  • Plan and Implement Policy-Based Management
  • Consolidation Workloads
  • Private Cloud Considerations
  • Microsoft Azure Storage
  • Implement and Configure Databases in Microsoft Azure Database and in Microsoft Azure Virtual Machines
  • Windows Server Failover Clustering and AlwaysOn Failover Cluster Instance
  • AlwaysOn Availability Groups Implementation
  • High Availability and Disaster Recovery Solutions
  • Plan and Implement Database Replication

Students need to have:

  • You should have technical knowledge of relational databases, including
  • Database planning, implementation, and management
  • Querying with Transact-SQL
  • Basic knowledge of high availability, disaster recovery, and Microsoft Azure technologies around cloud computing
  • Administering Microsoft SQL Server 2012 Databases (M10775)
  • Developing Microsoft SQL Server 2012 Databases (M10776)
Course outline

Course Outline

1. Introduction to Enterprise Data Architecture

Enterprise Data Considerations
Access an Existing Infrastructure

2. Multi-Server Configuration Management

Policy-based Management
Microsoft System Center

3. Consolidate Database Workloads with SQL Server 2014

Database Server Consolidation Considerations
Resource Management in a Consolidated Database Infrastructure

4. Introduction to Cloud Data Solutions

Cloud Computing
SQL Server in a Private Cloud

5. Introduction to Microsoft Azure

Microsoft Azure Overview and Microsoft Storage

6. Microsoft Azure SQL Database

Introduction to Microsoft Azure SQL Database
Microsoft Azure SQL Database Security
Implement and Manage Databases

7. SQL Server in Microsoft Azure Virtual Machines

Introduction to Microsoft Azure Virtual Machines
Microsoft Azure Virtual Machine Connectivity and Security
Create Databases in a Microsoft Azure Virtual Machine

8. Introduction to High Availability in SQL Server 2014

High Availability Concepts and Options in SQL Server 2014
Log Shipping

9. Clustering with Windows Server and SQL Server 2014

Introduction to Windows Server Failover Clustering
SQL Server AlwaysOn Failover Cluster Instances

10. Automating Multi-Server Maintenance AlwaysOn Availability Groups

AlwaysOn Availability Groups Introduction and Considerations

11. Plan High Availability and Disaster Recover

High Availability and Disaster Recovery with SQL Server 2014
High Availability and Disaster Recovery for Databases in Microsoft Azure

12. Replicating Data

SQL Server Replication
Planning Replication

Follow on
There are no follow-ons for this course.

Certification programs
MCSE: Data Platform