How to Design Your First Database

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ม.ค. 2025

ความคิดเห็น • 57

  • @joshuaerkman1444
    @joshuaerkman1444 5 ปีที่แล้ว +110

    I've just completed a full 10 week database course and your thought experiment about the doctor's office is more useful and profound than anything else I've heard in my entire course. Thank you.

  • @robertdavitt
    @robertdavitt 3 ปีที่แล้ว +30

    This is ridiculously helpful. I have learned the basics of building a database in literaly 6 minutes. We need a super-like for vids like this.

    • @cbtnuggets
      @cbtnuggets  3 ปีที่แล้ว +1

      Glad you found it helpful! Thank you for learning with us, Robert.

  • @mannycalavera121
    @mannycalavera121 2 ปีที่แล้ว +4

    I love that the TH-cam audience is so large that there's wonderful human being such as yourself putting out volumes of very niche and information content. Thanks for taking the time out to make these videos :)

  • @saramaeks9826
    @saramaeks9826 2 ปีที่แล้ว +4

    thank you, this was so helpful. I watched it on repeat like 10 times. crazy how you packed so much understanding into such a small amount of time!

  • @emmanuelugwuoke967
    @emmanuelugwuoke967 ปีที่แล้ว

    This short vid is packed with a lot of information. Thank you.

  • @mushinart
    @mushinart 3 ปีที่แล้ว +2

    this is AMAZING .... as a professional teacher myself I must say that YOU ARE AMAZING

  • @sebastianp.2547
    @sebastianp.2547 4 ปีที่แล้ว +11

    Thanks. Great video with nice analogies. Great to refresh some basic concepts and to see what you might have already known (or intuitively known) from a fresh point of view - since every person has their own way of understanding the same concept.

  • @jesusloaiza3032
    @jesusloaiza3032 3 ปีที่แล้ว +9

    Dude, you are an awesome teacher!!

    • @cbtnuggets
      @cbtnuggets  3 ปีที่แล้ว +1

      Yeah, Garth is pretty great. Glad you enjoyed the video!

  • @Artistram3d1
    @Artistram3d1 3 ปีที่แล้ว +2

    Hello, I do graphics production in a large company that produces tradeshow booths and graphics. On a daily basis, we have to use different types of material and remember all these different substrate sizes. I'm taking it upon myself to try to come up with a database so that if someone has a question about a substrate, size, technique, etc., I can access it and let them know. From looking at this video, it does seem possible. I will have to continue to watch your videos for more into. Thank you for sharing! Instant sub!

  • @kameronkang286
    @kameronkang286 ปีที่แล้ว

    Great video and the doctor office comment made me laugh out loud . I was on a treadmill at the gym when I was watching so I did it in the gym lol

  • @noellep5447
    @noellep5447 3 ปีที่แล้ว +2

    This is extraordinarily clear and helpful. Thank you so much!

  • @WiredDrummer
    @WiredDrummer 4 ปีที่แล้ว +6

    Isn't the OrderID in OrderDetails also a FK? It references the PK of Orders table

    • @Tetracarbon
      @Tetracarbon 4 ปีที่แล้ว

      No. It’s a double primary key. That is, the concatenation of the orderId and ProductID are both 1) every present (not blank) and 2) unique.

    • @FasterN8
      @FasterN8 3 ปีที่แล้ว +4

      I agree. If ProductID is a FK in the Order Details, table, then OrderID is also a FK for the exact same reasons. The concatenation of those two may still be the PK of that table, but he doesn't do a great job of clearing that up since he calls them both a PK at 3:12 and then calls just one of them a FK at 3:45.

  • @tanvirhasanmonir1627
    @tanvirhasanmonir1627 3 ปีที่แล้ว +2

    Wonderful, comprehensive lessons. Thanks

  • @Red-qz4lx
    @Red-qz4lx 4 ปีที่แล้ว +3

    This guy is so excited about dbs that is contagious, i should stop before i enlist in some database course but i can't

    • @thacoolest13
      @thacoolest13 4 ปีที่แล้ว +3

      its too late.. I've already spent 45 dollars on multiple udemy courses.. help me :D

  • @invi_ctor
    @invi_ctor 4 หลายเดือนก่อน

    Ótimo conteúdo!

  • @shadyritaB
    @shadyritaB 2 ปีที่แล้ว +1

    This video is really great!

  • @clearthinking5441
    @clearthinking5441 3 ปีที่แล้ว +1

    This is a gem of a video,

  • @chrisder1814
    @chrisder1814 4 หลายเดือนก่อน

    hello I would like to do automation with no code tools in my WordPress database, could you help me understand if my ideas are good and feasible

  • @ishatawade
    @ishatawade 3 ปีที่แล้ว +1

    Hi, Good video!. Can you please explain Normalize & Refine in more detail?

  • @ThubaMamba
    @ThubaMamba 3 ปีที่แล้ว +1

    Great video, straight to the point. Thanks.

  • @bogorehmohamed9621
    @bogorehmohamed9621 ปีที่แล้ว

    Hi sir, could you define what is a database design ??

  • @brianmusyoki521
    @brianmusyoki521 3 ปีที่แล้ว

    Very good explanation

  • @FundiCrypto
    @FundiCrypto ปีที่แล้ว

    Thanks so much

  • @MagnusAnand
    @MagnusAnand 4 ปีที่แล้ว +1

    A very useful and clear video

    • @cbtnuggets
      @cbtnuggets  4 ปีที่แล้ว

      Glad you liked it, thank you!

  • @testingcoder
    @testingcoder 2 ปีที่แล้ว

    Awesome video! Could you please tell what software did you use to create this kind of presentation?

  • @Ins_8800
    @Ins_8800 3 ปีที่แล้ว

    Thanks a ton, keep making such videos

  • @AronW4
    @AronW4 3 ปีที่แล้ว

    Fantastic video for me to recap!

  • @zaccomusic
    @zaccomusic 4 ปีที่แล้ว +1

    amazing video
    hope you keep update :)

  • @surkewrasoul4711
    @surkewrasoul4711 2 ปีที่แล้ว

    20 years old magazine, Sounds interesting , Just imagine that you have travelled back in time.

  • @Trader-SwingTheory
    @Trader-SwingTheory 2 ปีที่แล้ว

    Hank from Breaking Bad did a great job with this video
    It sounds so much like him!

  • @darrent2478
    @darrent2478 3 ปีที่แล้ว

    Love It!

  • @cricketbrush9595
    @cricketbrush9595 5 ปีที่แล้ว +1

    Plz upload a video on courses require to become a databse designer

  • @ojobasi1559
    @ojobasi1559 11 หลายเดือนก่อน

    A table is not synonymous to a relation. Not every table is a relation. Relational Theory.

  • @ericjamesureta4125
    @ericjamesureta4125 3 ปีที่แล้ว

    🥳👏bravo👏👏

  • @xxtractz
    @xxtractz หลายเดือนก่อน

    this is still applicable in 2024....

  • @fandewillyrex2111
    @fandewillyrex2111 4 ปีที่แล้ว +1

    A video very cool

  • @quorawilliams1850
    @quorawilliams1850 3 ปีที่แล้ว

    i actually knew this already so yeah

  • @froilanemeliano6551
    @froilanemeliano6551 ปีที่แล้ว

    4:00

  • @Arnonis
    @Arnonis 5 ปีที่แล้ว

    Hi. What is the program used to show the database design visible on the left in the 3rd minute of this video? Does anyone know? Cool vid btw :)

    • @dennisaarts7924
      @dennisaarts7924 5 ปีที่แล้ว

      I don't know the specific tool used in the video. But I always use draw.io. Very simple to use :)

    • @ravitshaltiel179
      @ravitshaltiel179 4 ปีที่แล้ว

      Sql server management studio, that was a ERD diagram that show the relationship between the tables

    • @mikeRnichols
      @mikeRnichols 4 ปีที่แล้ว

      @@ravitshaltiel179 MS Access does the same thing.

  • @cricketbrush9595
    @cricketbrush9595 5 ปีที่แล้ว +1

    I will be waiting ...

  • @Azakadune
    @Azakadune 3 ปีที่แล้ว

    Bro why am I in database design im a mech. engineer.
    ah well...

  • @hassandon3651
    @hassandon3651 3 ปีที่แล้ว

    Awesoo

  • @Certamaniac
    @Certamaniac 3 ปีที่แล้ว

    This guy sounds exactly like Louis C.K.

  • @marble_wraith
    @marble_wraith 5 ปีที่แล้ว +2

    The title needs to be changed, this is only relevant to relational databases. There are plenty of database technologies that are AP.

    • @rachelly7779
      @rachelly7779 4 ปีที่แล้ว +1

      You are right

    • @rachelly7779
      @rachelly7779 4 ปีที่แล้ว +1

      I thought the same thing

    • @passportbro904
      @passportbro904 ปีที่แล้ว +1

      Its 2023 real people only use relationship databases