How to Design Your First Database

Поделиться
HTML-код
  • Опубликовано: 22 ноя 2024

Комментарии • 56

  • @joshuaerkman1444
    @joshuaerkman1444 5 лет назад +108

    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 года назад +28

    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 года назад +3

    I love that the RUclips 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!

  • @tanvirhasanmonir1627
    @tanvirhasanmonir1627 3 года назад +2

    Wonderful, comprehensive lessons. Thanks

  • @noellep5447
    @noellep5447 3 года назад +2

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

  • @ishatawade
    @ishatawade 2 года назад +1

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

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

  • @bogorehmohamed9621
    @bogorehmohamed9621 Год назад

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

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

  • @invi_ctor
    @invi_ctor 2 месяца назад

    Ótimo conteúdo!

  • @surkewrasoul4711
    @surkewrasoul4711 2 года назад

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

  • @chrisder1814
    @chrisder1814 2 месяца назад

    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

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

  • @clearthinking5441
    @clearthinking5441 3 года назад +1

    This is a gem of a video,

  • @testingcoder
    @testingcoder 2 года назад

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

  • @ThubaMamba
    @ThubaMamba 3 года назад +1

    Great video, straight to the point. Thanks.

  • @shadyritaB
    @shadyritaB 2 года назад +1

    This video is really great!

  • @brianmusyoki521
    @brianmusyoki521 2 года назад

    Very good explanation

  • @Trader-SwingTheory
    @Trader-SwingTheory 2 года назад

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

  • @MagnusAnand
    @MagnusAnand 4 года назад +1

    A very useful and clear video

    • @cbtnuggets
      @cbtnuggets  4 года назад

      Glad you liked it, thank you!

  • @FundiCrypto
    @FundiCrypto Год назад

    Thanks so much

  • @AronW4
    @AronW4 3 года назад

    Fantastic video for me to recap!

  • @Ins_8800
    @Ins_8800 3 года назад

    Thanks a ton, keep making such videos

  • @cricketbrush9595
    @cricketbrush9595 5 лет назад +1

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

  • @zaccomusic
    @zaccomusic 4 года назад +1

    amazing video
    hope you keep update :)

  • @ojobasi1559
    @ojobasi1559 9 месяцев назад

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

  • @quorawilliams1850
    @quorawilliams1850 2 года назад

    i actually knew this already so yeah

  • @darrent2478
    @darrent2478 3 года назад

    Love It!

  • @fandewillyrex2111
    @fandewillyrex2111 4 года назад +1

    A video very cool

  • @cricketbrush9595
    @cricketbrush9595 5 лет назад +1

    I will be waiting ...

  • @ericjamesureta4125
    @ericjamesureta4125 3 года назад

    🥳👏bravo👏👏

  • @Arnonis
    @Arnonis 4 года назад

    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 4 года назад

      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.

  • @Azakadune
    @Azakadune 3 года назад

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

  • @Certamaniac
    @Certamaniac 3 года назад

    This guy sounds exactly like Louis C.K.

  • @froilanemeliano6551
    @froilanemeliano6551 Год назад

    4:00

  • @hassandon3651
    @hassandon3651 3 года назад

    Awesoo

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