Data Types & Normalization

SQL Server 2016
  • 10 Videos | 59m 52s
  • Includes Assessment
  • Earns a Badge
Likes 31 Likes 31
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 Designing & Implementing Views
Likes 23 Likes 23  
COURSE Stored Procedures
Likes 38 Likes 38  
COURSE Columnstore Indexes
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Designing & Implementing Views
Likes 23 Likes 23  
COURSE T-SQL Queries
Likes 112 Likes 112  
COURSE Azure SQL Database
Likes 59 Likes 59