Designing a Data Solution with Microsoft SQL Server 2014 (M20465) M20465

Days: 3 day
Price: $2195

Course Details

In this course, you will learn to plan and implement enterprise database infrastructure solutions using Microsoft SQL Server 2014 and other Microsoft technologies. You will be introduced to Enterprise Data Architecture, multi-server configuration management, Data Collector and the SQL Server Utility Control Point (UCP). You’ll then delve into database solutions including: consolidating database workloads, cloud data, high availability, clustering, AlwaysOn Availability Groups, disaster recovery, and data replication.

This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20465 and covers the skills and knowledge measured by Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 and, in conjunction with on-the-job experience, can help you prepare for the exam.

Course Agenda

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