Menu
Home Blog Courses About

Connect

Back to Blog

Database Normalization

SQL Database Normalization - 1NF, 2NF, 3NF, and 4NF

Understand database normalization principles for efficient schema design. Learn 1NF, 2NF, 3NF rules with practical examples and downloadable resources.

1 min read

Last updated on

Learn how to normalize your relational tables.

  • 1st Normal Form and Atomic Values

  • 2nd Normal Form (2NF) and Partial Dependence

  • 3rd Normal Form (3NF) and Transitive Dependence

  • 4th Normal Form (4NF) and Multi-Valued Facts

The first half of the video discusses the normal forms with smaller examples. The second half of the video goes into a little more complex example.

The following Microsoft Excel file is used throughout the training to demonstrate the normal forms:

Normalization Excel File

See the original Normalization in SQL. 1NF, 2NF, 3NF, and 4NF video.

About Joey Blue

Joey Blue teaches practical data skills that companies actually use. With 25+ years of experience solving real data problems for Fortune 500 companies, he's helped 152,000+ students learn SQL, Power BI, reporting, and modern analytics—cutting straight to what works.

View Courses YouTube Channel Learn More