4.4 out of 5
4.4
28 reviews on Udemy

Database Normalization Simplified

Database Normalization Explained in Simple English for MySql, Oracle, SQL Server, and PostgreSQL
Instructor:
Kris Wenzel
179 students enrolled
English [Auto-generated]
Know the reasons why a relational database is organized into many separate tables.
Gain confidence in understanding formal database normalization rules.
Be able to express and communication database design concepts with others.
Be prepared to answer interview questions.
Determine whether a database table is a good design.
Restructure spreadsheet like data into good database form.

This course is perfect if you’re running low on time, and need to cram for a test or certification.  Its singular purpose is to teach you database normalization.

In this Course you will Learn to:

  • Appreciate and design around data modification anomalies.

  • Identify a properly formed database table.

  • Answer common interview questions related to normalization

  • Spot a poorly designed table.

  • Communicate with others about table design.

  • Finally understand those confounding normalization rules!

Nothing is worse than

  • Being excited to learn something new but not knowing where to start.

  • Wasting time learning the wrong features.

  • Being overwhelmed with options and not know which to use.

Imagine Having…

  • Knowledge – Knowing how to quickly use subqueries to take your SQL to the next level.

  • Confidence – Feeling good that you’re on the right track.

  • Accomplishment – Having a sense of accomplishment that you’ve learned something most cannot.

  • Fun – Having fun learning databases!

By the time you’ve completed this course you’ll have an appreciation of database normalization, overcome your fear of normal form definitions, and make sense of the the most used database normal forms.   

Introduction

1
Welcome to the Course

Welcome to Database Normalization Simplified.  My goal is to help take the mystery out of database normalization and explain to you the definitions in simple to use English!

By the time you have completed the course, you will have a thorough understanding of the three normal forms, be able to use them to answer interview questions, take an exam or certification, or design a database.

2
What is Database Normalization?

Database normalization can be really abstract.  Before we get into some of the definitions, let's look at a practical view.

3
Reasons for Database Normalization

You may wonder what's all the fuss about database normalization.  Let me show you some good reasons you'll want to understand it.

4
The Three Main Normal Forms

The three normal forms are guide lines we can used to help use determine how to design tables.  The help use know whether columns should be include in a table or should be separated.  The forms build upon one another.  In order for a table to be in the second form, if must first meet the criteria for the first.


For those that are impatient check out the our Five Minute Guide to Database Normalization within the downloadable resources.

Database Tables and Modeling Ideas

1
What is a Database Table?

A database  table must meet some simple rule such as having rows and columns and a primary key.  Know about this definition is important, as this is the first requirement for a table to be in the first normal form.

2
Keep it Simple: Easy To Understand Data Modeling Concepts

I put this article together to help you understand some of the diagram I use when teaching database normalization.  I recommend reading it so you understand the notation I use throughout the course.

3
Database Tables and Modeling Ideas

Covers questions around database tables and fundamental modeling concepts

4
Table Relationship Assginment

Database Normalization

1
First Normal Form

Once a table is in the first normal form, the table is considered a relational database table, and it doesn't contain any repeating values.

2
First Normal Form Design Review

To better understand the first normal form, lets go over some examples.

3
Data Modification Anomalies and First Normal Form Assignment
4
Second Normal Form

When a table is in the second normal form the table serves a single purpose.

5
Second Normal Form Design Review

Let's transform our first normal form tables into the second normal form.

6
Second Normal Form Assignment
7
Third Normal Form

Tables in the third normal form have columns that aren't calculated, that is they don't rely on other column values from within the table.

8
Third Normal Form Design Review

In this lesson we'll transform our tables from 2nd to 3rd normal form.

9
Can Normalization Get Out of Hand?

Some rules are mean to be broken.  The database rules for normalization of generally mean to be followed, but not always!

10
Database Normalization Quiz

This quiz covers topic related to database tables, 1st, 2nd, and 3rd normal forms.

Wrap-up

1
Wrap-up

If at any time you have a question about this course, please let me know.

2
Bonus Lecture: Additional Resources and Course Coupons

Be sure to check out my other courses and grab a coupon so you can get the best deal on your next course.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
28 Ratings

Detailed Rating

Stars 5
9
Stars 4
15
Stars 3
2
Stars 2
2
Stars 1
0
d3470f7233ba1888c68c936cf7e1f52d
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion