• Online, Self-Paced
Course Description

Planning SQL Server infrastructure includes planning from the hardware up all the way to individual table configurations. This course addresses the activities involved in planning database physical and logical structures using the Microsoft Planning and Assessment Toolkit, implementing policy-based management, and managing SQL Server with System Center. 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

Database Infrastructure Planning

  • start the course
  • describe the process for planning a SQL Server 2014 database server infrastructure
  • recognize the SQL Server 2014 options for database server infrastructure topology, including on-premises physical, private cloud, and public cloud options
  • describe the basic considerations for choosing SQL Server 2014 hardware
  • describe the specific considerations for choosing SQL Server 2014 CPU and memory hardware
  • describe the specific considerations for choosing SQL Server 2014 storage and network hardware

Logical Database Schema Design

  • recognize the features, usage scenarios, and advantages of database normalization
  • recognize the features, usage scenarios, and advantages of database denormalization
  • recognize the function of schemas, and best practice for implementation
  • describe the considerations for planning tables and data types
  • describe the best practice for constraints on SQL databases

Microsoft Assessment and Planning Toolkit

  • describe the function and features of MAP toolkit for SQL Server planning
  • describe the database discovery and inventory features of MAP toolkit
  • describe the MAP toolkit functionality for detailing computers running heterogeneous database instances
  • describe the reporting functionality in MAP toolkit

SQL Server Policy-Based Management

  • describe the key concepts associated with policy-based management
  • plan policy-based management in SQL Server 2014
  • implement policy-based management in SQL Server 2014
  • test a policy-based management implementation for compliance

Managing SQL with System Center

  • describe how System Center Advisor can be used for cloud-based management of SQL Server infrastructure
  • describe how System Operations Manager can be used for management of SQL Server infrastructure
  • describe the use and limitations of the SQL Server management pack for System Center Operations Manager

Practice: Planning for SQL Server 2014

  • identify how to plan the database infrastructure

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.