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 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 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
-
3. Database Modeling4m 23sUpon completion of this video, you will be able to describe entity-relationship modelling for a relational database management system. FREE ACCESS
-
4. Levels of a DBS Architecture2m 57sUpon completion of this video, you will be able to describe the three levels of DBS architecture. FREE ACCESS
-
5. Understanding Tables8m 13sIn this video, learn how to identify the characteristics of a table at the conceptual level of the database architecture. FREE ACCESS
-
6. Types of Constraints4m 34sAfter completing this video, you will be able to describe the types of constraints that can be used for data integrity. FREE ACCESS
-
7. Types of Keys in a Table9m 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
-
8. Indexes, Triggers, and Stored Procedures8m 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
-
9. Normalization (Part 1)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
-
10. Normalization (Part 2)8m 28sUpon completion of this video, you will be able to describe 3NF and BCNF in terms of database normalization. FREE ACCESS
-
11. Normalization (Part 3)5m 51sAfter completing this video, you will be able to describe fourth and fifth normal form in normalization for a database. FREE ACCESS
-
12. Benefits of Normalization2m 27sDuring this video, you will learn how to identify the benefits of a well-normalized database for users. FREE ACCESS
-
13. Exercise: Architectures, Models, and Normalization7m 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.
