Hour 4. The Normalization Process
In this hour, you learn the process of taking a raw database and breaking it into logical units called tables. This process is referred to as normalization.
The advantages and disadvantages of both normalization and denormalization of a database are discussed, as well as data integrity versus performance issues that pertain to normalization.
The highlights of this hour include
What normalization is
Benefits of normalization
Advantages of denormalization
Normalization techniques
Guidelines of normalization
The three normal forms
Database design
Get Sams Teach Yourself SQL in 24 Hours, Second 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.
