Normalization Concepts
Beginner
- 13 videos | 1h 23m 43s
- Includes Assessment
- Earns a Badge
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 relationaldescribe the features and components of a RDBMSdescribe entity-relationship modelling for a RDBMSdescribe the three levels of a DBS architectureidentify the characteristics of a table in the conceptual level of the database architecturedescribe the types of constraints that can be used for data integritydescribe 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 datadescribe the 1NF and 2NF in normalization for a databasedescribe 3NF and BCNF in normalization for a databasedescribe 4NF and 5NF in normalization for a databaseidentify the benefits of a well normalized database for usersidentify the different database architectures, models, and perform normalization on a database
IN THIS COURSE
-
9m 3sIn this video, you will identify the 13 rules published by Dr. Codd to help determine whether a database is relational. FREE ACCESS
-
4m 15sAfter completing this video, you will be able to describe the features and components of a relational database management system. FREE ACCESS
-
4m 23sUpon completion of this video, you will be able to describe entity-relationship modelling for a relational database management system. FREE ACCESS
-
2m 57sUpon completion of this video, you will be able to describe the three levels of DBS architecture. FREE ACCESS
-
8m 13sIn this video, learn how to identify the characteristics of a table at the conceptual level of the database architecture. FREE ACCESS
-
4m 34sAfter completing this video, you will be able to describe the types of constraints that can be used for data integrity. FREE ACCESS
-
9m 32sAfter 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
-
8m 11sUpon 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
-
8m 44sUpon completion of this video, you will be able to describe the first and second normal forms in normalization for a database. FREE ACCESS
-
8m 28sUpon completion of this video, you will be able to describe 3NF and BCNF in terms of database normalization. FREE ACCESS
-
5m 51sAfter completing this video, you will be able to describe fourth and fifth normal form in normalization for a database. FREE ACCESS
-
2m 27sDuring this video, you will learn how to identify the benefits of a well-normalized database for users. FREE ACCESS
-
7m 7sIn 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

Course
Data-driven Leadership