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

BOOK High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
BOOK Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications
COURSE Architecture
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE T-SQL Queries
Likes 173 Likes 173  
COURSE Index Design Guidelines
Likes 33 Likes 33  
COURSE Developing Your Business Ethics
Likes 722 Likes 722