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.gg/sbp
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - / cbtnuggets
• Facebook - / cbtnuggets
• Instagram - / cbtnuggets
• LinkedIn - / cbt-nuggets

[@joshuaerkman1444]

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.

[@cbtnuggets]

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

[@mannycalavera121]

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

[@sebastianp.2547]

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.

[@saramaeks9826]

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!

[@noellep5447]

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

[@emmanuelugwuoke967]

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

[@tanvirhasanmonir1627]

Wonderful, comprehensive lessons. Thanks

[@ThubaMamba]

Great video, straight to the point. Thanks.

[@clearthinking5441]

This is a gem of a video,

[@Ins_8800]

Thanks a ton, keep making such videos

[@jesusloaiza3032]

Dude, you are an awesome teacher!!

[@cbtnuggets]

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

[@Artistram3d1]

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!

[@AronW4]

Fantastic video for me to recap!

[@mushinart]

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

[@shadyritaB]

This video is really great!

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

[@zaccomusic]

amazing video
hope you keep update :)

[@FundiCrypto]

Thanks so much

[@ishatawade]

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

[@testingcoder]

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

[@brianmusyoki521]

Very good explanation

[@MagnusAnand]

A very useful and clear video

[@cbtnuggets]

Glad you liked it, thank you!

[@darrent2478]

Love It!

[@Red-qz4lx]

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]

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

[@WiredDrummer]

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

[@Tetracarbon]

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]

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.

[@fandewillyrex2111]

A video very cool

[@bogorehmohamed9621]

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

[@cricketbrush9595]

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

[@ericjamesureta4125]

🥳👏bravo👏👏

[@quorawilliams1850]

i actually knew this already so yeah

[@surkewrasoul4711]

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

[@Trader-SwingTheory]

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

[@Arnonis]

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]

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

[@ravitshaltiel179]

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

[@mikeRnichols]

@@ravitshaltiel179 MS Access does the same thing.

[@cricketbrush9595]

I will be waiting ...

[@froilanemeliano6551]

4:00

[@hassandon3651]

Awesoo

[@Azakadune]

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

[@ojobasi1559]

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

[@Certamaniac]

This guy sounds exactly like Louis C.K.

[@marble_wraith]

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

[@rachelly7779]

You are right

[@rachelly7779]

I thought the same thing

[@passportbro904]

Its 2023 real people only use relationship databases