Normalization Concepts

  • 13 Videos | 1h 29m 43s
  • Includes Assessment
  • Earns a Badge
Likes 27 Likes 27
Organizations use a Database Management System to manipulate, organize and retrieve data. Learn about these systems, their components, and Dr. Edgar Codd's rules for a database to be considered relational.

WHAT YOU WILL LEARN

  • identify the 13 rules published by Dr. Codd to help determine whether a database is relational
    describe the features and components of a RDBMS
    describe entity-relationship modelling for a RDBMS
    describe the three levels of a DBS architecture
    identify the characteristics of a table in the conceptual level of the database architecture
    describe the types of constraints that can be used for data integrity
    describe the different types of keys that can be implemented on a column in a table
  • describe indexes, triggers, and stored procedures and how they help to access and manage data
    describe the 1NF and 2NF in normalization for a database
    describe 3NF and BCNF in normalization for a database
    describe 4NF and 5NF in normalization for a database
    identify the benefits of a well normalized database for users
    identify the different database architectures, models, and perform normalization on a database

IN THIS COURSE

  • Playable
    1. 
    Dr. Codd's 13 Rules for a Relational Database
    9m 3s
    UP NEXT
  • Playable
    2. 
    Features of RDBMSs
    4m 15s
  • Locked
    3. 
    Database Modeling
    4m 23s
  • Locked
    4. 
    Levels of a DBS Architecture
    2m 57s
  • Locked
    5. 
    Understanding Tables
    8m 13s
  • Locked
    6. 
    Types of Constraints
    4m 34s
  • Locked
    7. 
    Types of Keys in a Table
    9m 32s
  • Locked
    8. 
    Indexes, Triggers, and Stored Procedures
    8m 11s
  • Locked
    9. 
    Normalization (Part 1)
    8m 44s
  • Locked
    10. 
    Normalization (Part 2)
    8m 28s
  • Locked
    11. 
    Normalization (Part 3)
    5m 51s
  • Locked
    12. 
    Benefits of Normalization
    2m 27s
  • Locked
    13. 
    Exercise: Architectures, Models, and Normalization
    7m 7s

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

CHANNEL NoSQL
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Views
Likes 60 Likes 60  
Likes 30 Likes 30  
Likes 70 Likes 70