Видео

I didn't get the concept of it. I think it's the way that you've explained it because you gave an example of an engineer assessing a bridge and he performed all these evaluations and stuff on the same bridge so was expecting you to explain it similarly like using the same table/database throughout your explanation. For example, use 1NF but that table/database can be further normalized to 2NF and after that to 3NF using the same table. Not from The Beatles Table to Gaming tables, it kinder went off rails for me there, and became hard to grasp the concept. Let's hope you get what I'm saying my grammar is pretty bad.

thanks!! your explanation was really easy to understand

this is fucking good bro '

It's insane how much knowledge is condensed in this video. I legit sat down for 40 minutes with pen and paper and after going through the entire video, I feel so satisfied with everything.

Really good stuff. Subbed on the spot.

This is so concise and precise. Absolute goldmine!

i would say this is the masterpiece of 21st century in SQL!

Came for the basic example, stayed for the quadcopters and sentient teddy bears

CompoundComplexity

Thanks for the clearest explanation.

Thanks!! Finally someone made it clear!!

Awesome content!

what a fucking banger of a video, so good

Fantastic

Honestly buddy this is such a fantastic video! Explained so clearly! Well done!

Why you stopped doing videos. It is very useful for us. The way of explaining is awesome. Please continue the videos.

more please, thank you!

you did a wonderful job!!!

Exceptionally well made content from a naturally gifted instructor. You are helping people like me make it to the end of school in one piece and what you're doing is so valuable. Thank you.

imagine yapping for 8 hours about this just to be outplayed by a random guy on youtube in 28 minutes

Noice explanation! Really helpful :)

i think this is the best explanation of database normalization. especially for the beginners like me. i saw so many tutorials and read a chapter of this topic but couldn't be able to get this steps so easily. but this tutorial helped me to understand those steps so smoothly.

Apparently there are 6 normal forms. Which means the seventh normal form breaks reality itself and could show us how reality works by showing it’s a database, allowing us to bend it to our will Or maybe it’s late and my imagination is going wild

23:30 After the decomposition, the primary keys for tables are not just model it is {model, color} for first and {model, style} for second table

the last result table is wrong as there is not match for 3 ,4,5 in approver_emp_number so the result should contain only 3 rows where they match please tell i am wrong i am looking at for hour trying to know why

thank you for the video! it's very well explained

I am not sure how primary key showed in 23:30 is correct. How can Model be the only primary key?

Super

we need window function on sql

In the example even category data type column is considered a Primary key, we can do this way? it should be Unique, no null value and numeric? since rule says that they should be atleast one Primary key, what if I only have category data type columns, cnot numeric, what is the solution ?

Maybe it's my inexperience talking but what are the benefits for any of these approaches over having every table have an "id" column that is either an autoincrementing integer or a UUID (dealer's choice). These other primary key implementations seem like a large amount of mental overhead and complexity to achieve what I am interpreting as the same thing. Are there any drawbacks to this "simple" approach? The only ones I can think of are: 1. Indexing UUIDs takes more space than integers 2. Integers are easily guessable so UUIDs are better for authorization and security use cases. For me at least, it creates a significantly simpler mental model. Every table, without exception, has a primary key column named "id" and you are free to add constraints to the additional columns to achieve desired outcomes.

great vid tnx

Great explanation 😃

Nice, i was going crazy reading these textbooks that take way too long to get a point across its ridiculously bad. This video allowed me to finish my 2nd week assignment for database concepts class. And it all makes much more sense now.

On Most Popular MOvies of The Year table there is no way all the atributes are candidate keys, because they all repeat on the table, except for movie name.

This video is a whole better than the 9 hour lecture we had on this same topic

My brain blown up when reading these definitions, like "What?". Thanks for simplifying it in a way I can understand!

Amazing video

Thank you! This is the best and clearest explanation for this topic that I have encountered.

Heroes don't need to have some magic superpower, explaining to others this topic and other topics clearly is a great superpower to have. I don't know how to reward you enough for the explanations!

OMG I was about to post a comment on 23:27...and I just saw your corrections ;). Your content is amazing and you explain it so well!

I know my comment is a little irrelevant, but can you please tell me what are the fonts you are using? these are amazing.? Please share the name or the link if possible.

So much better than the explanation given in my Database Systems class. They explained everything with alpha's and beta's in set notation. Thank you for this!

dam my db already failing 1NF

I might be wrong but for the example Most_Popular_Movies_Of_The_Year, shouldnt only Movie Name be the candidate key? As candidate keys are a minimal set of keys that uniquely identify a tuple

I scoured so many database normalization videos in my undergraduate 4yr ago and none of them come near this one. My college self is finally happy

it is so great to finally understand what and why I was doing what I was doing, while following youtubers who don't explain anything.

hi, the video was very helpful. Btw, i'm not sure if i understood well the difference between superkeys and composite keys. Superkeys are a type of composite keys that can consist also of one attribute while the other must be 2+?

Database breathing 5th form

This video is so good, it's officially labeled as "bad-ass", and is 3NF compliant.