Day 8. Database Normalization
Today, you will learn how to take a raw collection of data and break it up into more logical units, or tables, in order to reduce the occurrence of redundant data in the database. This process of reducing data redundancy is referred to as normalization. We will also discuss the advantages and disadvantages of a normalized database versus a normalized database that has been denormalized, as well as data integrity and performance issues that pertain to normalization.
By the end of this day, you should understand the following concepts and be able to apply them:
Normalization
Benefits of normalization
Denormalization
Guidelines of normalization
The three normal forms
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
