Trusted Training Partners

    Home / Uncategorized / Designing a Data Solution with MS SQL Server 2014 Training Course Course
Quick Look Course Summary:Designing a Data Solution with MS SQL Server 2014 Training Course Course
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 16,700.00 EX VAT 3 Person R 11,644.28 EX VAT 10 Person R 7,836.00 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Designing a Data Solution with MS SQL Server 2014
    Training Course Course: Introduction

    As organizations grow to enterprise scale, their IT infrastructure requirements become more complex and the network environment often includes an increasing number of servers, client computers, network segments, and other components. Because data is fundamental to most IT operations, careful thought must be given to the provisioning and management of databases across the enterprise.

    Designing a Data Solution with MS SQL Server 2014
    Training Course Course :Course Outline

    1. Introduction to Enterprise Data Architecture
    Considerations for Enterprise Data
    Assessing an Existing Infrastructure
    Using the MAP Toolkit
    Reviewing MAP Toolkit Reports

    2. Multi-Server Configuration Management
    Policy-Based Management
    Microsoft System Centre
    Planning and Implementing Policy-Based Management
    Testing Policy Compliance

    3. Consolidating Database Workloads with SQL Server 2014
    Considerations for Database Server Consolidation
    Managing Resources in a Consolidated Database Infrastructure
    SQL Server Consolidation
    Preparing for Database Consolidation
    Managing Resources for an SQL Server
    Managing Resources for Multiple Instances on a Windows Server

    4. Introduction to Cloud Data Solutions
    Overview of Cloud Computing
    SQL Server in a Private Cloud
    Preparing a SQL Server Installation in a Virtual Machine Template
    Creating a prepared Instance
    Completing a prepared Instance

    5. Introduction to Windows Azure
    Windows Azure Overview
    Windows Azure Storage
    Using Windows Azure
    Creating a Windows Azure Storage Account
    Backing Up a Database to Windows Azure

    6. Windows Azure SQL Database
    Introduction to Windows Azure SQL Database
    Windows Azure SQL Database Security
    Implementing and Managing Databases
    Using Windows Azure SQL Database
    Provisioning Windows Azure SQL Database
    Configuring Windows Azure SQL Database Security
    Migrating a Database to Windows Azure SQL Database

    7. SQL Server in Windows Azure Virtual Machines
    Introduction to Windows Azure Virtual Machines
    Windows Azure Virtual Machine Connectivity and Security
    Creating Databases in a Windows Azure Virtual Machine
    Using Windows Azure Virtual Machines
    Creating a Windows Azure Virtual Machine
    Configuring Windows Azure Virtual Machines Security and Connectivity
    Creating Databases on a Virtual Machine

    8. Introduction to High Availability in SQL Server 2014
    High Availability Concepts and Options in SQL Server 2014
    Log Shipping
    Using Log Shipping
    Configure Log Shipping
    Test the Log Shipping Configuration
    Test Failover

    9. Clustering with Windows Server and SQL Server 2014
    Introduction to Windows Server Failover Clustering
    SQL Server Always On Failover Cluster Instances
    Implementing an Always On Failover Cluster Instance
    Inspect the Windows Server Failover Cluster Configuration
    Install an Always On Failover Cluster Instance
    Configure tempdb to Use Local Storage
    Test Automatic Failover and Failback

    10. Always On Availability Groups
    Introduction to Always On Availability Groups
    Working with Always On Availability Groups
    Considerations for Using Always On Availability Groups
    Implementing and Testing an Always On Availability Group
    Implementing an Always On Availability Group
    Connecting to an Always On Availability Group
    Testing Failover
    Configure Quorum Voting

    11. Planning High Availability and Disaster Recovery
    High Availability and Disaster Recovery with SQL Server 2014
    High Availability and Disaster Recovery for Databases in Windows Azure
    Planning High Availability and Disaster Recovery
    Planning High Availability and Disaster Recovery Solutions with SQL Server 2014
    Planning High Availability and Disaster Recovery Solutions by Using Windows Azure

    Designing a Data Solution with MS SQL Server 2014
    Training Course Course: Course Duration

    3 day/s

    Who should attend: Designing a Data Solution with MS SQL Server 2014
    Training Course Course

    This course is intended for programmers, SQL Server.

    **Quote does not include Any Exam Fees (if applicable)

    IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

    Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated