How about I train you on the foundations of Data Modeling? Email me at "ReachBinduKumar@gmail.com" or Telegram at @ReachBinduKumar to sign up for my Live Instructor Led course on "Data Modeling Foundations". I am a Senior Data Architect with over 18 years of real world experience designing Data Architecture for a variety of use cases. See you in my class!
@castillog80265 жыл бұрын
The best explanation to someone that is just starting off in DBMS. Great job on explaining this in detail!
@DataAcademyIN5 жыл бұрын
Thanks George! Your comments are very encouraging :)
@anon12416 Жыл бұрын
I agree, thank you so much!!!
@kc-riyasangle423011 күн бұрын
q@@anon12416
@ravitejapremium2593 жыл бұрын
this is the best DATA MODELLING TUTORIAL i have ever watched. What an explanation good job sir.
@DataAcademyIN3 жыл бұрын
Thank you Raviteja for your encouraging comments ! Please do subscribe.
@logreene43824 жыл бұрын
One hundred percent more thorough and engaging than a textbook. Thank you my friend!
@DataAcademyIN4 жыл бұрын
Thank you Lo Green. Please do subscribe !
@jordanmcquade2303 жыл бұрын
The best explanation of the 3 stages of a data model that I have seen anywhere. Definitely worth a watch. I've just revisited as a refresher now that I'm working in master data management. Thank you for the great video.
@DataAcademyIN3 жыл бұрын
Thank you for your encouraging comments Jordan. I am glad you found it useful. Do subscribe to the channel.
@zishanafzal66713 жыл бұрын
best video available on youtube for understanding Data modeling.
@nikovandh4 жыл бұрын
Wow, great video. I tried to read about data models and was 100% lost. Now I 100% understand after watching this video.
@DataAcademyIN4 жыл бұрын
Happy to hear that Nicholas :) . Please do subscribe to get notified of new videos. Cheers !
@dakshpatel65652 жыл бұрын
Just started my way off with DBMS, being a Mechanical Engineer after going through this, I feel I am in this field since years! Great lesson😌
@DataAcademyIN2 жыл бұрын
Thank you for your comments Daksh! Happy Learning :)
@alipbarua3396 Жыл бұрын
The best tutorial for data modelling. I have interview ahead and this video is really helpful.
@DataAcademyIN Жыл бұрын
Thank you for your comments Alip. All the best for your interview! Please do subscribe.
@amitray66146 жыл бұрын
Great video, just the right depth of coverage, optimum length to keep the viewer engaged. Thanks for taking the effort to prepare and share this. 👍
@DataAcademyIN6 жыл бұрын
Many thanks for the encouraging comments Amit! Please do subscribe to get notified of new videos.
@joankwamboka70021 күн бұрын
O Goodness! This is the clearest explanation I have come across. I think this will stick as well.
@DataAcademyIN3 күн бұрын
Thank you @joankwamboka700. I am glad you found it helpful. Please do Like, Share & Subscribe!
@jayakumari91092 жыл бұрын
Hats off to you...you made it so easy to understand...i used to have very confusion between conceptual and logical data model...but your explanation cleared all my confusion... Thanks a lot..
@DataAcademyIN2 жыл бұрын
Thank you for your feedback Jaya. Please do subscribe !
@TimandTilly6 ай бұрын
Thank you for explaining this! It makes soooo much sense from your POV. My University did not make our weekly lecture notes this simple to understand. Again, thanks dude
@DataAcademyIN6 ай бұрын
Thank you for your encouraging comments :) Please do Like, Share & Subscribe
@juliocamacho70524 жыл бұрын
Thank you for such a clear and accurate explanation of the different database modeling stages
@DataAcademyIN4 жыл бұрын
Many thanks Julio. Please stay subscribed to support !
@boringgamerboi35383 жыл бұрын
Your teaching is clearer than my lecturer , thanks alot man
@DataAcademyIN3 жыл бұрын
Glad to hear that
@lalbihariprajapati94544 жыл бұрын
Just a great video for beginner who want to understand the data model. Thanks for such short but very useful concepts
@DataAcademyIN4 жыл бұрын
Many thanks for your comments Lal Bihari Prajapati. Please do like, share & Subscribe.
@BoxerDogs4 жыл бұрын
This was explained and presented very well. Extremely helpful. Thank you for creating this video. I took some practice tests for the Microsoft Database Fundamentals Exam (98-364). Now I feel like I really understand the parts that I needed to work on.
@DataAcademyIN4 жыл бұрын
Glad it helped! Please do subscribe !
@vinnu236 Жыл бұрын
Great and simple explanation sir. It saves lot of time from reading theory sometimes
@reneeb55854 жыл бұрын
Thank you for such a great explanation with visual examples. This helped me greatly.
@DataAcademyIN4 жыл бұрын
Thank you Renee, for your encouraging comments. In case you found any issues with the audio of this clip, there is a version with improved audio, here --> kzbin.info/www/bejne/mYqaiI2Pnd52adE Please do subscribe in case you haven't. Thanks !
@teetotee2 жыл бұрын
So here's what I understand, I wanna know if it's correct please: Conceptual data models are like the general overview of how the actual data model should look like, like a sketch for a painting or an architecture. Logical data models are idk, more complex? They basically have key and non-key attributes to the entities now and primary and foreign keys can be used. It's still easy to understand, but is harder to update because it's more complex. Physical's simply like, full-fledged. Entities are called tables, attributes columns, it's even harder to understand and really difficult to change.
@DataAcademyIN2 жыл бұрын
Yes, that is a pretty good summary. I am compelled to add just one additional detail to your explanation. The physical data model, apart from being full fledged, is specific to a database, like Oracle or Postgres or SQL Server etc.
@pratyushraizada14724 жыл бұрын
As an analytics engineer, having realised the downstream cost of a bad data model design, I can totally understand the need for having a structured approach. Thanks for the video.
@DataAcademyIN4 жыл бұрын
That is very well said Pratyush. I am glad you realize the importance of a Data Model well executed. Please do subscribe !
@pratyushraizada14724 жыл бұрын
@@DataAcademyIN Done already, keep spreading the knowledge :D
@hamsal_khaldi78512 жыл бұрын
This 13 min video explains one hour lecture. Thank you
@DataAcademyIN2 жыл бұрын
:) Thank you for your sincere comments !
@Kadiar5 жыл бұрын
Best explanation I’ve ever seen for DBMS
@DataAcademyIN5 жыл бұрын
Hello Kadi. Thank for your comments. Please do subscribe to support the effort. Do browse my channel for more such videos. Cheers !
@SathishKumar-u8h2 ай бұрын
Best video for understanding the types data modelling.
@DataAcademyIN2 ай бұрын
Thank you Sathish for your comments. I am glad you found it easy to understand. Please do Like, Share & Subscribe!
@saikiranp.r69665 жыл бұрын
Hands down the best Video out there.
@DataAcademyIN5 жыл бұрын
Much thanks SaiKiran :)
@muhwezifrancis4144 жыл бұрын
thanks because it brings clear description from start to end.
@DataAcademyIN4 жыл бұрын
Thank you Muhwezi. Please do subscribe !
@karunaanugo5572 Жыл бұрын
Really good one for beginners to understand easily
@DataAcademyIN Жыл бұрын
Thank you for your comments Karuna. Please do Like, Share & Subscribe !
@ankushpatil11142 жыл бұрын
This was very detailed yet very simple explanation. Thanks a lot Sir.
@DataAcademyIN2 жыл бұрын
Thank you Ankush for your comments :) Please do subscribe !
@OladipoFamily Жыл бұрын
This explanation is the best. so easy to comprehend...kudos
@DataAcademyIN Жыл бұрын
Glad it was helpful! Please do Like, Share & Subscribe
@raghavendrareddy73704 жыл бұрын
Thanks a lot going for an interview tomorrow this explanation saves me lot time in understanding 😆👍🏻
@DataAcademyIN4 жыл бұрын
Thank you Raghavendra ! I am happy you found it useful. Do subscribe !
@ChilaKasonde5 жыл бұрын
Just wanted to thank you my Lecturer did a terrible job explaining these to me , i now have a clear picture of all 3 models thank you
@DataAcademyIN5 жыл бұрын
Words can't describe how encouraged I feel to hear such comments. Thanks for watching. Do subscribe!
@ChilaKasonde5 жыл бұрын
@@DataAcademyIN ive subscribed keep up the great work, do you have any material on Relational Algebra?
@DataAcademyIN5 жыл бұрын
@@ChilaKasonde I am not an expert on this topic, but it doesn't seem very different from SQL queries on a database. Allow me some time to get back to you with more details.
@ChilaKasonde5 жыл бұрын
@@DataAcademyIN thanks will be waiting i think it would be a good video as no one has covered it from what I've seen
@nitagawade33304 жыл бұрын
Big Thank you Sir for such wonderful explaination!!! Waiting for more video with some business cases
@ongeek98343 жыл бұрын
Very helpful and informative, Please keep educating people. God Bless.
@DataAcademyIN3 жыл бұрын
Thank you for encouragement KoloHe. Appreciate it. Please do subscribe !
@neha62216 жыл бұрын
This is actually really good explanation.
@DataAcademyIN6 жыл бұрын
Thanks Gunjan !
@akapurvis11734 жыл бұрын
Excellent explanation. Short, sweet, and to the point while covering all the essentials to data modeling. Thx you😉
@DataAcademyIN4 жыл бұрын
Many thanks for your honest comments. Please do subscribe !
@jpf19505 жыл бұрын
You did a good job here. Your diction and pacing were perfect. The diagrams were simple and complete. Thanks.
@DataAcademyIN5 жыл бұрын
Thank you John for the encouragement. Please do browse my channel for other videos. Do subscribe to get notified of new uploads. Thanks !
@nikunjmodi52147 жыл бұрын
Very helpful. Clearly defined each and every models !!!
@DataAcademyIN6 жыл бұрын
Thank You Nikunj !
@swaragupta7932 Жыл бұрын
Best explanation for these 3 models
@omurnebierarslan81732 жыл бұрын
Very clear explanation of the topic...really appreciate it.
@DataAcademyIN2 жыл бұрын
Thank you Ömür for your comment. I am glad you found it useful. Please do subscribe!
@sravanthiakula1923 Жыл бұрын
Very well explained and all the details are clearly described. Subscribed😊
@DataAcademyIN Жыл бұрын
Thank you Sravanthi :)
@juvettemunji79843 жыл бұрын
this is the best explanation ever. You solve my problem
@DataAcademyIN3 жыл бұрын
Thank you Juvette. Please do subscribe!
@fabricejaouen42524 жыл бұрын
Very simple video, but extremely clear: it helped a lot before digging into more detailed tutorials. Great work indeed.
@DataAcademyIN4 жыл бұрын
Thank you Fabrice ! Please stay subscribed to support !
@fabricejaouen42524 жыл бұрын
@@DataAcademyIN : Of course !
@jyothyg66532 жыл бұрын
Thank you so much for such a wonderful explanation…. Brief and crisp!
@DataAcademyIN2 жыл бұрын
Thank you for your encouraging comments Jyothy. Please do subscribe !
@anoniem0125 жыл бұрын
Thanks finally an English titled video who is actually explained in English.. :) Very well
@DataAcademyIN5 жыл бұрын
Thank you Mr. Tarik. Encouraging words like yours are worth the effort. Feel free to browse my channel, and do subscribe :)
@osofhia5 жыл бұрын
Without doubt, the best tutorial, even with my experience that was refreshing!
@DataAcademyIN5 жыл бұрын
Thank You ! Please do subscribe.
@utkucansa2 жыл бұрын
you explained it in a great and plain way. Thanks.
@DataAcademyIN2 жыл бұрын
You're very welcome!
@lavanyagopal.manditheater4 жыл бұрын
very simply explained and easy to understand. Thanks !!
@DataAcademyIN4 жыл бұрын
Many thanks Lavanya. I am glad you found it easy to understand. Please do subscribe to get notified of new uploads. Cheers !
@arunmehta82344 жыл бұрын
Awesome video. Very Explanatory.
@DataAcademyIN4 жыл бұрын
Thank you Arun. Please do subscribe !
@TechnoDB4 жыл бұрын
Wow.. clear explanation with diagrams.
@DataAcademyIN4 жыл бұрын
Thank you Dinesh !
@seanjharrs4 жыл бұрын
Great Presentation , covers all the important points, many thanks
@DataAcademyIN4 жыл бұрын
Thanks for your comment Sean. Appreciate it. Please do subscribe in case you haven't. Cheers!
@kajalpundir2423 Жыл бұрын
Commendable explanation..please upload more videos ...of business intelligence
@DataAcademyIN Жыл бұрын
Thank you Kajal. Please do Like, Share & Subscribe. I am working on content that includes end to end DWBI with real-world data. So stay tuned 😎
@sarahahmed21124 жыл бұрын
Very helpful, clear and detailed! Thanks a lot.
@DataAcademyIN4 жыл бұрын
Thank you Sarah ! Please do subscribe for more such videos. Cheers !
@rasthana4 жыл бұрын
Very useful video. Thanks for your efforts in sharing this knowledge.
@DataAcademyIN4 жыл бұрын
Thanks for your comments Ravi :) Please do subscribe for supporting more such content !
@balasubramanianilangovan8883 жыл бұрын
I appreciate your efforts to prepare such a wonderful video!
@DataAcademyIN3 жыл бұрын
Thank you for your encouraging comments.
@Eva.26111 ай бұрын
Simply the BEST. Thank you!
@DataAcademyIN10 ай бұрын
Thank you Evelyn. Please do Like, Share & Subscribe!
@itishreenayak59842 жыл бұрын
such a clear description, thanks
@DataAcademyIN2 жыл бұрын
Thank you Itishree for your comments. Please do subscribe!
@abdullahalkafi55843 жыл бұрын
Awesome 10 minutes 👍
@sudharshanchakrapani71113 жыл бұрын
Wonderfull explanation Sir. Thank you very much for making the video.
@DataAcademyIN3 жыл бұрын
Thank you for your comments Sudarshan !
@nitagawade33304 жыл бұрын
Big Thank you sir for such a wonderful explantion......waiting for more video wid business cases
@DataAcademyIN4 жыл бұрын
Thank you Nita for your kind words :) Stay subscribed to get notified of new videos when I do upload. Pretty soon.
@asadalisoomro89373 жыл бұрын
very helpul and conceptual video. Thanks a lot buddy.
@DataAcademyIN3 жыл бұрын
Thank you Asad !
@muhammadfaisalhyder40124 жыл бұрын
This is really great for revision purposes 😅 short and to the point. 👍
@DataAcademyIN4 жыл бұрын
Hello Muhammad. Glad you think so! :) Please do Like, Share & Subscribe !
@abuhamza1970 Жыл бұрын
Absolutely brilliant video. Thank you sir! 🙏
@DataAcademyIN Жыл бұрын
Thank you for your comments :) Please do Like, Share & Subscribe
@Shades.of.life.by.Vandana5 жыл бұрын
very good and very well explained in clear english
@DataAcademyIN5 жыл бұрын
Thanks Mohit. Please do subscribe to get notified of new videos.
@geraldowusuansah36732 жыл бұрын
Well understood. Thanks for the lecture
@jacekkangaroo44022 жыл бұрын
It looks like I was learning different data modelling methodology 😃 1. logical model, called also Entity Relationship Diagram (ERD) represents entities and main relations between them, has usually primary keys and some main attributes as well, entity is drawn as a rectangle with rounded corners, and entity name is always singular, an entity is one instance of something, 2. physical model, called also as Data Diagram (DD) is generated from ERD also FK columns are added automatically, other columns can be added to the DD manually as well as other UK, indexes and partitions, entities are called tables, attributes are called columns, table is drawn as a rectangle with sharp corners, having a well designed DD we can generate table creation scripts so no manual work is required from developers, table name is always plural, a table is a collection of entities, 3. we should avoid adding a table name to table column names, table product should have columns description, name, short name, size... but not product_name, product_description, product_size...
@MrAndrewjdavis2 жыл бұрын
"not product_name, product_description" - depends. If the target of the model is reporting, you would end up with 10 columns all called "name" which is confusing and you would spend ages renaming each column in the report. Much better to give them full names. The other advantage of having the table name is if it is a foreign key, you can use the target table name (with role if needed) e.g. "Product_Id,Product_Code,ProductGroup_Id" or "Customer_Party_Id, SalesRep_Party_Id"
@jacekkangaroo44022 жыл бұрын
@@MrAndrewjdavis yes and no :-) if you want to distinguish columns from different tables, you can use table and column aliases, it takes a bit more work but it is better in my opinion, also a column name like "Product_Name" looks ugly on the report for end users, usually it will be renamed as "Name" or "Product name" on reports, not to mention that reports may be created in other languages, what people from English-speaking countries forget often, databases are usually built in English as they are often created by international teams, while reports are created in accordance with local requirements and often have to be created in the official language of a given country
@sohanchowdhury34163 жыл бұрын
Very well explained.. Good way of explaining as well.. Great video 👍
@DataAcademyIN3 жыл бұрын
Thanks a lot 😊
@charujain71653 жыл бұрын
Very well explained. Thanks !!
@DataAcademyIN3 жыл бұрын
Thank you Charu ! Please do subscribe.
@marycross55263 жыл бұрын
Thank you so much. This was very helpful.
@DataAcademyIN3 жыл бұрын
Glad it was helpful!
@radhikasrinivasa30683 жыл бұрын
Thanks a lot!! I'm not from science background, but still could understand clearly!!
@DataAcademyIN3 жыл бұрын
Thank you Radhika. Happy to hear that comment :) I am glad it helped. Please do subscribe !
@KJOB4 жыл бұрын
You saved me a lot of time man, thanks
@DataAcademyIN4 жыл бұрын
Glad to hear that. Thanks!
@nathankomer86994 жыл бұрын
Thank you, this is a consize and easy to process introduction!
@DataAcademyIN4 жыл бұрын
Thank you for your nice comments Nathan. Please do subscribe !
@aqibmehmood5 жыл бұрын
Just what I was looking for. Excellent tutorial!
@DataAcademyIN5 жыл бұрын
Thanks Aqib !
@mounichowdary80043 жыл бұрын
You did a great job, your explanation is too good thank you!!
@DataAcademyIN3 жыл бұрын
Thank you Mouni. Glad you found it helpful. Please do subscribe if you haven't already :)
@saumyojitdas42125 жыл бұрын
Cleared my doubt. Excellent video.
@DataAcademyIN5 жыл бұрын
Thank you Saumyojit. I am glad you found it useful. Please do subscribe to get notified when I upload related useful videos.
@pinkldy1005 жыл бұрын
Great quick intro to the different levels. Thank you!
@DataAcademyIN5 жыл бұрын
Thank you J !
@larisamuntyan556 Жыл бұрын
excellent video! thank you very much!
@DataAcademyIN Жыл бұрын
Thank you for your comments. Please do subscribe!
@YasirAli-ot3uz2 жыл бұрын
Best explanation ever
@DataAcademyIN2 жыл бұрын
Many thanks Yasir :)
@Juan-Hdez Жыл бұрын
Very useful. Thank you!
@DataAcademyIN Жыл бұрын
Thank you for your comment. I am glad you found it useful. Please do subscribe!
@muhammadlukysyahir3054 жыл бұрын
Thank you very much, this video really help my work
@DataAcademyIN4 жыл бұрын
Thank you Muhammad Lucky Syahir. Please do subscribe !
@junkingjunking8477 Жыл бұрын
Nice explanation. Thank you, sir😊
@Runtothemusic5 жыл бұрын
Excellent explanation, very easy to understand. Thank You.
@DataAcademyIN5 жыл бұрын
Thank you for your comments. Do subscribe to get notified of new uploads.
@xudong52692 жыл бұрын
you killed the game, my friend!
@estebanlopez17014 жыл бұрын
This is just brilliant, keep it up
@DataAcademyIN4 жыл бұрын
Thank You :)
@suniait501894 жыл бұрын
Very nicely explained . Superbbb :)
@DataAcademyIN4 жыл бұрын
Thank you Sunita :)
@try0103 жыл бұрын
Many thanks man This helped me !
@DataAcademyIN3 жыл бұрын
Thank you Mostafa !
@digigoliath5 жыл бұрын
Clear & Concise. Great job & TQ!!
@DataAcademyIN5 жыл бұрын
Thank you. Please do subscribe for more such videos.
@digigoliath5 жыл бұрын
@@DataAcademyIN You already have a new subscriber & I will be back for more!
@richie16035 жыл бұрын
Crystal clear explanation
@DataAcademyIN5 жыл бұрын
Thank you Richie ! If you liked the content, please do subscribe to show your support. Do browse my channel for other videos that you may find useful. Thanks !
@ruthmk6 ай бұрын
Thanks very insightful
@DataAcademyIN6 ай бұрын
I am glad you found it useful. Please do subscribe to support my work🙏
@nitinbobde31702 жыл бұрын
Excellent video
@DataAcademyIN2 жыл бұрын
Thank you Nitin
@kjbiliks6 ай бұрын
Very informative thanks
@DataAcademyIN6 ай бұрын
Glad it was helpful. Please do Like, Share & Subscribe!
@Rowlands-ml3ib Жыл бұрын
Super helpful and clearly explained! 😊
@DataAcademyIN Жыл бұрын
Thank you Rowlands for your comments. Please do subscribe !
@parshubhai93512 жыл бұрын
Very nice explained 😌😌 thanks for this buddy.
@DataAcademyIN2 жыл бұрын
Thank you 🙏 please do subscribe
@andielambourne232 Жыл бұрын
Simply explained, however, I am still unclear regarding the Primary and Foreign keys, what they are and their purpose, you seemed to say they are exactly the same as the Key Attribute? What? Both Primary Key and Foreign Key are also Key Attribute? Why have 3 names for same thing if so?
@DataAcademyIN Жыл бұрын
Hello Andie. Apologies for the delay in responding. Regarding your question - Primary Key and Foreign Key are related but are not the same. A Primary Key is used to assign a column or a set of columns to be used to uniquely identify records in a table, and thus enforcing uniqueness and avoid duplicates. A Foreign Key is used to validate data to ensure that the values entered in a Foreign Key column are already present in the Primary Key of another table. Hence enforcing data integrity between them. For more detailed information, you may refer to the below link Primary Key - en.wikipedia.org/wiki/Primary_key Foreign Key - en.wikipedia.org/wiki/Foreign_key In the Video when I said Key attributes, I meant to say that what we DB professionals refer to as Primary Key & Foreign Key attributes, in the data modeling phase, we sometimes simply refer to them as Key Attributes to make it easy for a non-technical or business folks to understand. To Summarize, Primary Key and Foreign Key have a more technical meaning from a physical data model perspective, whereas a key attribute is a broad term used during the data modeling phase to refer to any kind of unique columns, primary columns or foreign keys. Hope this answers the question.
@rhyme63002 жыл бұрын
Very clear, thank you
@DataAcademyIN2 жыл бұрын
I am happy you found it helpful. Thank you for your comments. Please do subscribe !
@kalkibhavsar82082 жыл бұрын
Very Helpful!
@DataAcademyIN2 жыл бұрын
Glad it was helpful!
@wilmerpiedrahita80324 жыл бұрын
Very good presentation and tips. Thanks for sharing this, it is very helpful indeed.
@DataAcademyIN4 жыл бұрын
Many thanks Wilmer. Please do subscribe !
@vijayotnm4 жыл бұрын
Excellent, thank you
@DataAcademyIN4 жыл бұрын
Glad you enjoyed it Vijayan. Please do Subscribe !
@amisam2215 Жыл бұрын
Really cool explanation!!!
@DataAcademyIN Жыл бұрын
Thank you Ami for you comments. Please do subscribe !
@sarathfromsaudi6 жыл бұрын
Easy to follow style of explaining. Thanks
@DataAcademyIN6 жыл бұрын
Thanks Sarath!
@zangorjanc81493 жыл бұрын
There can be datatypes used in logical model too! And deffreance betwene logical and physcal model its just that physcal name of atributes are just more relateble to names that we will use in our DATABASE...
@DataAcademyIN3 жыл бұрын
I agree with you that this is allowed, but I feel that it defeats the purpose of a Logical schema. A Logical schema should NOT be specific to a database. Hence, if we were to mention the Datatype, it should be a generic datatype. For example - A datatype of STRING maybe used in Logical schema, whereas in the Physical schema, this may map to either a VARCHAR or TEXT datatype (PostgreSQL Datatypes).