SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

August 11, 2018 by Joey Blue Leave a Comment

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

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.

Video: Database Normalization Tutorial


1NF, 2NF, 3NF, 4NF

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.

Filed Under: SQL Tip, SQL Training Tagged With: 1NF, 2NF, 3NF, 4NF, Database Normalization

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com