Course Details

Previous Page


Microsoft SQL Server 2014 - Designing Solutions: Planning Infrastructure


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



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

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)
3.0

Lesson Objectives

Microsoft SQL Server 2014 - Designing Solutions: Planning Infrastructure

  • 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
  • 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
  • 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
  • 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
  • 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
  • identify how to plan the database infrastructure
  • Course Number:
    md_ddsa_a01_it_enus