This is a well done video!! Clear, articulate, good examples, and use of humor. I know nothing about databases and this was easier to understand than the book!
This video offers one of the best explanations that I have seen on Database normalisation. A very good easy to follow tutorial and I would recommend this to anyone starting out with relational databases.
Great video and very clearly explained. The only constructive criticism I would make is that you failed to explain the second key reason for normalizing, to prevent empty (null) field values. This would require a different example but would explain that sometimes you need to normalize to prevent certain records containing lots of null field values because a group of related fields does not apply to those records. The problem is different but the solution is the same, to extract the related fields to a separate table. Then, you only populate the second table for records in the first table that have values for the extracted fields. Large numbers of nulls can create issues when carrying out comparisons.
Normalization is a technique of organizing the data into multiple related tables! God it lit my brain, Perfect statement Thank you ! You are very useful for humans stay alive!
I remember seeing this playlist during my college and it's still the best playlist to learn Normalization!! I searched for this particular playlist after years! You did an amazing job in making it simple and straight forward!! Thanks a ton :)) 💎
Thank you Meraz for your kind comment. Share this video with your classmates and do subscribe to the channel. Also share some topics that you would want me to cover ☺️
sir...uh r just like farishta to me..my teacher have explained this topic to me several of time..and still not even a word get stuck in my mind...bt ur easy wording and the way you have delivered this topic..now it seems to be easy...uh are going to help me in my exams ..hehe..thnku sir..May god bless you
This is great. There needs to be more ppl like you in the world, more videos like yours in the world. I'm so glad to see you've gotten much recognition for it as I've seen many great videos such as this with only a couple thousand views. Idk why I'm still writing this even though I know no one will see this. I want to learn to type faster hmmmm and also get emojis on desktop or like memorize their code for them 🤔😂
This is an excellent video that clearly explains how normalization works. I watched my university's lecture on normalization 5 times and still could not figure out what normalization is.....
What happens when you change the name of the branch? Than you still have to update the name CSE in every row of the students table. Always use an id in this case (or use foreign keys to connect the two together). Never couple two tables with a column that can change, at least that's what I learned in school a long time ago. Your explanation of the problems when you don't normalize is very good. Keep up the good work!
I'm a teacher and this is an excellent tutorial. Clear and succinct. There are minor things like 'updation' (should be 'updating') which I gladly overlook. If I show this video to my students, it makes life so much easier! Why reinvent the wheel?
Thanks for your kind words. And yes, why reinvent the wheel, you should show this video to your students and do tell them there are lot more tutorials on our website too studytonight.com (*promotion*) :)
Thank you Rahul for your kind comments. {From Abhishek: Your name is so familiar. I have a feeling that you are from somewhere around my town in Haryana :p }
Fantastic video. Clearly explained and very, VERY made !! Thanks for your work for it! I do your playlist and looking forward for video #2!. Thanks a ton, already!
When I watch Studytonight I really feel like I can study all night! (Edit): Now I have a f*cked up sleep schedule and can't get to sleep until 2 in the afternoon. I stay up all night and have now acquired a caffeine addiction. The addiction was so bad that I tried to fix it with drugs. My parents are now sending me to rehab.
Hi DP. This is Tom's mother. Thank you for your kind words. Unfortunately Tom passed away 3 weeks ago due to a Caffine overdose. Your words would have meant a lot to him.
never have i ever watched something explained so simply magnificent. i think the animation method oof showing us is the cherry on top. thank you very much ❤😄
I like to remember the different kinds of anomalies based on DUI. You wouldn't want to Drive Under the Influence and you wouldn't want Deletion, Update, or Insertion anomalies in your DB.
question about 4:30 Since you normalize by separating the student table and branch table. If the branch column is CSE on student table, is that mean the expected data of that student on branch table is the data indicated by CSE on the branch table too?
Good video. Unfortunately english the only language I can understand and therefore normally struggle with heavy accents, but yours is clear and the examples are simple so thankyou. 😊
Crazy how a UA-cam channel is better at explaining a topic than a full fledged professor. Thank you
And it's only 8min long...
3:39 making the students happy Kkkkk
Absolutely !
pretty much
I was just thinking the same thing
"Normalisation is not about eliminating data redundancy, it is about minimizing data redundancy" This made this a whole lot of easier. Thnx
this is explained so much better than the way my lecturer did. I thought it was impossible to understand but this is so simple thank you so much
I wish I could throw this video right into my teacher's face... Thanks a lot..
Lol yeah
yeah xd
my teacher gave me this video link to learn database! lol xD
I know.I have the same reaction.but still respect my teacher.
Hahahahaha I feel you
Your teaching style, your graphics, your colors... everything is clean and perfect for leaning.
You are a great teacher!
why are you so good at explaining? why cant teachers be more like you?
Haha *blushing*. I don't know, maybe being a student myself, helped me in understanding what our teachers were doing wrong.
weren't they students once?@@Studytonight
Watched at 1.5 X playback speed.
But good job brother, thank you for taking the effort to help those like us surviving college on memes and weed.
"memes and weed" no truer words have been spoken 😂
ahahahahhahahhaha
lol
Playback speed is why UA-cam > Vimeo
This video is sooooo good. I understood the anomalies in a matter of minutes. Huge thanks!
This is a well done video!! Clear, articulate, good examples, and use of humor. I know nothing about databases and this was easier to understand than the book!
I am a first year CSE student, i watched multiple videos on UA-cam but this one was so clear, that i wanted to react. BE PROUD OF YOURSELF!
never saw something so smooth and effortless explanation of a complex topic
Probably the best quality and most efficient in terms of understanding video on DB normalization I have seen
Thanks Man! Thanks for the kind words.
Thank u sir. You have made it a lot more simpler to understand.
the best and most understandable explanation i have found in the youtube . Thank you sir 👏
Clear, concise, and well-animated too! Thank you so much!!
This normalization playlist is gold. Easy and understand and implement. Thank you. Keep making videos.
This video offers one of the best explanations that I have seen on Database normalisation. A very good easy to follow tutorial and I would recommend this to anyone starting out with relational databases.
Thank you DLiberator78 for the appreciation :)
i study for 2 years,first time i understand what it means and how it works,big salute for you thank youuuuu
Great video and very clearly explained. The only constructive criticism I would make is that you failed to explain the second key reason for normalizing, to prevent empty (null) field values. This would require a different example but would explain that sometimes you need to normalize to prevent certain records containing lots of null field values because a group of related fields does not apply to those records.
The problem is different but the solution is the same, to extract the related fields to a separate table. Then, you only populate the second table for records in the first table that have values for the extracted fields.
Large numbers of nulls can create issues when carrying out comparisons.
Normalization is a technique of organizing the data into multiple related tables! God it lit my brain, Perfect statement Thank you ! You are very useful for humans stay alive!
presentation, typography, minimalism and real content, really good.
Thank you thank you 😬
Woah, didn't expect to find this gem of a channel. Keep up the good work!
Thank you so much 😬 glad you liked the video 🙌🏼
I remember seeing this playlist during my college and it's still the best playlist to learn Normalization!! I searched for this particular playlist after years! You did an amazing job in making it simple and straight forward!! Thanks a ton :)) 💎
U have explained better than my department teachers. Thanks a lot 😊
Thank you Meraz for your kind comment. Share this video with your classmates and do subscribe to the channel. Also share some topics that you would want me to cover ☺️
sir...uh r just like farishta to me..my teacher have explained this topic to me several of time..and still not even a word get stuck in my mind...bt ur easy wording and the way you have delivered this topic..now it seems to be easy...uh are going to help me in my exams ..hehe..thnku sir..May god bless you
@4:37 “data redundancy is pure evil” has me laughing so hard 😂
Great video! Very detailed and to the point :)
Thanks Anna for the comment 😁 share it with your friends and help them learn Normalization 😋
Just to be honesty, Sir you're every database student's savior!!!
Thanks for your kind words, brother
Welcome to study tonight .
Me : yes iam studying the night before my exam
Im studying an hour before my final
That's weak boys.
I'm studying hours before my interview
Better at explaining a topic than a university lecturer. All the best Sir!
Toughest topic explained in the simplest way possible!😀 Very creative, keep up the great work!
Thank you Aditya!
RESPECT to you, sir! This is video is categorically the best introduction to data normalization.
Amazing explination! Did what my professor couldn't in 8 minutes
No doubt Indian teachers are leading to UA-cam by their educational channels....best teachers on UA-cam...great efforts 🇵🇰
This is great. There needs to be more ppl like you in the world, more videos like yours in the world. I'm so glad to see you've gotten much recognition for it as I've seen many great videos such as this with only a couple thousand views. Idk why I'm still writing this even though I know no one will see this. I want to learn to type faster hmmmm and also get emojis on desktop or like memorize their code for them 🤔😂
The way you have explained us in the full structured form is insane 👏🏻
Thank you Anna chala easy ga nerpinchav 😊
Thank you for your comment
Million thanks. Also love the quality of the content, the animation and graphics made it more fun to understand. Keep it up.
He literally explained something I didn't understand after an hour long lecture in 8 minutes
Much more helpful than my textbook! Thank you
Beautiful & simple explanation of data redundancy, anomaly & how normalization can solve those problems. Thank you!
Your slides , precise but brief explanation with high level of clarity and direct on point without any confusion is jst amazing .
Thank you for your lovely comment :)
Thank you very much! I was studying for my bioinformatics exam and found this tutorial very clear for beginners. :)
Your explanations are Very Clear! That's often not the case, and much appreciated. Also very well-organized.
Glad it was helpful!
This is an excellent video that clearly explains how normalization works. I watched my university's lecture on normalization 5 times and still could not figure out what normalization is.....
u saved a lot time for me , all the vedioes jus saw definations but dont tell their inner meaning .with simple statements u clarfied it
The topic cannot be taught in a more easier and clearer way then this hatts of bro 🙌🏻
What happens when you change the name of the branch? Than you still have to update the name CSE in every row of the students table. Always use an id in this case (or use foreign keys to connect the two together). Never couple two tables with a column that can change, at least that's what I learned in school a long time ago.
Your explanation of the problems when you don't normalize is very good. Keep up the good work!
CSE here is a primary key to table Student. Primary keys are not updated in tables.
you people are amazing i love the way you are delivering the content .Hope you people will continue. Studytonight rocks. Thanks
One of the best explanations I have ever seen.. Great work... Hoping to see the newer videos soon
Thanks a ton. Keep watching other videos.
this is what i was looking for all along THIS IS A GOOD PRESENTATION
your explanation is so much better than my teacher who just read the lesson than explaining it to us, i understand it a lot on you thanks sir!!1
I'm a teacher and this is an excellent tutorial. Clear and succinct. There are minor things like 'updation' (should be 'updating') which I gladly overlook. If I show this video to my students, it makes life so much easier! Why reinvent the wheel?
Thanks for your kind words. And yes, why reinvent the wheel, you should show this video to your students and do tell them there are lot more tutorials on our website too studytonight.com (*promotion*) :)
Updation is used correctly here
Nice explanation.I'm a slow learner and I can understand this video. Thank you for making my learning easier
This is amazing! Thank you very much and I look forward to the rest of the series on Database Normalization. Because Data Redundancy is pure evil!
Data redundancy is pure evil xD...
Well in a relational database world may be, Data redundancy becomes crucial in Infrastructure related system design.
@@CrashTheGooner, that's redundancy for the sake of preservation, though 😋
just watching videos about db normalization hh
it is :)
But unfortunately we cannot eliminate the (pure) evil, just minimize it
the best video series seen so far. Thanks a lot
million dollar thanks to abhisek sir , this was really great explanation
Great video. Great information. I really liked it. I watched the whole video without any fast forwarding. Keep posting. Keep educating.
Thank you Rahul for your kind comments.
{From Abhishek: Your name is so familiar. I have a feeling that you are from somewhere around my town in Haryana :p }
I was having problem why we need normalization and your video made it easy to understand.
initially, i found it a bit confusing..but as i resumed...it felt awesome...loved the clarity of thoughts..
Glad you liked it!
Nice work on the graphics. Needed this to help review the following topics for tomorrows prelims.
Glad it helped you. I created the graphics using Canva :)
Fantastic video. Clearly explained and very, VERY made !! Thanks for your work for it! I do your playlist and looking forward for video #2!. Thanks a ton, already!
This is a very good video on what Normalization of Data, Data Redundancy, and Anomalies. Thank you.
This is just superb ! So well explained. You are one great tutor !! Subscribed right away, just after watching the first 2 minutes 🙂
ok i dont say this to anybody but sir i think im in love with u your teaching methos is chef kiss
thank you so much, my lecture explanation weren't simple as you did...
once again, thank you so much! :)
Sir just amazing explanation just amazing 🤩 never seen like this simple explain video . thanks a lot
Thanks for your comment ☺
The best video I've watched so far!!
Very crisp and short explanation💯. Thank you !!
Best video…. Each concept is explained very well and precisely!👌🏻
Thankyou so much for making it much easier. it was so confusing in my book . But this helped me alot in understanding.
Purpose fulfilled :) Share it with your friends too !!
This so to-the-point explaination. Appreciate and thank you!
Glad it was helpful!
You should be a professor... Your videos rocks... Please keep making them !!!!
Thank you Michal :) Do subscribe to our channel.
Very easy to understand
Waiting for the next video
This video made it so easy to understand the concept.! Awesome.. best video ever!
Gr8 explanation sir thank you so much
Thanks for liking and commenting :)
The Best Way To Teach As you Explained! Great Job
Amaizing video, thanks very much, my concepts got clear...thanks a lot from Pakistan
When I watch Studytonight I really feel like I can study all night!
(Edit):
Now I have a f*cked up sleep schedule and can't get to sleep until 2 in the afternoon. I stay up all night and have now acquired a caffeine addiction. The addiction was so bad that I tried to fix it with drugs. My parents are now sending me to rehab.
Hi DP. This is Tom's mother. Thank you for your kind words. Unfortunately Tom passed away 3 weeks ago due to a Caffine overdose. Your words would have meant a lot to him.
Such a explicit explanations of normalization.every beginner must watch it to understand the concept.
I sent this playlist to like, me entire DB class :D
Thank you Tareef :) You are true love :)
Now concept cleared.. 👏👏Thank you Sir
never have i ever watched something explained so simply magnificent. i think the animation method oof showing us is the cherry on top. thank you very much ❤😄
Glad you enjoyed it!
Thanking your kind soul for this lovely tutorial. God bless you and your loved ones
Thank you for such lovely comment
You are a legend of teaching........
Thank you Vignesh :)
In*
Hi. The slides are too good for the eyes. It's catchy and clear. Good work. If possible, upload more videos that could be helpful for beginners.
Thank you StudyTonight to make everything easy to understand! Subscribed Already!
Happy to hear that!
This was great. Understanding reasons makes learning a lot easier. Thanks
This channel deserves millions of subscribers because of its quality content.
Thank you Alka. Your words means a lot 🥲 Do share our videos with your friends and colleagues.
Very informative, understandable and clear. Thank you very much.
You are welcome!
Really a quality video man. Very easy to understand explanation.
Please create playlist for DBMS
I like to remember the different kinds of anomalies based on DUI. You wouldn't want to Drive Under the Influence and you wouldn't want Deletion, Update, or Insertion anomalies in your DB.
great video bro, love from Kerala😍
Thanks :)
yoow dude thanks u for this info today i got ah 100% on my presentation yoooooooooow thank you
Thank you for a clear explanation. Short and informative. 👍
I wish you were my lecturer. Great work bro
question about 4:30
Since you normalize by separating the student table and branch table.
If the branch column is CSE on student table, is that mean the expected data of that student on branch table is the data indicated by CSE on the branch table too?
Wow this is the most beautiful and we'll informative video ever I see😊😊😊😊😊
Good video. Unfortunately english the only language I can understand and therefore normally struggle with heavy accents, but yours is clear and the examples are simple so thankyou. 😊
Much awaited channel.