This guy was my teacher 8 years ago at the Business Academy in Aarhus, Denmark. He is an incredible teacher and it was during his classes that I got hooked on web development. I was always looking forward to it. Today I am succesfully working as a software developer in my own consultancy. Thanks a lot for your help Niels.
Very good walkthrough. I have an onsite interview tomorrow for a new-grad engineering role and they told me they will be harping on data-modeling so this was the perfect crash-course to get me ready! Fingers crossed it goes well!!
Bro only this man is able to fully explain data modelling,, though Erwin association also explain Edureka and many more but all their example were not relevant but this simple man explain very beautifully, this man haa actually an art of teaching.........yes you may find many other videos but this man............
Great video. your explanation of the intermediate tables really helped me in my class I had a many to many relationship I had to resolve and I could not wrap my head around resolving it in an elegant manor. Your video really cleared that up for me. Thanks
Excellent! the way of explanation is marvellous. Basic and benefits of data modelling has been taught without mentioning it and extremely simple way. It helped me a lot to clear my doubts. Thanks.
I enjoyed watching this video and recommend to others. Host has good knowledge on the subject and content has been clearly and crisply explained with examples.Also guided to where to download the Data Modeling tool. I wish if he could have added little day to day problems encountered in data modeling and resolving the same with experience would further help the audience since you are addressing large and varies of audiences. It's fine with out since video time took more than expected amount of time. Generally video to run for max 15 to 20 mins otherwise audiences may get bored and will not continue. If you have any questions on my comment let me know and we can discuss. When you release next video let me know I will give my feedback. Thanks for educating the community and appreciate your volunteership. Thanks a bunch
At 45:30 you create the zip_city table with an Auto Increment PK, this would not work for your zip codes as AI start at 0 and increment by one on every new record; unless explicitly instructed to do otherwise. Most countries use alpha-numeric post codes which are not inherently incremental, so this would also fail to work. Otherwise, thanks
I noticed when creating a many to many relationship between two tables using workbench, if you click the many to many linker and connect the two tables, it will create the in-between table automatically and guess the foreign key references for you.
I don't quite understand why you would want to move the class names out of the student table in a separate table. The classes MDU12Q2, MDU12P2 and MDU12S2 are as unique as the numbers 1, 2 or 3 are, aren't they? For the rest it is a very useful vid.
Hans Kamp If one were to list classes in the students table, the only information we could glean about the class was whether each specific student was taking it or not. Keeping the classes in their own table allows you to attach more information to the class entity such as description, credit hours, grading type, etc. It's more conducive to scaling, as later, we could add a table named professors and then build a relationship between classes and professors. Finally, imagine all the empty and wasted space if there were 100 classes to choose from, but a student only took one class. There would be 99 columns in that table not being used in that particular row. Hope my answer helped!
Thanks Niels for an awesome introduction. I have two questions and would need clarity. 1. When populating the tables; student, zip city and classes, is there any order to follow? 2. Do we populate the student_class table (i.e. the intermediate table)? Or it just to keep the relationship.
hats off Niels Sir. Please come up with a video on complex relational data model design as well. Also, would appreciate if you prepare dimensional modelling(dim tables, views and fact tables) for a sample data warehouse project like this video. Thank you very much sir.
Niels, many thanks! Perhaps it was how you used the students and classes as example, perhaps it was the cool accent. Either way, I finally understand basic data modeling.
Thank you so much. You explained the basics in very detail. But i didn't understand why you want to auto increment the zip table ID. I guess that will create a wrong zip code for the cities.
Some database systems do work like this. If you know the zip code and the house number, after looking in the zip code database you will also know the street name and the city to which the zip code belongs. Then you finally have the address. For that reason the streetname can also be left out. In the Netherlands at least the zip code consists of 4 digits and 2 uppercase letters. It will relate to a part of the street and group some numbers of adjacent buildings (often houses) and is unique for the city. The more you leave out from the zip code the bigger the area is.
I agree that the zip code should not be auto-increment. Instead, there should be an external entity on the internet where you can look up for the city name if you know the zip code.
Great video! Really useful diagrams and explanations. Suggestion: would have been good to include boolean/logical data type in your table @ 28:00 as this is also extremely common.
Niels, this is outstanding. I made a Visio Info-Graphic of your presentation to help me assimilate all of the points you made. If you would like a copy, I'd be happy to send it to you. \
This guy was my teacher 8 years ago at the Business Academy in Aarhus, Denmark.
He is an incredible teacher and it was during his classes that I got hooked on web development. I was always looking forward to it.
Today I am succesfully working as a software developer in my own consultancy.
Thanks a lot for your help Niels.
Really loved reading this. Good teachers need to be recognized! 💯
Very good walkthrough. I have an onsite interview tomorrow for a new-grad engineering role and they told me they will be harping on data-modeling so this was the perfect crash-course to get me ready! Fingers crossed it goes well!!
This is a good presentation for people who do not know anything about Data Modeling, and they could learn more from this presentation
Your content is still relevant after so many years. Thank you!
Amazing. Very simple and clear. I am not new to data modeling. I was just browsing you tube and found this video. I couldn't stop watching. Thanks.
Bro only this man is able to fully explain data modelling,, though Erwin association also explain Edureka and many more but all their example were not relevant but this simple man explain very beautifully, this man haa actually an art of teaching.........yes you may find many other videos but this man............
Very clear, instructive, cover from basis up to a reasonable project.
Hard to see such didatics.
My sinserely complements!
Thanks Niels for clear explanation of each step practically involved in modeling.
Excellent video! Very clear and precise. Thank for keeping it simple and easy to understand. You should make more tutorials like this one.
Amazing clarity, excellent presentation and very helpful. One of the best tutorials I have ever seen. Thank you so much
Don't know what's clear about it.
Great video. your explanation of the intermediate tables really helped me in my class I had a many to many relationship I had to resolve and I could not wrap my head around resolving it in an elegant manor. Your video really cleared that up for me. Thanks
This is just too good to be true, your explanation is spot on!!
I was looking very hard for a good quality intro course on these matters. Thank you sir
this is a must for any person new to databases !!!
Excellent tutorial. Clean, clear and precise explanations. Thanks Niels!
Excellent! the way of explanation is marvellous. Basic and benefits of data modelling has been taught without mentioning it and extremely simple way.
It helped me a lot to clear my doubts.
Thanks.
The MySQL example is super helpful. Thank you!
I enjoyed watching this video and recommend to others.
Host has good knowledge on the subject and content has been clearly and crisply explained with examples.Also guided to where to download the Data Modeling tool.
I wish if he could have added little day to day problems encountered in data modeling and resolving the same with experience would further help the audience since you are addressing large and varies of audiences. It's fine with out since video time took more than expected amount of time. Generally video to run for max 15 to 20 mins otherwise audiences may get bored and will not continue.
If you have any questions on my comment let me know and we can discuss.
When you release next video let me know I will give my feedback.
Thanks for educating the community and appreciate your volunteership.
Thanks a bunch
Brilliant! This is the best explanation I've come across. Thank you!!
Just one thing: why auto increment is checked for zip_city table's zip column.
Rest is awesome. thanks Niels for the tutorial!
This was so much more clear than what my professor was teaching in class. You should make more educational videos like this. It helps a lot!!
Niel Thank, your illustration has moved a lot of road blocks for one in understanding modelling; I wish you have more youtube examples on modelling.
Great video! One small question, at 29:15. What does the number in brackets mean by VARCHAR?
Great video! very well explained Data Modeling.
Very helpful presentation specially normalization part. Thanks a lot!!!!
watch on 1.25X / 1.5X speed :)
I watched on 2X speed. XD
1.5 was very optimal for me ;)
or 2.0
I watched on 2.10x speed but great content what I needed to know.
Brilliant...very well explained end to end concepts...
At 45:30 you create the zip_city table with an Auto Increment PK, this would not work for your zip codes as AI start at 0 and increment by one on every new record; unless explicitly instructed to do otherwise. Most countries use alpha-numeric post codes which are not inherently incremental, so this would also fail to work.
Otherwise, thanks
I noticed when creating a many to many relationship between two tables using workbench, if you click the many to many linker and connect the two tables, it will create the in-between table automatically and guess the foreign key references for you.
Hey Dude , thank you a lot for this amazing video tutorial about data modeling very clarity , appreciate.
Very good explanation.
Simple and apt explanation for the basics. Very good presentation indeed!
Thank you. explained in very simple way and easy to understand.
Really great! Thank a lot for your channel :)
Could you please explain the differences between different data models(Inmon,Kimball,3NF,Dimension Modelling,Data Vault).
I don't quite understand why you would want to move the class names out of the student table in a separate table. The classes MDU12Q2, MDU12P2 and MDU12S2 are as unique as the numbers 1, 2 or 3 are, aren't they?
For the rest it is a very useful vid.
Hans Kamp If one were to list classes in the students table, the only information we could glean about the class was whether each specific student was taking it or not. Keeping the classes in their own table allows you to attach more information to the class entity such as description, credit hours, grading type, etc. It's more conducive to scaling, as later, we could add a table named professors and then build a relationship between classes and professors.
Finally, imagine all the empty and wasted space if there were 100 classes to choose from, but a student only took one class. There would be 99 columns in that table not being used in that particular row.
Hope my answer helped!
***** If you want to add additional information to classes, you are right, indeed. :)
Brilliant Teaching Skills...Awesome!! and you kept it simple
Great. Simple and easy to follow.
Very good presentation for beginners.
simple and good clarity.. worth listening to it. it helped.. thanks a lot!!
Well explained: helps me to catch up with lectures i missed
Niels, pheraps mi comentaries are of out the time, i hope that you sincerily accepts my admiration about your excelent video, for me is the 2017
Excellent presentation..
Excellent presentation - thanks Niels!
Thanks Niels for an awesome introduction. I have two questions and would need clarity. 1. When populating the tables; student, zip city and classes, is there any order to follow? 2. Do we populate the student_class table (i.e. the intermediate table)? Or it just to keep the relationship.
Thanks for the clear explanation on the subject...
An entity is a column of a table and displays the charactheristics or the properties of a table?
hats off Niels Sir. Please come up with a video on complex relational data model design as well. Also, would appreciate if you prepare dimensional modelling(dim tables, views and fact tables) for a sample data warehouse project like this video. Thank you very much sir.
Very well done!
Why are all relations on your MySQL Workbench non-identifying, though? Esp. students --> students_classes
Very nicely explained...... Awesome :)
Wonderful ! Helped me to get the basics...
Can I get your PPT on this one? If you don't mind. Really needed for my Report.
good introduction on Data modeling
Hi Around 19.32 instead of saying "One student can only be in one class" you might want to say "One student can only be in a class once".
Wonderful tutorial. Loved it
Niels, many thanks! Perhaps it was how you used the students and classes as example, perhaps it was the cool accent. Either way, I finally understand basic data modeling.
I learned that we must avoid many - to - many relations, because no database can handle that.
But why replace a one - to one relation by a attribute?
Excellent and was very helpful. Thanks
great and simple explaination.
Thank you so much. You explained the basics in very detail. But i didn't understand why you want to auto increment the zip table ID. I guess that will create a wrong zip code for the cities.
Yes. zip should not be auto-increment.
Some database systems do work like this. If you know the zip code and the house number, after looking in the zip code database you will also know the street name and the city to which the zip code belongs. Then you finally have the address. For that reason the streetname can also be left out.
In the Netherlands at least the zip code consists of 4 digits and 2 uppercase letters. It will relate to a part of the street and group some numbers of adjacent buildings (often houses) and is unique for the city. The more you leave out from the zip code the bigger the area is.
I agree that the zip code should not be auto-increment. Instead, there should be an external entity on the internet where you can look up for the city name if you know the zip code.
Thank you Sir, It was easy to understand the concept.
Excellent presentation
Thanks, really didatic and useful.
Hope to be answered soon.
Superb presentation.. thanks alott
can you give me the link that direct to download mysql workbench?
Great video - very easy to follow and understand. Thanks!
Very good 👍 tutorial! Thank you!
Awesome course thanks
Really enjoyable
great presentation hygiene and easy to follow :)
Perfectly explained
Great video! Really useful diagrams and explanations. Suggestion: would have been good to include boolean/logical data type in your table @ 28:00 as this is also extremely common.
Damn, your speaking it in such easy to understand that a stupid guy like me can understand this complex concept!
Hi, nice video, I have a cuestion, how can do a insert, with this kind of model?
Made it easier to understand! Thank you sir!
Thank you for a clear explanation!
Thank you. Great tutorial, very helpful and clear.
Excellent Tutorial!! Thank You
Nice explanation niels , It was easy to understand. Thanks a lott
excellent video, very helpful, thank you!
I liked and I loved this video
Nice job done
Well done
Very informative. Thank you for this!
Cool. I liked video
very good intro
This was great thank you
excellent!!!
U r the best :) Thanks for the Video appreciate
Thank you. It was very useful.
Just one word: Wow
thanks, very useful and clear
I wanna watch your lessons in order what should I watch 2nd
thank you! i enjoyed your lesson a lot :)
Tusind tak!
Niels, this is outstanding. I made a Visio Info-Graphic of your presentation to help me assimilate all of the points you made. If you would like a copy, I'd be happy to send it to you.
\
awesome
Can you send me this ppt presentation? Thanks!
so good, thank you so much
how to do it practically. data modelling