Planning Infrastructure
SQL Server 2014
| Expert
- 14 videos | 1h 42m 2s
- Includes Assessment
- Earns a Badge
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
-
1.Infrastructure Planning7m 28sUP NEXT
-
2.Database Server Topologies5m 46s
-
3.Hardware Planning Overview6m 39s
-
4.Planning CPU and Memory5m 4s
-
5.Planning Storage & Networks6m 19s
-
6.Normalization13m 53s
-
7.Denormalization8m 21s
-
8.Planning Schemas7m 1s
-
9.Tables and Data Types6m 19s
-
10.Planning Constraints9m 55s
-
11.MAP Toolkit Overview9m 21s
-
12.MAP Toolkit Discovery6m 55s
-
13.MAP Toolkit Platform3m 47s
-
14.MAP Toolkit Reports5m 16s
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.
