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