English French German Italian Portuguese Russian Spanish

logo_old

  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.


    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

MOC 20465 - Designing Database Solutions for Microsoft SQL Server 2014

 PDF PrintEmail

Course duration

  • 5 Days

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.

  • 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.
  • Use Microsoft Azure storage with SQL Server 2014.
  • Implement and configure databases in Microsoft Azure SQL Database.
  • Implement and configure databases in Microsoft Azure virtual machines.
  • Describe high availability technologies in SQL Server 2014 and implement log shipping.
  • Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster Instance.
  • Implement an Always On Availability Group.
  • Plan high availability and disaster recovery solutions.
  • Plan and implement database replication.
  • 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
  • Some basic knowledge of Microsoft Azure technologies and concepts around cloud computing
  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.