Hour 4. The Normalization Process
What You’ll Learn in This Hour:
• What normalization is
• Benefits of normalization
• Advantages of denormalization
• Normalization techniques
• Guidelines of normalization
• The three normal forms
• Database design
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 normalization process is used by database developers to design databases in which it is easy to organize and manage data while ensuring the accuracy of data throughout the database. The great thing is that the process is the same regardless of which relational database management system (RDBMS) you are using.
The advantages and disadvantages ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth 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.
