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: 1 Person R 15,365.00 EX VAT 3 Person R 8,680.00 EX VAT 10 Person R 5,734.61 EX VAT

  • Certification Type:Accredited

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

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

Get Free & personalised
Training Advice

Enjoy incredible savings the more delegates
you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

Select Date *

Premises Provided by *

Laptop Provided by *

Region *

Administrative Courses

Human Resources Courses

Leadership & Management Courses

RPL & Learnerships Courses

Soft Skills Courses

Software & IT Courses

Specialist Courses

Top Rated