Learn about the 3 stages of a Data Model Design - Conceptual Data Model - Logical Data Model - Physical Data Model
Жүктеу.....
Пікірлер: 399
@DataAcademyINКүн бұрын
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!
@DataAcademyIN
5 жыл бұрын
Thanks George! Your comments are very encouraging :)
@anon12416
Жыл бұрын
I agree, thank you so much!!!
@amitray66145 жыл бұрын
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. 👍
@DataAcademyIN
5 жыл бұрын
Many thanks for the encouraging comments Amit! Please do subscribe to get notified of new videos.
@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.
@DataAcademyIN
3 жыл бұрын
Thank you for your encouraging comments Jordan. I am glad you found it useful. Do subscribe to the channel.
@ravitejapremium2593 жыл бұрын
this is the best DATA MODELLING TUTORIAL i have ever watched. What an explanation good job sir.
@DataAcademyIN
3 жыл бұрын
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!
@DataAcademyIN
4 жыл бұрын
Thank you Lo Green. Please do subscribe !
@zishanafzal66712 жыл бұрын
best video available on youtube for understanding Data modeling.
@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😌
@DataAcademyIN
2 жыл бұрын
Thank you for your comments Daksh! Happy Learning :)
@karunaanugo5572 Жыл бұрын
Really good one for beginners to understand easily
@DataAcademyIN
Жыл бұрын
Thank you for your comments Karuna. Please do Like, Share & Subscribe !
@nikovandh4 жыл бұрын
Wow, great video. I tried to read about data models and was 100% lost. Now I 100% understand after watching this video.
@DataAcademyIN
4 жыл бұрын
Happy to hear that Nicholas :) . Please do subscribe to get notified of new videos. Cheers !
@nikunjmodi52146 жыл бұрын
Very helpful. Clearly defined each and every models !!!
@DataAcademyIN
6 жыл бұрын
Thank You Nikunj !
@juliocamacho70524 жыл бұрын
Thank you for such a clear and accurate explanation of the different database modeling stages
@DataAcademyIN
4 жыл бұрын
Many thanks Julio. Please stay subscribed to support !
@BoxerDogs3 жыл бұрын
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.
@DataAcademyIN
3 жыл бұрын
Glad it helped! Please do subscribe !
@jpf19505 жыл бұрын
You did a good job here. Your diction and pacing were perfect. The diagrams were simple and complete. Thanks.
@DataAcademyIN
5 жыл бұрын
Thank you John for the encouragement. Please do browse my channel for other videos. Do subscribe to get notified of new uploads. Thanks !
@pinkldy1004 жыл бұрын
Great quick intro to the different levels. Thank you!
@DataAcademyIN
4 жыл бұрын
Thank you J !
@reneeb55854 жыл бұрын
Thank you for such a great explanation with visual examples. This helped me greatly.
@DataAcademyIN
4 жыл бұрын
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 --> kzread.info/dash/bejne/lY1rubySmNypY9I.html Please do subscribe in case you haven't. Thanks !
@neha62216 жыл бұрын
This is actually really good explanation.
@DataAcademyIN
6 жыл бұрын
Thanks Gunjan !
@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..
@DataAcademyIN
2 жыл бұрын
Thank you for your feedback Jaya. Please do subscribe !
@nitagawade33304 жыл бұрын
Big Thank you Sir for such wonderful explaination!!! Waiting for more video with some business cases
@TimandTilly4 ай бұрын
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
@DataAcademyIN
4 ай бұрын
Thank you for your encouraging comments :) Please do Like, Share & Subscribe
@pratyushraizada14723 жыл бұрын
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.
@DataAcademyIN
3 жыл бұрын
That is very well said Pratyush. I am glad you realize the importance of a Data Model well executed. Please do subscribe !
@pratyushraizada1472
3 жыл бұрын
@@DataAcademyIN Done already, keep spreading the knowledge :D
@vinnu23611 ай бұрын
Great and simple explanation sir. It saves lot of time from reading theory sometimes
@nathankomer86993 жыл бұрын
Thank you, this is a consize and easy to process introduction!
@DataAcademyIN
3 жыл бұрын
Thank you for your nice comments Nathan. Please do subscribe !
@raghavendrareddy73704 жыл бұрын
Thanks a lot going for an interview tomorrow this explanation saves me lot time in understanding 😆👍🏻
@DataAcademyIN
4 жыл бұрын
Thank you Raghavendra ! I am happy you found it useful. Do subscribe !
@lalbihariprajapati94544 жыл бұрын
Just a great video for beginner who want to understand the data model. Thanks for such short but very useful concepts
@DataAcademyIN
4 жыл бұрын
Many thanks for your comments Lal Bihari Prajapati. Please do like, share & Subscribe.
@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.
@saikiranp.r69665 жыл бұрын
Hands down the best Video out there.
@DataAcademyIN
5 жыл бұрын
Much thanks SaiKiran :)
@fabricejaouen42524 жыл бұрын
Very simple video, but extremely clear: it helped a lot before digging into more detailed tutorials. Great work indeed.
@DataAcademyIN
4 жыл бұрын
Thank you Fabrice ! Please stay subscribed to support !
@fabricejaouen4252
4 жыл бұрын
@@DataAcademyIN : Of course !
@jyothyg6653 Жыл бұрын
Thank you so much for such a wonderful explanation…. Brief and crisp!
@DataAcademyIN
Жыл бұрын
Thank you for your encouraging comments Jyothy. Please do subscribe !
@aqibmehmood5 жыл бұрын
Just what I was looking for. Excellent tutorial!
@DataAcademyIN
5 жыл бұрын
Thanks Aqib !
@user-jn9mf5ye9v Жыл бұрын
This explanation is the best. so easy to comprehend...kudos
@DataAcademyIN
Жыл бұрын
Glad it was helpful! Please do Like, Share & Subscribe
@akapurvis11734 жыл бұрын
Excellent explanation. Short, sweet, and to the point while covering all the essentials to data modeling. Thx you😉
@DataAcademyIN
4 жыл бұрын
Many thanks for your honest comments. Please do subscribe !
@Kadiar4 жыл бұрын
Best explanation I’ve ever seen for DBMS
@DataAcademyIN
4 жыл бұрын
Hello Kadi. Thank for your comments. Please do subscribe to support the effort. Do browse my channel for more such videos. Cheers !
@DataAcademyIN4 жыл бұрын
Hello Subscribers! A lot of you had complained about the poor audio quality in this clip. So I am re-uploading this video with enhance audio. Watch it here - kzread.info/dash/bejne/lY1rubySmNypY9I.html
@Niko-zl5hn
3 жыл бұрын
how are data models different from data schema or are they the same thing
@DataAcademyIN
3 жыл бұрын
Hello Nico. I understand the confusion. Data Model and Data Schema sound very similar, or they are seem interchangeable. For the sake of clarity, I would explain "Data Model as a pictorial representation of the different Database tables and their relationship". This pictorial representation may not contain some advanced database objects such as Stored Procedures, Indexes, functions, triggers etc. Whereas "Data Schema is the actual collection of database objects that includes tables, views, stored procedures, indexes etc. A schema is usually represented by a bunch of .SQL files that contain the script." To summarize, Data Model is mostly a pictorial representation, whereas Data Schema or Schema is the actual script used to implement the physical database. Be aware that some people/organizations tend to mix these above definitions.
@Niko-zl5hn
3 жыл бұрын
@@DataAcademyIN thank you
@muhwezifrancis4144 жыл бұрын
thanks because it brings clear description from start to end.
@DataAcademyIN
4 жыл бұрын
Thank you Muhwezi. Please do subscribe !
@junkingjunking847710 ай бұрын
Nice explanation. Thank you, sir😊
@Eva.2618 ай бұрын
Simply the BEST. Thank you!
@DataAcademyIN
8 ай бұрын
Thank you Evelyn. Please do Like, Share & Subscribe!
@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...
@MrAndrewjdavis
2 жыл бұрын
"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"
@jacekkangaroo4402
2 жыл бұрын
@@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
@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.
@DataAcademyIN
2 жыл бұрын
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.
@anoniem0125 жыл бұрын
Thanks finally an English titled video who is actually explained in English.. :) Very well
@DataAcademyIN
5 жыл бұрын
Thank you Mr. Tarik. Encouraging words like yours are worth the effort. Feel free to browse my channel, and do subscribe :)
@swaragupta793211 ай бұрын
Best explanation for these 3 models
@TheSkauskas6 жыл бұрын
Simple and clear. Thank you!
@DataAcademyIN
6 жыл бұрын
Than You Ilona !
@geraldowusuansah36732 жыл бұрын
Well understood. Thanks for the lecture
@ezradongijena17726 жыл бұрын
thnx vry much u explained it all well
@DataAcademyIN
6 жыл бұрын
Thank you Ezra !
@mounichowdary80043 жыл бұрын
You did a great job, your explanation is too good thank you!!
@DataAcademyIN
3 жыл бұрын
Thank you Mouni. Glad you found it helpful. Please do subscribe if you haven't already :)
@sarahahmed21124 жыл бұрын
Very helpful, clear and detailed! Thanks a lot.
@DataAcademyIN
4 жыл бұрын
Thank you Sarah ! Please do subscribe for more such videos. Cheers !
@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
@DataAcademyIN
5 жыл бұрын
Words can't describe how encouraged I feel to hear such comments. Thanks for watching. Do subscribe!
@ChilaKasonde
5 жыл бұрын
@@DataAcademyIN ive subscribed keep up the great work, do you have any material on Relational Algebra?
@DataAcademyIN
5 жыл бұрын
@@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.
@ChilaKasonde
5 жыл бұрын
@@DataAcademyIN thanks will be waiting i think it would be a good video as no one has covered it from what I've seen
@boringgamerboi35382 жыл бұрын
Your teaching is clearer than my lecturer , thanks alot man
@DataAcademyIN
2 жыл бұрын
Glad to hear that
@muhammadfaisalhyder40124 жыл бұрын
This is really great for revision purposes 😅 short and to the point. 👍
@DataAcademyIN
4 жыл бұрын
Hello Muhammad. Glad you think so! :) Please do Like, Share & Subscribe !
@abdullahalkafi55843 жыл бұрын
Awesome 10 minutes 👍
@itishreenayak5984 Жыл бұрын
such a clear description, thanks
@DataAcademyIN
Жыл бұрын
Thank you Itishree for your comments. Please do subscribe!
@seanjharrs4 жыл бұрын
Great Presentation , covers all the important points, many thanks
@DataAcademyIN
4 жыл бұрын
Thanks for your comment Sean. Appreciate it. Please do subscribe in case you haven't. Cheers!
@utkucansa2 жыл бұрын
you explained it in a great and plain way. Thanks.
@DataAcademyIN
2 жыл бұрын
You're very welcome!
@asadalisoomro89373 жыл бұрын
very helpul and conceptual video. Thanks a lot buddy.
@DataAcademyIN
3 жыл бұрын
Thank you Asad !
@Runtothemusic4 жыл бұрын
Excellent explanation, very easy to understand. Thank You.
@DataAcademyIN
4 жыл бұрын
Thank you for your comments. Do subscribe to get notified of new uploads.
@mirjanasarcevic7995 жыл бұрын
Thank you for this great explanation!
@DataAcademyIN
5 жыл бұрын
Thank you Mimi. Do stay subscribed!
@larisamuntyan556 Жыл бұрын
excellent video! thank you very much!
@DataAcademyIN
Жыл бұрын
Thank you for your comments. Please do subscribe!
@arunmehta82343 жыл бұрын
Awesome video. Very Explanatory.
@DataAcademyIN
3 жыл бұрын
Thank you Arun. Please do subscribe !
@xudong52692 жыл бұрын
you killed the game, my friend!
@sravanthiakula1923 Жыл бұрын
Very well explained and all the details are clearly described. Subscribed😊
@DataAcademyIN
Жыл бұрын
Thank you Sravanthi :)
@charujain71653 жыл бұрын
Very well explained. Thanks !!
@DataAcademyIN
3 жыл бұрын
Thank you Charu ! Please do subscribe.
@VirendraBG6 жыл бұрын
Sir, Please make a video to describe about database. Where student don't want to learn any of database technologies like My SQL, Oracle, MongoDB, Hadoop, Google's or Amazon's Cloud Databases and so on. Please make a video where students want to learn in detail about. 1. Concepts. 2. Terminologies. 3. Types of databases (Relational, Non Relational, SQL, NoSQL etc.). 4. Data types supported by various database technologies. 5. Compatibility of different database technologies with different mainstream programming languages (Like Python, Java, PHP etc.) for developing backend of web applications. 6. Working of different types of database technologies. 7. How to calculate resources required. 8. How to calculate costs for different types of database technologies for the given requirement.
@DataAcademyIN
6 жыл бұрын
Hi Virendra, That seems like a huge ask :) I doubt if I can fit in all of these advanced topics into my videos. I plan my videos on abstract & high-level concepts. But I will keep these on my to-do. I will see what I can do.
@radhikasrinivasa30683 жыл бұрын
Thanks a lot!! I'm not from science background, but still could understand clearly!!
@DataAcademyIN
3 жыл бұрын
Thank you Radhika. Happy to hear that comment :) I am glad it helped. Please do subscribe !
@balasubramanianilangovan8882 жыл бұрын
I appreciate your efforts to prepare such a wonderful video!
@DataAcademyIN
2 жыл бұрын
Thank you for your encouraging comments.
@lavanyagopal.manditheater4 жыл бұрын
very simply explained and easy to understand. Thanks !!
@DataAcademyIN
4 жыл бұрын
Many thanks Lavanya. I am glad you found it easy to understand. Please do subscribe to get notified of new uploads. Cheers !
@hamsal_khaldi78512 жыл бұрын
This 13 min video explains one hour lecture. Thank you
@DataAcademyIN
2 жыл бұрын
:) Thank you for your sincere comments !
@try0103 жыл бұрын
Many thanks man This helped me !
@DataAcademyIN
3 жыл бұрын
Thank you Mostafa !
@suniait501893 жыл бұрын
Very nicely explained . Superbbb :)
@DataAcademyIN
3 жыл бұрын
Thank you Sunita :)
@abuhamza1970 Жыл бұрын
Absolutely brilliant video. Thank you sir! 🙏
@DataAcademyIN
Жыл бұрын
Thank you for your comments :) Please do Like, Share & Subscribe
@marycross55262 жыл бұрын
Thank you so much. This was very helpful.
@DataAcademyIN
2 жыл бұрын
Glad it was helpful!
@juvettemunji79843 жыл бұрын
this is the best explanation ever. You solve my problem
@DataAcademyIN
3 жыл бұрын
Thank you Juvette. Please do subscribe!
@Phoinx6 жыл бұрын
It helped me a lot! Thanks!
@DataAcademyIN
6 жыл бұрын
I am glad you found it useful. Thanks Ricardo!
@nitagawade33304 жыл бұрын
Big Thank you sir for such a wonderful explantion......waiting for more video wid business cases
@DataAcademyIN
4 жыл бұрын
Thank you Nita for your kind words :) Stay subscribed to get notified of new videos when I do upload. Pretty soon.
@ongeek98343 жыл бұрын
Very helpful and informative, Please keep educating people. God Bless.
@DataAcademyIN
3 жыл бұрын
Thank you for encouragement KoloHe. Appreciate it. Please do subscribe !
@wilmerpiedrahita80323 жыл бұрын
Very good presentation and tips. Thanks for sharing this, it is very helpful indeed.
@DataAcademyIN
3 жыл бұрын
Many thanks Wilmer. Please do subscribe !
@avinashsaini47965 жыл бұрын
Very helpful and appreciated !!!
@DataAcademyIN
5 жыл бұрын
Thanks. Do stay subscribed !
@ankushpatil1114 Жыл бұрын
This was very detailed yet very simple explanation. Thanks a lot Sir.
@DataAcademyIN
Жыл бұрын
Thank you Ankush for your comments :) Please do subscribe !
@rasthana4 жыл бұрын
Very useful video. Thanks for your efforts in sharing this knowledge.
@DataAcademyIN
4 жыл бұрын
Thanks for your comments Ravi :) Please do subscribe for supporting more such content !
@Juan-Hdez Жыл бұрын
Very useful. Thank you!
@DataAcademyIN
Жыл бұрын
Thank you for your comment. I am glad you found it useful. Please do subscribe!
@KJOB3 жыл бұрын
You saved me a lot of time man, thanks
@DataAcademyIN
3 жыл бұрын
Glad to hear that. Thanks!
@parshubhai93512 жыл бұрын
Very nice explained 😌😌 thanks for this buddy.
@DataAcademyIN
2 жыл бұрын
Thank you 🙏 please do subscribe
@vildanates52766 жыл бұрын
Great explanation, thank you very much.
@DataAcademyIN
6 жыл бұрын
Thanks for the encouragement Vildan ateş
@osofhia5 жыл бұрын
Without doubt, the best tutorial, even with my experience that was refreshing!
@DataAcademyIN
4 жыл бұрын
Thank You ! Please do subscribe.
@srinivasaraoullipalepu73895 жыл бұрын
Thank you the explanation is good enough and clear.
@DataAcademyIN
5 жыл бұрын
Thanks for your comments Mr. Srinivasa :) Stay subscribed to get notified of more useful videos in the future.
@sudharshanchakrapani71113 жыл бұрын
Wonderfull explanation Sir. Thank you very much for making the video.
@DataAcademyIN
3 жыл бұрын
Thank you for your comments Sudarshan !
@omurnebierarslan81732 жыл бұрын
Very clear explanation of the topic...really appreciate it.
@DataAcademyIN
2 жыл бұрын
Thank you Ömür for your comment. I am glad you found it useful. Please do subscribe!
@Simnom2475 ай бұрын
Insightful ❤
@rhyme6300 Жыл бұрын
Very clear, thank you
@DataAcademyIN
Жыл бұрын
I am happy you found it helpful. Thank you for your comments. Please do subscribe !
@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 😎
@lizziewillis9931 Жыл бұрын
Thank you for this!
@DataAcademyIN
Жыл бұрын
Thank you for your comment. I am glad you found it useful. Please do subscribe!
@ahmadkhudai3 жыл бұрын
Good video. Thanks :)
@vijayotnm4 жыл бұрын
Excellent, thank you
@DataAcademyIN
3 жыл бұрын
Glad you enjoyed it Vijayan. Please do Subscribe !
@ruthmk3 ай бұрын
Thanks very insightful
@DataAcademyIN
3 ай бұрын
I am glad you found it useful. Please do subscribe to support my work🙏
@saumyojitdas42125 жыл бұрын
Cleared my doubt. Excellent video.
@DataAcademyIN
5 жыл бұрын
Thank you Saumyojit. I am glad you found it useful. Please do subscribe to get notified when I upload related useful videos.
@estebanlopez17014 жыл бұрын
This is just brilliant, keep it up
@DataAcademyIN
4 жыл бұрын
Thank You :)
@gokuls30006 жыл бұрын
nice video very clear... thanks
@DataAcademyIN
6 жыл бұрын
Thank You Gokul !
@digigoliath4 жыл бұрын
Clear & Concise. Great job & TQ!!
@DataAcademyIN
4 жыл бұрын
Thank you. Please do subscribe for more such videos.
@digigoliath
4 жыл бұрын
@@DataAcademyIN You already have a new subscriber & I will be back for more!
@rolandhortea3 жыл бұрын
Thanks! Very helpful for a beginner :D
@DataAcademyIN
3 жыл бұрын
Thanks Roland !
@Shades.of.life.by.Vandana5 жыл бұрын
very good and very well explained in clear english
@DataAcademyIN
5 жыл бұрын
Thanks Mohit. Please do subscribe to get notified of new videos.
Пікірлер: 399
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!
The best explanation to someone that is just starting off in DBMS. Great job on explaining this in detail!
@DataAcademyIN
5 жыл бұрын
Thanks George! Your comments are very encouraging :)
@anon12416
Жыл бұрын
I agree, thank you so much!!!
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. 👍
@DataAcademyIN
5 жыл бұрын
Many thanks for the encouraging comments Amit! Please do subscribe to get notified of new videos.
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.
@DataAcademyIN
3 жыл бұрын
Thank you for your encouraging comments Jordan. I am glad you found it useful. Do subscribe to the channel.
this is the best DATA MODELLING TUTORIAL i have ever watched. What an explanation good job sir.
@DataAcademyIN
3 жыл бұрын
Thank you Raviteja for your encouraging comments ! Please do subscribe.
One hundred percent more thorough and engaging than a textbook. Thank you my friend!
@DataAcademyIN
4 жыл бұрын
Thank you Lo Green. Please do subscribe !
best video available on youtube for understanding Data modeling.
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😌
@DataAcademyIN
2 жыл бұрын
Thank you for your comments Daksh! Happy Learning :)
Really good one for beginners to understand easily
@DataAcademyIN
Жыл бұрын
Thank you for your comments Karuna. Please do Like, Share & Subscribe !
Wow, great video. I tried to read about data models and was 100% lost. Now I 100% understand after watching this video.
@DataAcademyIN
4 жыл бұрын
Happy to hear that Nicholas :) . Please do subscribe to get notified of new videos. Cheers !
Very helpful. Clearly defined each and every models !!!
@DataAcademyIN
6 жыл бұрын
Thank You Nikunj !
Thank you for such a clear and accurate explanation of the different database modeling stages
@DataAcademyIN
4 жыл бұрын
Many thanks Julio. Please stay subscribed to support !
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.
@DataAcademyIN
3 жыл бұрын
Glad it helped! Please do subscribe !
You did a good job here. Your diction and pacing were perfect. The diagrams were simple and complete. Thanks.
@DataAcademyIN
5 жыл бұрын
Thank you John for the encouragement. Please do browse my channel for other videos. Do subscribe to get notified of new uploads. Thanks !
Great quick intro to the different levels. Thank you!
@DataAcademyIN
4 жыл бұрын
Thank you J !
Thank you for such a great explanation with visual examples. This helped me greatly.
@DataAcademyIN
4 жыл бұрын
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 --> kzread.info/dash/bejne/lY1rubySmNypY9I.html Please do subscribe in case you haven't. Thanks !
This is actually really good explanation.
@DataAcademyIN
6 жыл бұрын
Thanks Gunjan !
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..
@DataAcademyIN
2 жыл бұрын
Thank you for your feedback Jaya. Please do subscribe !
Big Thank you Sir for such wonderful explaination!!! Waiting for more video with some business cases
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
@DataAcademyIN
4 ай бұрын
Thank you for your encouraging comments :) Please do Like, Share & Subscribe
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.
@DataAcademyIN
3 жыл бұрын
That is very well said Pratyush. I am glad you realize the importance of a Data Model well executed. Please do subscribe !
@pratyushraizada1472
3 жыл бұрын
@@DataAcademyIN Done already, keep spreading the knowledge :D
Great and simple explanation sir. It saves lot of time from reading theory sometimes
Thank you, this is a consize and easy to process introduction!
@DataAcademyIN
3 жыл бұрын
Thank you for your nice comments Nathan. Please do subscribe !
Thanks a lot going for an interview tomorrow this explanation saves me lot time in understanding 😆👍🏻
@DataAcademyIN
4 жыл бұрын
Thank you Raghavendra ! I am happy you found it useful. Do subscribe !
Just a great video for beginner who want to understand the data model. Thanks for such short but very useful concepts
@DataAcademyIN
4 жыл бұрын
Many thanks for your comments Lal Bihari Prajapati. Please do like, share & Subscribe.
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.
Hands down the best Video out there.
@DataAcademyIN
5 жыл бұрын
Much thanks SaiKiran :)
Very simple video, but extremely clear: it helped a lot before digging into more detailed tutorials. Great work indeed.
@DataAcademyIN
4 жыл бұрын
Thank you Fabrice ! Please stay subscribed to support !
@fabricejaouen4252
4 жыл бұрын
@@DataAcademyIN : Of course !
Thank you so much for such a wonderful explanation…. Brief and crisp!
@DataAcademyIN
Жыл бұрын
Thank you for your encouraging comments Jyothy. Please do subscribe !
Just what I was looking for. Excellent tutorial!
@DataAcademyIN
5 жыл бұрын
Thanks Aqib !
This explanation is the best. so easy to comprehend...kudos
@DataAcademyIN
Жыл бұрын
Glad it was helpful! Please do Like, Share & Subscribe
Excellent explanation. Short, sweet, and to the point while covering all the essentials to data modeling. Thx you😉
@DataAcademyIN
4 жыл бұрын
Many thanks for your honest comments. Please do subscribe !
Best explanation I’ve ever seen for DBMS
@DataAcademyIN
4 жыл бұрын
Hello Kadi. Thank for your comments. Please do subscribe to support the effort. Do browse my channel for more such videos. Cheers !
Hello Subscribers! A lot of you had complained about the poor audio quality in this clip. So I am re-uploading this video with enhance audio. Watch it here - kzread.info/dash/bejne/lY1rubySmNypY9I.html
@Niko-zl5hn
3 жыл бұрын
how are data models different from data schema or are they the same thing
@DataAcademyIN
3 жыл бұрын
Hello Nico. I understand the confusion. Data Model and Data Schema sound very similar, or they are seem interchangeable. For the sake of clarity, I would explain "Data Model as a pictorial representation of the different Database tables and their relationship". This pictorial representation may not contain some advanced database objects such as Stored Procedures, Indexes, functions, triggers etc. Whereas "Data Schema is the actual collection of database objects that includes tables, views, stored procedures, indexes etc. A schema is usually represented by a bunch of .SQL files that contain the script." To summarize, Data Model is mostly a pictorial representation, whereas Data Schema or Schema is the actual script used to implement the physical database. Be aware that some people/organizations tend to mix these above definitions.
@Niko-zl5hn
3 жыл бұрын
@@DataAcademyIN thank you
thanks because it brings clear description from start to end.
@DataAcademyIN
4 жыл бұрын
Thank you Muhwezi. Please do subscribe !
Nice explanation. Thank you, sir😊
Simply the BEST. Thank you!
@DataAcademyIN
8 ай бұрын
Thank you Evelyn. Please do Like, Share & Subscribe!
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...
@MrAndrewjdavis
2 жыл бұрын
"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"
@jacekkangaroo4402
2 жыл бұрын
@@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
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.
@DataAcademyIN
2 жыл бұрын
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.
Thanks finally an English titled video who is actually explained in English.. :) Very well
@DataAcademyIN
5 жыл бұрын
Thank you Mr. Tarik. Encouraging words like yours are worth the effort. Feel free to browse my channel, and do subscribe :)
Best explanation for these 3 models
Simple and clear. Thank you!
@DataAcademyIN
6 жыл бұрын
Than You Ilona !
Well understood. Thanks for the lecture
thnx vry much u explained it all well
@DataAcademyIN
6 жыл бұрын
Thank you Ezra !
You did a great job, your explanation is too good thank you!!
@DataAcademyIN
3 жыл бұрын
Thank you Mouni. Glad you found it helpful. Please do subscribe if you haven't already :)
Very helpful, clear and detailed! Thanks a lot.
@DataAcademyIN
4 жыл бұрын
Thank you Sarah ! Please do subscribe for more such videos. Cheers !
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
@DataAcademyIN
5 жыл бұрын
Words can't describe how encouraged I feel to hear such comments. Thanks for watching. Do subscribe!
@ChilaKasonde
5 жыл бұрын
@@DataAcademyIN ive subscribed keep up the great work, do you have any material on Relational Algebra?
@DataAcademyIN
5 жыл бұрын
@@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.
@ChilaKasonde
5 жыл бұрын
@@DataAcademyIN thanks will be waiting i think it would be a good video as no one has covered it from what I've seen
Your teaching is clearer than my lecturer , thanks alot man
@DataAcademyIN
2 жыл бұрын
Glad to hear that
This is really great for revision purposes 😅 short and to the point. 👍
@DataAcademyIN
4 жыл бұрын
Hello Muhammad. Glad you think so! :) Please do Like, Share & Subscribe !
Awesome 10 minutes 👍
such a clear description, thanks
@DataAcademyIN
Жыл бұрын
Thank you Itishree for your comments. Please do subscribe!
Great Presentation , covers all the important points, many thanks
@DataAcademyIN
4 жыл бұрын
Thanks for your comment Sean. Appreciate it. Please do subscribe in case you haven't. Cheers!
you explained it in a great and plain way. Thanks.
@DataAcademyIN
2 жыл бұрын
You're very welcome!
very helpul and conceptual video. Thanks a lot buddy.
@DataAcademyIN
3 жыл бұрын
Thank you Asad !
Excellent explanation, very easy to understand. Thank You.
@DataAcademyIN
4 жыл бұрын
Thank you for your comments. Do subscribe to get notified of new uploads.
Thank you for this great explanation!
@DataAcademyIN
5 жыл бұрын
Thank you Mimi. Do stay subscribed!
excellent video! thank you very much!
@DataAcademyIN
Жыл бұрын
Thank you for your comments. Please do subscribe!
Awesome video. Very Explanatory.
@DataAcademyIN
3 жыл бұрын
Thank you Arun. Please do subscribe !
you killed the game, my friend!
Very well explained and all the details are clearly described. Subscribed😊
@DataAcademyIN
Жыл бұрын
Thank you Sravanthi :)
Very well explained. Thanks !!
@DataAcademyIN
3 жыл бұрын
Thank you Charu ! Please do subscribe.
Sir, Please make a video to describe about database. Where student don't want to learn any of database technologies like My SQL, Oracle, MongoDB, Hadoop, Google's or Amazon's Cloud Databases and so on. Please make a video where students want to learn in detail about. 1. Concepts. 2. Terminologies. 3. Types of databases (Relational, Non Relational, SQL, NoSQL etc.). 4. Data types supported by various database technologies. 5. Compatibility of different database technologies with different mainstream programming languages (Like Python, Java, PHP etc.) for developing backend of web applications. 6. Working of different types of database technologies. 7. How to calculate resources required. 8. How to calculate costs for different types of database technologies for the given requirement.
@DataAcademyIN
6 жыл бұрын
Hi Virendra, That seems like a huge ask :) I doubt if I can fit in all of these advanced topics into my videos. I plan my videos on abstract & high-level concepts. But I will keep these on my to-do. I will see what I can do.
Thanks a lot!! I'm not from science background, but still could understand clearly!!
@DataAcademyIN
3 жыл бұрын
Thank you Radhika. Happy to hear that comment :) I am glad it helped. Please do subscribe !
I appreciate your efforts to prepare such a wonderful video!
@DataAcademyIN
2 жыл бұрын
Thank you for your encouraging comments.
very simply explained and easy to understand. Thanks !!
@DataAcademyIN
4 жыл бұрын
Many thanks Lavanya. I am glad you found it easy to understand. Please do subscribe to get notified of new uploads. Cheers !
This 13 min video explains one hour lecture. Thank you
@DataAcademyIN
2 жыл бұрын
:) Thank you for your sincere comments !
Many thanks man This helped me !
@DataAcademyIN
3 жыл бұрын
Thank you Mostafa !
Very nicely explained . Superbbb :)
@DataAcademyIN
3 жыл бұрын
Thank you Sunita :)
Absolutely brilliant video. Thank you sir! 🙏
@DataAcademyIN
Жыл бұрын
Thank you for your comments :) Please do Like, Share & Subscribe
Thank you so much. This was very helpful.
@DataAcademyIN
2 жыл бұрын
Glad it was helpful!
this is the best explanation ever. You solve my problem
@DataAcademyIN
3 жыл бұрын
Thank you Juvette. Please do subscribe!
It helped me a lot! Thanks!
@DataAcademyIN
6 жыл бұрын
I am glad you found it useful. Thanks Ricardo!
Big Thank you sir for such a wonderful explantion......waiting for more video wid business cases
@DataAcademyIN
4 жыл бұрын
Thank you Nita for your kind words :) Stay subscribed to get notified of new videos when I do upload. Pretty soon.
Very helpful and informative, Please keep educating people. God Bless.
@DataAcademyIN
3 жыл бұрын
Thank you for encouragement KoloHe. Appreciate it. Please do subscribe !
Very good presentation and tips. Thanks for sharing this, it is very helpful indeed.
@DataAcademyIN
3 жыл бұрын
Many thanks Wilmer. Please do subscribe !
Very helpful and appreciated !!!
@DataAcademyIN
5 жыл бұрын
Thanks. Do stay subscribed !
This was very detailed yet very simple explanation. Thanks a lot Sir.
@DataAcademyIN
Жыл бұрын
Thank you Ankush for your comments :) Please do subscribe !
Very useful video. Thanks for your efforts in sharing this knowledge.
@DataAcademyIN
4 жыл бұрын
Thanks for your comments Ravi :) Please do subscribe for supporting more such content !
Very useful. Thank you!
@DataAcademyIN
Жыл бұрын
Thank you for your comment. I am glad you found it useful. Please do subscribe!
You saved me a lot of time man, thanks
@DataAcademyIN
3 жыл бұрын
Glad to hear that. Thanks!
Very nice explained 😌😌 thanks for this buddy.
@DataAcademyIN
2 жыл бұрын
Thank you 🙏 please do subscribe
Great explanation, thank you very much.
@DataAcademyIN
6 жыл бұрын
Thanks for the encouragement Vildan ateş
Without doubt, the best tutorial, even with my experience that was refreshing!
@DataAcademyIN
4 жыл бұрын
Thank You ! Please do subscribe.
Thank you the explanation is good enough and clear.
@DataAcademyIN
5 жыл бұрын
Thanks for your comments Mr. Srinivasa :) Stay subscribed to get notified of more useful videos in the future.
Wonderfull explanation Sir. Thank you very much for making the video.
@DataAcademyIN
3 жыл бұрын
Thank you for your comments Sudarshan !
Very clear explanation of the topic...really appreciate it.
@DataAcademyIN
2 жыл бұрын
Thank you Ömür for your comment. I am glad you found it useful. Please do subscribe!
Insightful ❤
Very clear, thank you
@DataAcademyIN
Жыл бұрын
I am happy you found it helpful. Thank you for your comments. Please do subscribe !
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 😎
Thank you for this!
@DataAcademyIN
Жыл бұрын
Thank you for your comment. I am glad you found it useful. Please do subscribe!
Good video. Thanks :)
Excellent, thank you
@DataAcademyIN
3 жыл бұрын
Glad you enjoyed it Vijayan. Please do Subscribe !
Thanks very insightful
@DataAcademyIN
3 ай бұрын
I am glad you found it useful. Please do subscribe to support my work🙏
Cleared my doubt. Excellent video.
@DataAcademyIN
5 жыл бұрын
Thank you Saumyojit. I am glad you found it useful. Please do subscribe to get notified when I upload related useful videos.
This is just brilliant, keep it up
@DataAcademyIN
4 жыл бұрын
Thank You :)
nice video very clear... thanks
@DataAcademyIN
6 жыл бұрын
Thank You Gokul !
Clear & Concise. Great job & TQ!!
@DataAcademyIN
4 жыл бұрын
Thank you. Please do subscribe for more such videos.
@digigoliath
4 жыл бұрын
@@DataAcademyIN You already have a new subscriber & I will be back for more!
Thanks! Very helpful for a beginner :D
@DataAcademyIN
3 жыл бұрын
Thanks Roland !
very good and very well explained in clear english
@DataAcademyIN
5 жыл бұрын
Thanks Mohit. Please do subscribe to get notified of new videos.
Thank You and god bless you
@DataAcademyIN
6 жыл бұрын
Thank you for watching ! Stay tuned :)