No video

How to Design Your First Database

See this entire course on the Intro to Databases playlist. cbt.gg/2wh3UuW
Attention to detail is key to designing effective databases. CBT Nuggets trainer Garth Schulte explains the two main rules to follow when designing databases, as well as general design principles.
Continue learning database technologies with CBT Nuggets and sign up for a FREE trial: training.cbt.g...
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - / cbtnuggets
• Facebook - / cbtnuggets
• Instagram - / cbtnuggets
• LinkedIn - / cbt-nuggets

Пікірлер: 54

  • @joshuaerkman1444
    @joshuaerkman14444 жыл бұрын

    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.

  • @armandopenaleonett1258

    @armandopenaleonett1258

    19 күн бұрын

    is this a glitch in the matrix or wtf ?

  • @learningshit
    @learningshit2 жыл бұрын

    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

    2 жыл бұрын

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

  • @mannycalavera121
    @mannycalavera1212 жыл бұрын

    I love that the KZread 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
    @saramaeks98262 жыл бұрын

    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!

  • @sebastianp.2547
    @sebastianp.25474 жыл бұрын

    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
    @jesusloaiza30323 жыл бұрын

    Dude, you are an awesome teacher!!

  • @cbtnuggets

    @cbtnuggets

    3 жыл бұрын

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

  • @mushinart
    @mushinart2 жыл бұрын

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

  • @emmanuelugwuoke967
    @emmanuelugwuoke967 Жыл бұрын

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

  • @noellep5447
    @noellep54472 жыл бұрын

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

  • @Artistram3d1
    @Artistram3d13 жыл бұрын

    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
    @tanvirhasanmonir16273 жыл бұрын

    Wonderful, comprehensive lessons. Thanks

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

  • @Red-qz4lx
    @Red-qz4lx4 жыл бұрын

    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 жыл бұрын

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

  • @ThubaMamba
    @ThubaMamba3 жыл бұрын

    Great video, straight to the point. Thanks.

  • @FundiCrypto
    @FundiCrypto11 ай бұрын

    Thanks so much

  • @clearthinking5441
    @clearthinking54413 жыл бұрын

    This is a gem of a video,

  • @WiredDrummer
    @WiredDrummer4 жыл бұрын

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

  • @Tetracarbon

    @Tetracarbon

    3 жыл бұрын

    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 жыл бұрын

    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.

  • @shadyritaB
    @shadyritaB2 жыл бұрын

    This video is really great!

  • @ishatawade
    @ishatawade2 жыл бұрын

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

  • @Ins_8800
    @Ins_88002 жыл бұрын

    Thanks a ton, keep making such videos

  • @MagnusAnand
    @MagnusAnand3 жыл бұрын

    A very useful and clear video

  • @cbtnuggets

    @cbtnuggets

    3 жыл бұрын

    Glad you liked it, thank you!

  • @AronW4
    @AronW43 жыл бұрын

    Fantastic video for me to recap!

  • @testingcoder
    @testingcoder2 жыл бұрын

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

  • @brianmusyoki521
    @brianmusyoki5212 жыл бұрын

    Very good explanation

  • @bogorehmohamed9621
    @bogorehmohamed9621 Жыл бұрын

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

  • @zaccomusic
    @zaccomusic4 жыл бұрын

    amazing video hope you keep update :)

  • @surkewrasoul4711
    @surkewrasoul4711 Жыл бұрын

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

  • @Trader-SwingTheory
    @Trader-SwingTheory Жыл бұрын

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

  • @cricketbrush9595
    @cricketbrush95954 жыл бұрын

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

  • @darrent2478
    @darrent24782 жыл бұрын

    Love It!

  • @quorawilliams1850
    @quorawilliams18502 жыл бұрын

    i actually knew this already so yeah

  • @fandewillyrex2111
    @fandewillyrex21113 жыл бұрын

    A video very cool

  • @ojobasi1559
    @ojobasi15596 ай бұрын

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

  • @ericjamesureta4125
    @ericjamesureta41252 жыл бұрын

    🥳👏bravo👏👏

  • @cricketbrush9595
    @cricketbrush95954 жыл бұрын

    I will be waiting ...

  • @froilanemeliano6551
    @froilanemeliano6551 Жыл бұрын

    4:00

  • @Arnonis
    @Arnonis4 жыл бұрын

    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
    @Azakadune2 жыл бұрын

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

  • @Certamaniac
    @Certamaniac3 жыл бұрын

    This guy sounds exactly like Louis C.K.

  • @hassandon3651
    @hassandon36512 жыл бұрын

    Awesoo

  • @marble_wraith
    @marble_wraith5 жыл бұрын

    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 жыл бұрын

    You are right

  • @rachelly7779

    @rachelly7779

    4 жыл бұрын

    I thought the same thing

  • @passportbro904

    @passportbro904

    Жыл бұрын

    Its 2023 real people only use relationship databases