Relational databases are used all the time in software development.
We’ve just published a course on the freecodecamp.org YouTube channel that will help you learn ground-based database design. This course covers SQL fundamentals, entity-relational modeling, normalization (BCNF through 1NF), data types and constraints, indexing strategies, and query optimization.
This course is based on the book Growing Relational Database Design by Dr. Qiang Hao and Dr. Michael Tsikirdakis.
Here are the parts of this course.
Relational Databases for Beginners – Tables, Entities, Keys and SQL
SQL filtering and aggregation
SQL Table Commands
Foreign keys in SQL
How SQL comes into play
How to learn SQL by yourself
Database design goals
Database design life cycle
Tables from real-world ideas
Primary Key, Candidate Key, and Super Key
Do not use an invalid SQL string type
The float error that crashed the stock exchange
SQL date and time types defined
Integrating entities in an ER diagram
One-to-one relationships
Multiple relationships
Lots of relationships
Strong versus weak institutions
First General Form – Primary Keys and Atomic Values
Another common form – partial keys and active dependencies
The third general form – transitive dependence
The untold story of BCNF
Primary key vs unique constraints
Foreign key constraints – on delete and update
Other constraints: NOT NULL, default, and check
Access control, hashing and encryption
B-tree vs full-text index
denormalization
View the full course freecodecamp.org YouTube channel (6 hour clock)