Normalization Concepts

Beginner
  • 13 videos | 1h 23m 43s
  • Includes Assessment
  • Earns a Badge
Likes 138 Likes 138
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

  • 9m 3s
    In this video, you will identify the 13 rules published by Dr. Codd to help determine whether a database is relational. FREE ACCESS
  • 4m 15s
    After completing this video, you will be able to describe the features and components of a relational database management system. FREE ACCESS
  • Locked
    3.  Database Modeling
    4m 23s
    Upon completion of this video, you will be able to describe entity-relationship modelling for a relational database management system. FREE ACCESS
  • Locked
    4.  Levels of a DBS Architecture
    2m 57s
    Upon completion of this video, you will be able to describe the three levels of DBS architecture. FREE ACCESS
  • Locked
    5.  Understanding Tables
    8m 13s
    In this video, learn how to identify the characteristics of a table at the conceptual level of the database architecture. FREE ACCESS
  • Locked
    6.  Types of Constraints
    4m 34s
    After completing this video, you will be able to describe the types of constraints that can be used for data integrity. FREE ACCESS
  • Locked
    7.  Types of Keys in a Table
    9m 32s
    After completing this video, you will be able to describe the different types of keys that can be implemented on a column in a table. FREE ACCESS
  • Locked
    8.  Indexes, Triggers, and Stored Procedures
    8m 11s
    Upon completion of this video, you will be able to describe indexes, triggers, stored procedures, and how they help to access and manage data. FREE ACCESS
  • Locked
    9.  Normalization (Part 1)
    8m 44s
    Upon completion of this video, you will be able to describe the first and second normal forms in normalization for a database. FREE ACCESS
  • Locked
    10.  Normalization (Part 2)
    8m 28s
    Upon completion of this video, you will be able to describe 3NF and BCNF in terms of database normalization. FREE ACCESS
  • Locked
    11.  Normalization (Part 3)
    5m 51s
    After completing this video, you will be able to describe fourth and fifth normal form in normalization for a database. FREE ACCESS
  • Locked
    12.  Benefits of Normalization
    2m 27s
    During this video, you will learn how to identify the benefits of a well-normalized database for users. FREE ACCESS
  • Locked
    13.  Exercise: Architectures, Models, and Normalization
    7m 7s
    In this video, you will learn how to identify different database architectures, models, and how to normalize a database. 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

Channel Architecting Data
Likes 85 Likes 85  
Course Release, Service Level, and Availability Management
Course Data-driven Leadership

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Databases Using SQLAlchemy: Getting Started
Likes 30 Likes 30  
Course Relational Algebra & Calculus
Likes 41 Likes 41  
Course Conditional Statements & Loops: Advanced Operations Using for Loops in Python
Likes 424 Likes 424