Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@nicholassmith6412 Жыл бұрын
Videos like this are way more useful than the other bog standard stuff that litters the web - rather than over-explaining 'how to query a, b, c, d and e', your videos cover the more important fundamentals like how to design relational databases properly. The querying can just be googled as you develop, but leaning how to design a database cannot be googled so easily. Thank you
@DatabaseStar Жыл бұрын
Thanks for the feedback and glad you found this useful!
@ayomideashiru554 Жыл бұрын
This is one of the best straight-to-the-point videos on designing databases on KZbin!!! Amazing!!!
@DatabaseStar Жыл бұрын
Wow, thanks! Glad you liked the video and found it helpful!
@冉-q2u11 ай бұрын
I like your video. I have been studying databases for some time, and I've come across tutorial project videos on KZbin. This is one of the best videos on designing databases on KZbin!!!
@DatabaseStar11 ай бұрын
Glad it was helpful!
@yassinebouchoucha2 жыл бұрын
most under-rated topic for web developer , keep-up the good work.
@DatabaseStar2 жыл бұрын
Thanks!
@MohammadNasim-p2b Жыл бұрын
This amazing brother. No one is talking about these types of fundamental topics. This video is so helpful. Keep up good work.
@DatabaseStar Жыл бұрын
Thanks, glad you like it!
@riccardolacamera7 ай бұрын
your video was absolutely helpful compared to class lectures about database management, do you have anything on how to design (even with pen and paper) other kind of relationship between tables? Thanks a lot!
@DatabaseStar7 ай бұрын
Thanks! I've got a couple of videos on my channel about many to many relationships, and one to many relationships. I've also got quite a few examples of designing a database, such as AirBNB or Instagram or school management.
@tech-systemdesign8891 Жыл бұрын
The best channel to learn db design, thank you so much!
@DatabaseStar Жыл бұрын
Thanks!
@tech-systemdesign8891 Жыл бұрын
OMG, finally, your videos are so helpful, I was looking for a while. Thank you so much!!
@DatabaseStar Жыл бұрын
Glad you like them!
@ravindrawaghela90727 ай бұрын
One of the best video . Very lucid to understand. ! Thank you from bottom of my heart. :)
@DatabaseStar7 ай бұрын
Thanks, I’m glad you liked it!
@mastermindrational19078 ай бұрын
This was helpful, although I have a massive database I’m planning. Maybe I will need to break it down into small chunks as I go?
@DatabaseStar8 ай бұрын
Thanks! Yeah breaking it down will be helpful
@piccell244 Жыл бұрын
I‘m starting out right now and this video is really helping, thanks a lot
@DatabaseStar Жыл бұрын
No problem, glad to hear this video is helpful!
@czhablog95595 ай бұрын
Wow what an amazing explanation!!!
@DatabaseStar5 ай бұрын
Glad it was helpful!
@natkhat19jayАй бұрын
Awesome sir love from india
@DatabaseStarАй бұрын
Thanks!
@srourganoush59412 жыл бұрын
You deserve more likes and subscribers
@DatabaseStar2 жыл бұрын
Thanks!
@samfreitag7292 жыл бұрын
Wow! Super helpful video man. I wish I started here first....
@DatabaseStar2 жыл бұрын
Glad it was helpful!
@yoseees54932 жыл бұрын
This video was incredible! Thank you so much!
@DatabaseStar2 жыл бұрын
You're so welcome!
@Spkntei10 ай бұрын
Good teacher ❤
@DatabaseStar10 ай бұрын
Thanks!
@porobertdevАй бұрын
Extremely helpful!
@DatabaseStarАй бұрын
Glad to hear it!
@appstuff6565 Жыл бұрын
Hi there, thanks for this! I was wondering how we can do with multiple patients at the same time, perhaps create a separate table of patients and how will we identify other patients from that table list?
@DatabaseStar Жыл бұрын
Glad it helped! Yes, you would have a separate table in between patients and appointments to store the patients for each appointment, as it is now a "many to many" relationship.
@debrain16478 ай бұрын
Hello, nice tutorial.. what software is this? Would like to learn from you.
@DatabaseStar8 ай бұрын
Thanks! The tool I used is called LucidChart.
@-.-smile2 жыл бұрын
Ben your videos are amazing!
@DatabaseStar2 жыл бұрын
Thanks!
@luciusrexАй бұрын
i love this thanks!
@DatabaseStarАй бұрын
You’re welcome
@trishulcurtis18109 ай бұрын
Excellent Video!
@DatabaseStar9 ай бұрын
Thank you very much!
@simondolapo15672 жыл бұрын
Great video...I absolutely loved it... You're doing a great job...
@DatabaseStar2 жыл бұрын
Thank you so much!
@simondolapo15672 жыл бұрын
@@DatabaseStar You're welcome...Words can't express how happy I felt when j went through some of your database videos...They were so helpful. Good job sir🙌
@SonAyoD5 ай бұрын
Great video
@DatabaseStar5 ай бұрын
Thanks!
@AnneLopezlovesLife2 жыл бұрын
This is exactly what i need right now :)
@DatabaseStar2 жыл бұрын
Glad it was helpful!
@abdelrahmanmohamedowis76195 ай бұрын
why u don't do generalisation principle
@DatabaseStar5 ай бұрын
What do you mean by "generalisation principle"?
@YangNotPractice4 ай бұрын
I think it’s called normalization
@tejassharma20066 ай бұрын
Thanks man.
@DatabaseStar6 ай бұрын
No problem!
@rimshawaqar80732 жыл бұрын
have you lectures on oracle apex complete series?
@DatabaseStar2 жыл бұрын
Unfortunately I don’t, as I don’t have any experience with apex
@rimshawaqar80732 жыл бұрын
If you know someone good at apex, can you recommend (channel, lectures)
@hafedgabroun32422 жыл бұрын
Keep up the good work! 👍
@DatabaseStar2 жыл бұрын
Thanks!
@naveenkumarmurugan19622 жыл бұрын
Your videos are awesome
@DatabaseStar2 жыл бұрын
Thanks!
@yahayahudu17452 жыл бұрын
You are really amazing, thanks 😊
@DatabaseStar2 жыл бұрын
Thanks!
@abdirahmanali3639 Жыл бұрын
absolutely amazing, !!!!!
@DatabaseStar Жыл бұрын
Thanks!
@smilingcookie1672 Жыл бұрын
Great video
@DatabaseStar Жыл бұрын
Thanks!
@joelklovesmukisa8 күн бұрын
plz help share available databases if you dont mind
@DatabaseStar7 күн бұрын
What do you mean by available databases?
@pawegagorowski44102 жыл бұрын
Great video!!
@DatabaseStar2 жыл бұрын
Thanks!
@lararawf6100Ай бұрын
God bless u
@DatabaseStarАй бұрын
Thanks
@GenjaOrigins Жыл бұрын
I am trying to learn something. Lets say someone gives me some requirements how can i make a DB based on that. Or if have a DB how can i change it if somethng happnes therre must be some rules or theory. Like Pivot tables that connect 2 tables etc
@DatabaseStar Жыл бұрын
This video shows you how to create a database design from an idea or from requirements. I've got a few other examples on how to do this on my channel as well. If you have a database and you need to change something, you would follow the same process. But it may be more complicated as you need to understand what is happening at the moment.
@GenjaOrigins5 ай бұрын
@@DatabaseStar I think i need to Learn about 1-1, 1-N, N-1, N-N and when to use join table "pivot table". I think when 1-1 use foreign keys for everything else pivot table but i don't know how exactly. And i need learn normalization.
@wesleyong2970 Жыл бұрын
What software is this?
@DatabaseStar Жыл бұрын
This software is called LucidChart.
@hemanthanagoda8955 Жыл бұрын
max
@DatabaseStar Жыл бұрын
Glad you like it (I think!)
@coderlady_Ай бұрын
Hi, Can you make a video about the mapping between tables to avoid teh infinit recursionStachOverflow problems? especially @manytoOne and @OnetoMany in each side of the tables
@DatabaseStarАй бұрын
What do you mean by recursionStackOverflow problem? I have a few videos on joining tables that may address it.
@coderlady_Ай бұрын
@@DatabaseStar I mean when 2 entities have bidirectional relationship: manytoone from 1side and onetomany from the other side, when serializing the 2 entities I get the erro: infinit recursionStackoverflow, I found solutions (like jsonmanagedreference and jsonbackreference) I'm wondering if there is a better way of managing the mapping, I've also read that OneToMany is to be avoid, because the entity loads list of the other one, so it leads to performence issues, is that correct? Thank you
@DatabaseStar22 күн бұрын
Thanks for clarifying. I assume you're using Java, but I'm not that familiar with these errors. A one-to-many database design is very common and is actually a good thing to have in a database. For example, one supplier has many products, one customer has many orders, one social media post has many photos. Regarding the "bidirectional relationship", does this mean that you have two tables, and they have two relationships between the tables (instead of one)?