Microsoft SQL Server 2014 - Designing Solutions: Private Clouds


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Microsoft SQL Server 2014 - Designing Solutions: Private Clouds

  • 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
  • manage consolidated SQL server resources for single instances
  • manage consolidated SQL server resources for multiple instances
  • manage SQL Server consolidated virtualized resources
  • 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
  • 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
  • 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
  • Recognize options for SQL Server 2014 consolidation

    • Course Number:
    md_ddsa_a02_it_enus

    Expertise Level
    Intermediate