EssentialSQL: Database Normalization Simplified

Database Normalization Explained in Simple English for MySql, Oracle, SQL Server, and PostgreSQL | Database Design

4.60 (107 reviews)
Udemy
platform
English
language
Databases
category
instructor
EssentialSQL: Database Normalization Simplified
557
students
1 hour
content
Feb 2024
last update
$54.99
regular price

What you will learn

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 communicate 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.

Description

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 and good database design habits.


I’ll use simple to understand English so that you can understand the concepts and get to know the important points.


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 understand table relationships 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 most used database normal forms.


So check out the course and let's get going learning one of the most important relational database design concepts.

Content

Introduction

Welcome to the Course
What is Database Normalization?
Reasons for Database Normalization
The Three Main Normal Forms

Database Tables and Modeling Ideas

What is a Database Table?
Keep it Simple: Easy To Understand Data Modeling Concepts
Database Tables and Modeling Ideas

Database Normalization

First Normal Form
First Normal Form Design Review
Second Normal Form
Second Normal Form Design Review
Third Normal Form
Third Normal Form Design Review
Can Normalization Get Out of Hand?
Database Normalization Quiz

Wrap-up

Wrap-up
Bonus Lecture: Additional Resources and Course Coupons

Reviews

Riccardo
March 23, 2023
Good resource to have database normalization concepts in your hands. Nevertheless, the are some aspects about normal form which are not formally treated. Also, I would have appreciated a detailed explanation of Boyce-Codd Normal form, which is just mentioned.
Matthew
November 10, 2022
Teaching style is really practical. It takes a depth of topical understanding to reduce the topic to an accessible form. He’s got those skillz
Stephen
June 19, 2020
A very good course; well organized, good delivery, good screen graphics, and brief. My mind is not quite wrapped around 3NF just yet ... but I have the path to eventual success. Thanks!
Daniel
June 11, 2020
So far I am enjoying this course. The instructor presents the information in a straight forward and easy to understand manner. I would recommend this course.
Jacob
January 20, 2020
Everything you need to know about normalization in 1 hr. Perfect course for just anyone just getting started in database design.
Bryan
November 10, 2019
This is really one of the best classes I've taken on Udemy. It's just small enough to get what you need. Some courses throw everything including the kitchen sink into the course, but this one has just what you are seeking to learn - normalization. The content is clear, with example, lots of additional materials to help grasp the concepts, quizes to ensure you understand, and you can look at the feedback and quizes of others that have taken the course.
Wayne
September 23, 2019
Outstanding course, it really helped me to finally understand "normalization". Thank you, I really appreciate it.
John
August 16, 2019
"Database Normalization Simplified" was an excellent course. It is top of the class. The instructor clearly stated that Normalization is hard to understand. However, through learning and practice, it can be intuitive. At the conclusion the course, I felt confident that I could create and design simple databases up to Third Normal Form. Of course, I would need additional learning and practice using other aspects of data modeling and design. Now that I have dispelled my fears that I am capable of designing and creating relational databases, I am eager to continue my journey. Therefore, I am hoping that Mr. Wenzel will create more courses in other areas, such as Relationships with an emphasis on at least employing two junction tables. The concept of Many to Many is not explored adequately by many providers. Combining "Database Normalization Simplified" with a full course on relationships would be an ideal complement to the other database design and modeling courses on Udemy. This course would be helpful, not only for emerging database designers but also for Excel data modeling. In short, thank you, Mr. Wenzel, for helping me in moving forward with the confidence and insights that I can create tables where "all nonkey columns are dependent on the key, the whole key, and nothing but the key, so help me Codd!"
Orian
August 10, 2019
Pretty good beginner's overview on Database normalization. If you are familiar with database design, it's easy to rush through on 2x speed and still catch all the information. I had hoped for some tie-ins with a more formalized approach though, and maybe a few more difficult-to-recognize examples of problematic tables.
s
January 30, 2019
Good course, probably best viewed a few times. A link to some more practice scenarios would be a nice to have.
Jose
January 6, 2019
Great course overall, the explanation of third normal form leaves somewhat to be desired though, transitive is explained with an example and not a concise, simplified, definition, more examples would be useful for this last case also.
William
December 18, 2018
Breaks are too long between sentences, slides could be a little more professional. Other than that I'm learning what I need to, and I just increased the video speed to make it more engaging.
MUSAH
November 29, 2018
It has the fundamental basic ingredient to make you understand using very simple and live examples. It is engaging and commendable , excellent instructor,

Charts

Price

EssentialSQL: Database Normalization Simplified - Price chart

Rating

EssentialSQL: Database Normalization Simplified - Ratings chart

Enrollment distribution

EssentialSQL: Database Normalization Simplified - Distribution chart
1993090
udemy ID
10/28/2018
course created date
3/22/2020
course indexed date
Bot
course submited by