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

  • 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

Course Database Fundamentals: Working with SQL Commands
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Course Database Fundamentals: Database Administration Basics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Normalization Concepts & Forms
Likes 186 Likes 186  
Course Database Instance Performance
Likes 81 Likes 81  
Course Nonclustered, In-Memory, & XML Indexes
Likes 19 Likes 19