Microsoft SQL Server 2014 – Designing Solutions: Private Clouds

Database professionals who design and build database solutions, create plans and designs for database structure, storage, objects and servers, and plan the environment in which the database solutions run

Prerequisite
None

Expected Duration
119 minutes

Description
SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases. This course describes consolidation and management of consolidated resources, an overview of cloud computing, and how the cloud paradigm has shaped SQL server, configuring SQL in a private cloud configuration, and working with prepared instances of SQL Server. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform.

Objective

SQL Server Consolidation

  • start the course
  • recognize the reasons for consolidating SQL Server databases
  • recognize the options for consolidating a SQL Server environment
  • plan a strategy for SQL Server consolidation

Managing Consolidated Resources

  • manage consolidated SQL server resources for single instances
  • manage consolidated SQL server resources for multiple instances
  • manage SQL Server consolidated virtualized resources

Cloud Computing Overview

  • describe the features and characteristics of cloud computing
  • describe the main cloud computing delivery models
  • recognize methods and paradigms for cloud management
  • recognize the features of SQL Server in the Azure Public Cloud

SQL Server in a Private Cloud

  • recognize Private Clouds and how they differ from traditional data centers
  • recognize the process for enabling resource pooling in a SQL Server private cloud environment
  • recognize the process for enabling elasticity and self-service in a SQL Server private cloud environment
  • recognize the process for enabling metering and enforcing policies in a SQL Server private cloud environment

SQL Server Prepared Instances

  • create a SQL Server 2014 prepared instance
  • complete a SQL Server 2014 prepared instance
  • add features to a SQL Server 2014 prepared instance
  • remove features from a SQL Server 2014 prepared instance

Practice: SQL Server 2014 consolidation options

  • Recognize options for SQL Server 2014 consolidation

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.