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
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
19 күн бұрын
is this a glitch in the matrix or wtf ?
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
2 жыл бұрын
Glad you found it helpful! Thank you for learning with us, Robert.
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 :)
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!
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.
Dude, you are an awesome teacher!!
@cbtnuggets
3 жыл бұрын
Yeah, Garth is pretty great. Glad you enjoyed the video!
this is AMAZING .... as a professional teacher myself I must say that YOU ARE AMAZING
This short vid is packed with a lot of information. Thank you.
This is extraordinarily clear and helpful. Thank you so much!
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!
Wonderful, comprehensive lessons. Thanks
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
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
4 жыл бұрын
its too late.. I've already spent 45 dollars on multiple udemy courses.. help me :D
Great video, straight to the point. Thanks.
Thanks so much
This is a gem of a video,
Isn't the OrderID in OrderDetails also a FK? It references the PK of Orders table
@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
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.
This video is really great!
Hi, Good video!. Can you please explain Normalize & Refine in more detail?
Thanks a ton, keep making such videos
A very useful and clear video
@cbtnuggets
3 жыл бұрын
Glad you liked it, thank you!
Fantastic video for me to recap!
Awesome video! Could you please tell what software did you use to create this kind of presentation?
Very good explanation
Hi sir, could you define what is a database design ??
amazing video hope you keep update :)
20 years old magazine, Sounds interesting , Just imagine that you have travelled back in time.
Hank from Breaking Bad did a great job with this video It sounds so much like him!
Plz upload a video on courses require to become a databse designer
Love It!
i actually knew this already so yeah
A video very cool
A table is not synonymous to a relation. Not every table is a relation. Relational Theory.
🥳👏bravo👏👏
I will be waiting ...
4:00
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
4 жыл бұрын
I don't know the specific tool used in the video. But I always use draw.io. Very simple to use :)
@ravitshaltiel179
4 жыл бұрын
Sql server management studio, that was a ERD diagram that show the relationship between the tables
@mikeRnichols
4 жыл бұрын
@@ravitshaltiel179 MS Access does the same thing.
Bro why am I in database design im a mech. engineer. ah well...
This guy sounds exactly like Louis C.K.
Awesoo
The title needs to be changed, this is only relevant to relational databases. There are plenty of database technologies that are AP.
@rachelly7779
4 жыл бұрын
You are right
@rachelly7779
4 жыл бұрын
I thought the same thing
@passportbro904
Жыл бұрын
Its 2023 real people only use relationship databases