MOC 20465 - Designing Database Solutions for Microsoft SQL Server 2014

Print

Request an offer for classroom delivery of this course

Online Registration and Course delivery

Course duration

Course Outline

The focus of this Designing Database Solutions for Microsoft SQL Server 2014 training class is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

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

This course is intended for database professionals who need who plan, implement, and manage database solutions.

  1. Introduction to Enterprise Data Architecture
    1. Considerations for Enterprise Data
    2. Assessing an Existing Infrastructure
    3. Lab: Assessing an Existing Enterprise Data Infrastructure
      1. Using the MAP Toolkit
      2. Reviewing MAP Toolkit Reports
  2. Multi-Server Configuration Management
    1. Policy-Based Management
    2. Microsoft System Center
    3. Planning and Implementing Policy-Based Management
      1. Planning a Policy-Based Management Strategy
      2. Implementing Policy-Based Management
      3. Testing Policy Compliance
  3. Consolidating Database Workloads with SQL Server 2014
    1. Considerations for Database Server Consolidation
    2. Managing Resources in a Consolidated Database Infrastructure
    3. Lab: SQL Server Consolidation
      1. Preparing for Database Consolidation
      2. Managing Resources for an Instance of SQL Server
      3. Managing Resources for Multiple Instances on a Windows Server
  4. Introduction to Cloud Data Solutions
    1. Overview of Cloud Computing
    2. SQL Server in a Private Cloud
    3. Lab : Preparing a SQL Server Installation in a Virtual Machine Template
      1. Creating a Prepared Instance
      2. Completing a Prepared Instance
  5. Introduction to Microsoft Azure
    1. Microsoft Azure Overview
    2. Microsoft Azure Storage
    3. Lab : Using Microsoft Azure
      1. Creating a Microsoft Azure Storage Account
      2. Backing Up a Database to Microsoft Azure
  6. Microsoft Azure SQL Database
    1. Introduction to Microsoft Azure SQL Database
    2. Microsoft Azure SQL Database Security
    3. Implementing and Managing Databases
    4. Lab : Using Microsoft Azure SQL Database
      1. Provisioning Microsoft Azure SQL Database
      2. Configuring Microsoft Azure SQL Database Security
      3. Migrating a Database to Microsoft Azure SQL Database
  7. SQL Server in Microsoft Azure Virtual Machines
    1. Introduction to Microsoft Azure Virtual Machines
    2. Microsoft Azure Virtual Machine Connectivity and Security
    3. Creating Databases in a Microsoft Azure Virtual Machine
    4. Lab : Using Microsoft Azure Virtual Machines
      1. Creating a Microsoft Azure Virtual Machine
      2. Configuring Microsoft Azure Virtual Machines Security and Connectivity
      3. Creating Databases on a Virtual Machine
  8. Introduction to High Availability in SQL Server 2014
    1. High Availability Concepts and Options in SQL Server 2014
    2. Log Shipping
    3. Lab : Using Log Shipping
      1. Configure Log Shipping
      2. Test the Log Shipping Configuration
      3. Test Failover
  9. Clustering with Windows Server and SQL Server 2014
    1. Introduction to Windows Server Failover Clustering
    2. SQL Server AlwaysOn Failover Cluster Instances
    3. Lab : Implementing an AlwaysOn Failover Cluster Instance
      1. Inspect the Windows Server Failover Cluster Configuration
      2. Install an AlwaysOn Failover Cluster Instance
      3. Configure tempdb to Use Local Storage
      4. Test Automatic Failover and Failback
  10. AlwaysOn Availability Groups
    1. Introduction to AlwaysOn Availability Groups
    2. Working with AlwaysOn Availability Groups
    3. Considerations for Using AlwaysOn Availability Groups
    4. Lab : Implementing and Testing an AlwaysOn Availability Group
      1. Implementing an AlwaysOn Availability Group
      2. Connecting to an AlwaysOn Availability Group
      3. Testing Failover
      4. Configure Quorum Voting
  11. Planning High Availability and Disaster Recovery
    1. High Availability and Disaster Recovery with SQL Server 2014
    2. High Availability and Disaster Recovery for Databases in Microsoft Azure
    3. Lab: Planning High Availability and Disaster Recovery
      1. Planning High Availability and Disaster Recovery Solutions with SQL Server 2014
      2. Planning High Availability and Disaster Recovery Solutions by Using Microsoft Azure
  12. Replicating Data
    1. SQL Server Replication
    2. Planning Replication
    3. Lab : Planning and Implementing Replication
      1. Planning Replication
      2. Implementing Replication

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.