Relational Database and Normalization
BEGINNER
#SQL
Author: Zakhar Pidporinov
Course description
This course covers the theory of relational databases. It explains what relational databases are and contrasts them with non-relational databases. The course will guide you through the process of designing databases and introduce you to different types of relationships. You will also learn about normalization and normal forms, and how they can be used to create efficient and optimized databases.
Complete all chapters to get certificate
0%
Database Models
In this section, you will become familiar with both relational and non-relational databases and learn how to create diagrams to represent database structures.
Introduction
Difference between Relational and Non-relational Databases
Entity-Relationship Model
Entity-Relationship Model. Relationships
Relational Database
This section delves deeper into the topic of relational databases and provides a comprehensive overview of the key theoretical concepts. Topics covered include foreign keys, the different ON DELETE options, and the various types of relationships.
Structure. Primary Key and Foreign Key
Foreign Key Constraints. ON DELETE Options
Many-to-One and One-to-Many
One-to-One and Many-to-Many
Normalization and Normal Forms
It's time to learn how to construct databases, with a focus on ensuring a well-structured database for optimal functionality. In this section, you will familiarize yourself with the key principles for building a database for ease of use.
Normalization
Unnormalized Form. First Normal Form
Second Normal Form
Third Normal Form
Boyce–Codd Normal Form
Denormalization. Summary