How to Design Your First Database

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.

-----------------
Connect with CBT Nuggets for the latest in IT training:

[joshuaerkman]

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.

[learningshit]

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.

[mannycalavera]

I love that the YouTube 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 :)

[sebastianp.]

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.

[saramaeks]

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!

[noellep]

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

[tanvirhasanmonir]

Wonderful, comprehensive lessons. Thanks

[emmanuelugwuoke]

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

[ThubaMamba]

Great video, straight to the point. Thanks.

[Artistramd]

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!

[Ins_]

Thanks a ton, keep making such videos

[zaccomusic]

amazing video
hope you keep update :)

[mushinart]

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

[ishatawade]

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

[kameronkang]

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

[testingcoder]

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

[Red-qzlx]

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

[bogorehmohamed]

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

[WiredDrummer]

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

[cricketbrush]

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