Normalization & Indexes

SQL Server 2014
  • 7 Videos | 47m 23s
  • Includes Assessment
  • Earns a Badge
Likes 22 Likes 22
Data redundancy negatively affects storage, scalability, and responsiveness. Learn how to use database normalization and indexes in SQL Server to counter these negative effects.

WHAT YOU WILL LEARN

  • describe the purpose of normalizing  relational databases
    describe the normalization guidelines for relational databases and define the first normal form (1NF)
    describe the normalization guidelines for relational databases and define the second normal form (2NF)
    describe the normalization guidelines for relational databases and define the third normal form (3NF)
  • describe clustered and nonclustered indexes in the context of their use in a SQL Server database
    create clustered and nonclustered indexes in SQL Server databases
    use the appropriate commands to create and normalize tables in a SQL Server database

IN THIS COURSE

  • Playable
    1. 
    Overview of Normalization
    5m 32s
    UP NEXT
  • Playable
    2. 
    Normalization Guidelines - 1NF
    7m 39s
  • Locked
    3. 
    Normalization Guidelines - 2NF
    5m 34s
    FREE ACCESS
  • Locked
    4. 
    Normalization Guidelines - 3NF
    4m 31s
    FREE ACCESS
  • Locked
    5. 
    Indexes
    8m 18s
    FREE ACCESS
  • Locked
    6. 
    Creating Indexes
    7m 40s
    FREE ACCESS
  • Locked
    7. 
    Exercise: Creating and Normalizing Tables
    5m 10s
    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 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 Azure Data Fundamentals: Non-relational Data Services
Likes 0 Likes 0  
COURSE Azure Data Fundamentals: Relational Data Workloads
Likes 0 Likes 0  
COURSE Stored Routines, Triggers, & the InnoDB memcached Plugin
Likes 11 Likes 11  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Normalization Concepts & Forms
Likes 87 Likes 87  
COURSE Concepts & Conceptual Design
Likes 141 Likes 141  
COURSE Database Security
Likes 22 Likes 22