Data Types & Normalization

SQL Server 2016    |    Intermediate
  • 10 videos | 54m 52s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
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

  • 5m 52s
    After completing this video, you will be able to describe the date and time data type category in SQL Server 2016. FREE ACCESS
  • 3m 24s
    Upon completion of this video, you will be able to describe the character and unicode data types in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Character and Unicode
    6m 36s
    After completing this video, you will be able to describe the binary strings data type category in SQL Server 2016. FREE ACCESS
  • Locked
    4.  Binary Strings
    3m 17s
  • Locked
    5.  Special Data Types
    5m 27s
    Upon completion of this video, you will be able to recognize the process of normalization in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Normalization
    4m 22s
    After completing this video, you will be able to describe the first level of normalization. FREE ACCESS
  • Locked
    7.  First Normal Form
    7m 14s
    Upon completion of this video, you will be able to describe the second level of normalization. FREE ACCESS
  • Locked
    8.  Second Normal Form
    6m 51s
    After completing this video, you will be able to describe the third level of normalization. FREE ACCESS
  • Locked
    9.  Third Normal Form
    5m 7s
    In this video, find out how to discuss when to normalize a database. FREE ACCESS
  • Locked
    10.  Database Denormalization
    6m 42s
    In this video, you will learn how to create a SQL table. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Book Database Performance at Scale: A Practical Guide
Course Architecture
Rating 4.2 of 30 users Rating 4.2 of 30 users (30)
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course Normalization Concepts & Forms
Rating 4.7 of 164 users Rating 4.7 of 164 users (164)
Course Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)