• Online, Self-Paced
Course 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.

Learning Objectives

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.