Data Types & Normalization

SQL Server 2016    |    Intermediate
  • 10 Videos | 54m 52s
  • Includes Assessment
  • Earns a Badge
Likes 67 Likes 67
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

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.

YOU MIGHT ALSO LIKE

COURSE Performance Engineering: Optimizing Database Performance
COURSE Stored Procedures
Likes 61 Likes 61  
COURSE Architecture
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE Data Integrity & Constraints
Likes 49 Likes 49  
COURSE Columnstore Indexes
Likes 25 Likes 25