Data Types & Normalization
SQL Server 2016
| Intermediate
- 10 Videos | 59m 52s
- Includes Assessment
- Earns a Badge
To optimize performance, you must understand how to properly design your SQL Server 2016 database. Examine database normalization and the various data types available in SQL Server 2016.
WHAT YOU WILL LEARN
-
describe the date and time data type category in SQL Server 2016
describe the character and unicode data type category in SQL Server 2016
describe the binary strings data type category in SQL Server 2016
describe the special data types category in SQL Server 2016
recognize the process of normalization in SQL Server 2016 -
describe the first normal form level of normalization
describe the second normal form level of normalization
describe the third normal form level of normalization
discuss when to denormalize a database
demonstrate how to create a SQL Table
IN THIS COURSE
-
1.Numerics5m 52sUP NEXT
-
2.Date and Time3m 24s
-
3.Character and Unicode6m 36s
-
4.Binary Strings3m 17s
-
5.Special Data Types5m 27s
-
6.Normalization4m 22s
-
7.First Normal Form7m 14s
-
8.Second Normal Form6m 51s
-
9.Third Normal Form5m 7s
-
10.Database Denormalization6m 42s
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.
