Planning Infrastructure

SQL Server 2014
  • 14 Videos | 1h 48m 2s
  • Includes Assessment
  • Earns a Badge
Likes 11 Likes 11
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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 318 Likes 318  
COURSE Encryption
Likes 69 Likes 69  
COURSE SQL Developer
Likes 152 Likes 152