Planning Infrastructure

SQL Server 2014    |    Expert
  • 14 videos | 1h 42m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
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

  • 7m 28s
    Upon completion of this video, you will be able to describe the process for planning a SQL Server 2014 database server infrastructure. FREE ACCESS
  • 5m 46s
    Upon completion of this video, you will be able to recognize the SQL Server 2014 options for database server infrastructure topology, including on-premises physical, private cloud, and public cloud options. FREE ACCESS
  • Locked
    3.  Hardware Planning Overview
    6m 39s
    After completing this video, you will be able to describe the basic considerations for choosing SQL Server 2014 hardware. FREE ACCESS
  • Locked
    4.  Planning CPU and Memory
    5m 4s
    Upon completion of this video, you will be able to describe the specific considerations for choosing CPU and memory hardware for SQL Server 2014. FREE ACCESS
  • Locked
    5.  Planning Storage & Networks
    6m 19s
    After completing this video, you will be able to describe the specific considerations for choosing SQL Server 2014 storage and network hardware. FREE ACCESS
  • Locked
    6.  Normalization
    13m 53s
    Upon completion of this video, you will be able to recognize the features, usage scenarios, and advantages of database normalization. FREE ACCESS
  • Locked
    7.  Denormalization
    8m 21s
    Upon completion of this video, you will be able to recognize the features, usage scenarios, and advantages of database normalization. FREE ACCESS
  • Locked
    8.  Planning Schemas
    7m 1s
    Upon completion of this video, you will be able to recognize the function of schemas and best practices for implementation. FREE ACCESS
  • Locked
    9.  Tables and Data Types
    6m 19s
    After completing this video, you will be able to describe the considerations for planning tables and data types. FREE ACCESS
  • Locked
    10.  Planning Constraints
    9m 55s
    Upon completion of this video, you will be able to describe the best practices for constraints on SQL databases. FREE ACCESS
  • Locked
    11.  MAP Toolkit Overview
    9m 21s
    After completing this video, you will be able to describe the function and features of the MAP toolkit for SQL Server planning. FREE ACCESS
  • Locked
    12.  MAP Toolkit Discovery
    6m 55s
    Upon completion of this video, you will be able to describe the database discovery and inventory features of MAP toolkit. FREE ACCESS
  • Locked
    13.  MAP Toolkit Platform
    3m 47s
    After completing this video, you will be able to describe the MAP toolkit functionality for detailing computers running database instances of different types. FREE ACCESS
  • Locked
    14.  MAP Toolkit Reports
    5m 16s
    After completing this video, you will be able to describe the reporting functionality in the MAP toolkit. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course CompTIA IT Fundamentals: Database Concepts
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)
Journey Introduction to Computer Architecture
Rating 4.8 of 5 users Rating 4.8 of 5 users (5)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Python Best Practices Bootcamp: Session 1 Replay
Rating 4.4 of 47 users Rating 4.4 of 47 users (47)
Course Encryption
Rating 4.5 of 104 users Rating 4.5 of 104 users (104)
Course Optimization & Troubleshooting
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)