How to Design a Database

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 96

  • @DatabaseStar
    @DatabaseStar  2 місяці тому

    Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?

  • @nicholassmith6412
    @nicholassmith6412 2 роки тому +48

    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
      @DatabaseStar  2 роки тому +5

      Thanks for the feedback and glad you found this useful!

  • @ayomideashiru554
    @ayomideashiru554 Рік тому +16

    This is one of the best straight-to-the-point videos on designing databases on UA-cam!!! Amazing!!!

    • @DatabaseStar
      @DatabaseStar  Рік тому +1

      Wow, thanks! Glad you liked the video and found it helpful!

  • @yassinebouchoucha
    @yassinebouchoucha 2 роки тому +13

    most under-rated topic for web developer , keep-up the good work.

  • @冉-q2u
    @冉-q2u Рік тому +2

    I like your video. I have been studying databases for some time, and I've come across tutorial project videos on UA-cam. This is one of the best videos on designing databases on UA-cam!!!

  • @antonignatenko7776
    @antonignatenko7776 28 днів тому +2

    that's just exactly what i needed. tons of questions answered. God bless you.

  • @MohammadNasim-p2b
    @MohammadNasim-p2b Рік тому +4

    This amazing brother. No one is talking about these types of fundamental topics. This video is so helpful. Keep up good work.

  • @tech-systemdesign8891
    @tech-systemdesign8891 Рік тому +3

    The best channel to learn db design, thank you so much!

  • @tech-systemdesign8891
    @tech-systemdesign8891 2 роки тому +2

    OMG, finally, your videos are so helpful, I was looking for a while. Thank you so much!!

  • @ravindrawaghela9072
    @ravindrawaghela9072 8 місяців тому +2

    One of the best video . Very lucid to understand. ! Thank you from bottom of my heart. :)

    • @DatabaseStar
      @DatabaseStar  8 місяців тому

      Thanks, I’m glad you liked it!

  • @srourganoush5941
    @srourganoush5941 2 роки тому +2

    You deserve more likes and subscribers

  • @yoseees5493
    @yoseees5493 2 роки тому +3

    This video was incredible! Thank you so much!

  • @czhablog9559
    @czhablog9559 6 місяців тому +1

    Wow what an amazing explanation!!!

  • @piccell244
    @piccell244 Рік тому

    I‘m starting out right now and this video is really helping, thanks a lot

    • @DatabaseStar
      @DatabaseStar  Рік тому

      No problem, glad to hear this video is helpful!

  • @db5094
    @db5094 19 днів тому

    Thanks needed this for an assignment!

  • @riccardolacamera
    @riccardolacamera 8 місяців тому +1

    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!

    • @DatabaseStar
      @DatabaseStar  8 місяців тому

      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.

  • @-.-smile
    @-.-smile 2 роки тому +1

    Ben your videos are amazing!

  • @samfreitag729
    @samfreitag729 2 роки тому

    Wow! Super helpful video man. I wish I started here first....

  • @Spkntei
    @Spkntei 11 місяців тому +1

    Good teacher ❤

  • @porobertdev
    @porobertdev 2 місяці тому

    Extremely helpful!

  • @AnneLopezlovesLife
    @AnneLopezlovesLife 2 роки тому

    This is exactly what i need right now :)

  • @mastermindrational1907
    @mastermindrational1907 9 місяців тому

    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?

    • @DatabaseStar
      @DatabaseStar  9 місяців тому

      Thanks! Yeah breaking it down will be helpful

  • @trishulcurtis1810
    @trishulcurtis1810 10 місяців тому

    Excellent Video!

  • @simondolapo1567
    @simondolapo1567 2 роки тому

    Great video...I absolutely loved it... You're doing a great job...

    • @DatabaseStar
      @DatabaseStar  2 роки тому

      Thank you so much!

    • @simondolapo1567
      @simondolapo1567 2 роки тому

      @@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🙌

  • @hafedgabroun3242
    @hafedgabroun3242 2 роки тому

    Keep up the good work! 👍

  • @luciusrex
    @luciusrex 2 місяці тому +1

    i love this thanks!

  • @appstuff6565
    @appstuff6565 2 роки тому

    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
      @DatabaseStar  2 роки тому +2

      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.

  • @natkhat19jay
    @natkhat19jay 3 місяці тому

    Awesome sir love from india

  • @abdirahmanali3639
    @abdirahmanali3639 Рік тому

    absolutely amazing, !!!!!

  • @SonAyoD
    @SonAyoD 7 місяців тому +1

    Great video

  • @pawegagorowski4410
    @pawegagorowski4410 2 роки тому

    Great video!!

  • @debrain1647
    @debrain1647 9 місяців тому

    Hello, nice tutorial.. what software is this? Would like to learn from you.

    • @DatabaseStar
      @DatabaseStar  9 місяців тому

      Thanks! The tool I used is called LucidChart.

  • @yahayahudu1745
    @yahayahudu1745 2 роки тому

    You are really amazing, thanks 😊

  • @naveenkumarmurugan1962
    @naveenkumarmurugan1962 2 роки тому

    Your videos are awesome

  • @tejassharma2006
    @tejassharma2006 7 місяців тому

    Thanks man.

  • @smilingcookie1672
    @smilingcookie1672 Рік тому

    Great video

  • @rimshawaqar8073
    @rimshawaqar8073 2 роки тому

    have you lectures on oracle apex complete series?

    • @DatabaseStar
      @DatabaseStar  2 роки тому

      Unfortunately I don’t, as I don’t have any experience with apex

    • @rimshawaqar8073
      @rimshawaqar8073 2 роки тому

      If you know someone good at apex, can you recommend (channel, lectures)

  • @GenjaOrigins
    @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
      @DatabaseStar  Рік тому +1

      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.

    • @GenjaOrigins
      @GenjaOrigins 6 місяців тому

      @@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.

  • @abdelrahmanmohamedowis7619
    @abdelrahmanmohamedowis7619 6 місяців тому +1

    why u don't do generalisation principle

    • @DatabaseStar
      @DatabaseStar  6 місяців тому

      What do you mean by "generalisation principle"?

    • @YangNotPractice
      @YangNotPractice 5 місяців тому

      I think it’s called normalization

  • @joelklovesmukisa
    @joelklovesmukisa Місяць тому

    plz help share available databases if you dont mind

    • @DatabaseStar
      @DatabaseStar  Місяць тому

      What do you mean by available databases?

  • @wesleyong2970
    @wesleyong2970 Рік тому

    What software is this?

  • @ViBucks
    @ViBucks 19 днів тому

    GOAT

  • @lararawf6100
    @lararawf6100 2 місяці тому

    God bless u

  • @hemanthanagoda8955
    @hemanthanagoda8955 Рік тому

    max

  • @coderlady_
    @coderlady_ 2 місяці тому

    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
      @DatabaseStar  2 місяці тому

      What do you mean by recursionStackOverflow problem? I have a few videos on joining tables that may address it.

    • @coderlady_
      @coderlady_ 2 місяці тому

      @@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

    • @DatabaseStar
      @DatabaseStar  Місяць тому

      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)?