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 infrastructurerecognize the SQL Server 2014 options for database server infrastructure topology, including on-premises physical, private cloud, and public cloud optionsdescribe the basic considerations for choosing SQL Server 2014 hardwaredescribe the specific considerations for choosing SQL Server 2014 CPU and memory hardwaredescribe the specific considerations for choosing SQL Server 2014 storage and network hardwarerecognize the features, usage scenarios, and advantages of database normalizationrecognize the features, usage scenarios, and advantages of database denormalization
-
recognize the function of schemas, and best practice for implementationdescribe the considerations for planning tables and data typesdescribe the best practice for constraints on SQL databasesdescribe the function and features of MAP toolkit for SQL Server planningdescribe the database discovery and inventory features of MAP toolkitdescribe the MAP toolkit functionality for detailing computers running heterogeneous database instancesdescribe 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.