Planning Infrastructure

SQL Server 2014    |    Expert
  • 14 Videos | 1h 42m 2s
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
A SQL Server infrastructure must be planned from the hardware up. Discover how to plan both the physical and logical database structures using the Microsoft Planning and Assessment Toolkit.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Wintellect SQL Server
Likes 1 Likes 1  
CHANNEL Azure Infrastructure
Likes 189 Likes 189  
COURSE Data Engineering on Microsoft Azure: Designing Data Storage Structures

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Concepts & Queries
Likes 498 Likes 498  
COURSE Windows Server 2016 - Install, Store, & Compute: Installation Options
Likes 144 Likes 144  
COURSE SQL Developer
Likes 285 Likes 285