Database Design All-in-One Tutorial Series (8 HOURS!)
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- 💰 Mentorship to six figure software engineer - calcur.tech/me...
⚙️ Backend Engineering Mind Map - calcur.tech/mi...
💻 System Design Playlist - calcur.tech/sy...
💯 FREE Courses (100+ hours) - calcur.tech/fr...
🏆 C++ Mastery Course - [cppmastery.com](cppmastery.com/)
🐍 Backend Python Course - calcur.tech/ba...
🥇 Python Mastery Course - calcur.tech/py...
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/ne...
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/sub...
👨🏻🎓 Courses - [www.codebreakt...](www.codebreakt...)
🅿 Patreon - calcur.tech/pat...
(Free) Watch this video ad-free: calcur.tech/all-in-ones
If you've enjoy my content please do me a favor and hit that sub button ;)
Timestamps:
00:00:00 - Intro
00:10:36 - What is a Relational Database?
00:23:39 - RDBMS
00:37:40 - Introduction to SQL
00:44:37 - Naming Conventions
00:48:06 - What is Database Design?
01:01:39 - Introduction
01:15:05 - Database Terms
01:30:13 - More Database Terms
01:40:53 - Atomic Values
01:46:47 - Relationships
01:53:16 - One-to-One Relationships
01:56:26 - One-to-Many Relationships
02:00:44 - Many-to-Many Relationships
02:05:24 - Designing One-to-One Relationships
02:16:51 - Designing One-to-Many Relationships
02:27:49 - Parent Tables and Child Tables
02:34:46 - Designing Many-to-Many Relationships
02:51:02 - Summary of Relationships
02:59:31 - Introduction to Keys
03:12:26 - Primary Key Index
03:18:54 - Look up Table
03:35:07 - Superkey and Candidate Key
03:54:21 - Primary Key and Alternate Key
04:02:17 - Surrogate Key and Natural Key
04:09:50 - Should I use Surrogate Keys or Natural Keys
04:19:23 - Foreign Key
04:32:01 - NOT NULL Foreign Keys
04:45:13 - Foreign Key Constraints
04:56:59 - Simple Key, Composite Key, Compound Key
05:09:12 - Review and Key Points… HA GET IT… KEY points
05:17:57 - Introduction to Entity Relationship Modeling
05:25:57 - Cardinality
05:33:31 - Modality
05:45:11 - Introduction to Database Normalization
05:50:09 - 1NF (First Normal Form of Database Design)
05:56:59 - 2NF (Second Normal Form of Database Normalization)
06:05:49 - 3NF (Third Normal Form of Database Normalization)
06:12:09 - Indexes (Clustered, Nonclustered, Composite Index)
06:25:37 - Data Types
06:37:07 - Introduction to Joins
06:51:05 - Inner Join
07:06:44 - Inner Join on 3 Tables
07:19:45 - Inner Join on 3 Tables (Examples)
07:36:36 - Introduction to Outer Joins
07:43:10 - Right Outer Join
07:49:00 - JOIN with NOT NULL
07:56:32 - Outer Join Across 3 Tables
08:02:16 - Alias
08:06:06 - Self Join
Is there a good book that we can look at to learn this as well?
Caleb, I just finished all eight hours and 21 minutes of this series. Man, I feel like we've been on a journey together. This video series has been incredibly helpful in learning database design for my course I'm taking. In fact, I've probably learned more from this series than I have in any of my college courses. You have a great way of teaching and explaining things in an easy and digestible way, and the approach with the chalkboard was absolutely wonderful as it kept things simple and easy. Your style made things fun and non-traditional, and removed the boringness from typical teaching material. Since I've been watching you non-stop the past few days, even my wife has enjoyed your videos, who is completely non-techy. Not because she has any interest in database design, but because your approach and personality drew her in too. I know these videos are almost 10 years old now and you've moved on to bigger and better things, but I hope you recognize how special this series is, in your approach and teaching style. Thank you. I hope nothing but the best for you.
⌨️ ( 0:00:00 ) Introduction
⌨️ ( 0:03:12 ) What is a Database?
⌨️ ( 0:11:04 ) What is a Relational Database?
⌨️ ( 0:23:41 ) RDBMS
⌨️ ( 0:27:30 ) Introduction to SQL
⌨️ ( 0:43:58 ) Naming Conventions
⌨️ ( 0:47:14 ) What is Database Design?
⌨️ ( 1:00:23 ) Data Integrity
⌨️ ( 1:13:26 ) Database Terms
⌨️ ( 1:28:26 ) More Database Terms
⌨️ ( 1:38:43 ) Atomic Values
⌨️ ( 1:44:23 ) Relationships
⌨️ ( 1:50:29 ) One-to-One Relationships
⌨️ ( 1:53:38 ) One-to-Many Relationships
⌨️ ( 1:57:43 ) Many-to-Many Relationships
⌨️ ( 2:02:16 ) Designing One-to-One Relationships
⌨️ ( 2:13:33 ) Designing One-to-Many Relationships
⌨️ ( 2:23:42 ) Parent Tables and Child Tables
⌨️ ( 2:30:34 ) Designing Many-to-Many Relationships
⌨️ ( 2:46:14 ) Summary of Relationships
⌨️ ( 2:54:32 ) Introduction to Keys
⌨️ ( 3:07:14 ) Primary Key Index
⌨️ ( 3:13:31 ) Look up Table
⌨️ ( 3:30:07 ) Superkey and Candidate Key
⌨️ ( 3:48:44 ) Primary Key and Alternate Key
⌨️ ( 3:56:11 ) Surrogate Key and Natural Key
⌨️ ( 4:03:29 ) Should I use Surrogate Keys or Natural Keys?
⌨️ ( 4:12:52 ) Foreign Key
⌨️ ( 4:45:06 ) NOT NULL Foreign Key
⌨️ ( 4:38:02 ) Foreign Key Constraints
⌨️ ( 4:49:34 ) Simple Key, Composite Key, Compound Key
⌨️ ( 5:01:36 ) Review and Key Points....HA GET IT? KEY points!
⌨️ ( 5:10:09 ) Introduction to Entity Relationship Modeling
⌨️ ( 5:17:14 ) Cardinality
⌨️ ( 5:24:21 ) Modality
⌨️ ( 5:34:54 ) Introduction to Database Normalization
⌨️ ( 5:39:28 ) 1NF (First Normal Form of Database Normalization)
⌨️ ( 5:46:14 ) 2NF (Second Normal Form of Database Normalization)
⌨️ ( 5:54:40 ) 3NF (Third Normal Form of Database Normalization)
⌨️ ( 6:00:52 ) Indexes (Clustered, Nonclustered, Composite Index)
⌨️ ( 6:14:16 ) Data Types
⌨️ ( 6:25:35 ) Introduction to Joins
⌨️ ( 6:38 :60) Inner Join
⌨️ ( 6:54:26 ) Inner Join on 3 Tables
⌨️ ( 7:07:18 ) Inner Join on 3 Tables (Example)
⌨️ ( 7:23:26 ) Introduction to Outer Joins
⌨️ ( 7:29:33 ) Right Outer Join
⌨️ ( 7:35:07 ) JOIN with NOT NULL Columns
⌨️ ( 7:42:14 ) Outer Join Across 3 Tables
⌨️ ( 7:47:56 ) Alias
⌨️ ( 7:54:39 ) Self Join
Thanks
Not sure what happened but these times are off by like 20 minutes.
Anyone from WGU here because Zybooks got you feeling like you're an idiot?
Zybook is trash!
yerp
Yeppers, Zybooks for Calc 1 and 2, Discrete Math I and II, D426, and all my other courses. It's been hell.
Same
Yes.
BTW This is the child.
I have watched HOURS of videos trying to understand these concepts and I was able to follow along with your videos so easily. You explained everything so well. And structured it all to make sense where everything built off of things that that were explained before. Just about any other combined concept video attempting to explain these concepts was all over the place. And there were concepts that I somewhat understood but there was just a connection missing in my brain but you described everything PERFECTLY. Thank you so much Caleb!
I am gonna complete this course in 8days
Day -1 --> 04-22-2020 --> 1:01:41
Day2 --> 04-23-2020--> 2:01:03
Day3 --> 04-24-2020 --> 3:02:40
Day4 --> 04-25-2020 --> 4:02:17
Day5 --> 04-26-2020 --> 5:09:14
Day6 --> 04-27-2020 --> 6:05:52
Day7 --> 04-28-2020 --> 7:06:47
Day8--> 04-29-2020--> completed 🤗
Now it's time to move to MySQL video 😁😁
I love this kid ... found him 3 days ago and I'm at 6:52:00 right now! (Watch on 1.5 speed)
@@jdharlan4149 hey, thanks for the suggestion.
Just now finishing ... great refresher!
Am almost there, watch about 6hrs xd, 2 more days to go then I'll start SQL
@@aayush1204 ... I studied MS SQL in college but wonder if MySQL would be better for a small business app I want to design for my wife's elderly care business. I am doing Caleb's MySQL class from 2017 to figure that out. I know MS SQL lets you build a db up to 10 gb for free but MySQL is free and lets you go between LINUX / MAC / Windows.
This content is SOLID and very thorough. First time on your page and I've liked, subscribed, and turned on notifications. I've been working with databases for nearly 8 years and only into the video an hour and half and have already learned a few things! Thanks for this content, great job!
Just looked at your C++ tutorial , and looking back at this one, it shows how far you’ve come #you really are a legend
Caleb you are a damn LIFE SAVER for this one! I have my "Datenbanken 1" exam in 2 weeks (I study abroad) and was able to watch and understand everything within an afternoon! Now I just need to practice practical stuff like turning a description text into an ERM, turning an ERM into a schema, normalization, and basic SQL stuff and I will be completely prepared! Many many thanks :)
Caleb, I have really appreciated this video and how you explain database design. I've been watching it over and again for about 6 months. One of my favorite videos.
to anyone out there hitting that D426, this video at 2X speed and that red font file text-to-speech at 1.5x speed + Ch.2 & 3 labs, pass in 5 days (dont be fooled, it took me nearly all 6 months cause procrastination lol)
Stressin rn bc it keeps getting hyped up as hard and there is SO much stuff to SQL.
my advisor told me this class should take a few weeks but after reading zybooks i’ve learned nothing
@@Wesleym63 Mine took 2 weeks. Reading the .docx in the coursechatter over and over did it for me. GL!!
@@24HrBusinessFromHome did you do the zybooks assignment
@@davidcoveroff7856 I used that .doc for most of this, and focused on a few chapters solely in zybooks. Then for D427 I did chapt 1,2,7,8 only.
Hey Caleb! First, this video series is awesome! I'm almost 5.5 hours in and not a single screen yet. I love the chalkboard approach and I love your teaching style. You make it fun and enjoyable.
I just wanted to say a slight correction for your ER models. Whenever I encounter something you teach that I don't fully understand, I'll do some external searching to better understand. From my understanding, the E is Enhance for only EER.
EER: Enhanced Entity-Relationship
ERD: Entity-Relationship Diagram
ER: Entity-Relationship
Again, thank you so much for putting so much time into creating this amazing series.
A tutor saying .
"What was I going to say ?
Oh fck , idk."
Lol loved it.
@crypto cave➕① ⑤⑧⑥⑨⑧①③⑨⑨⓪ shutup no ones gonna text you
Keep up the good work Caleb. I really appreciate you talking your precious time to teach others. Good job!!
I love how you make your videos fun and interesting yet concise. Every noise you make or even changing your tone of voice is like dangling keys in front of me to make sure I'm paying attention. Great videos, thank you
You’re THE best Caleb! Thanks for creating this channel and sharing all cool stuff. I followed you from Udemy. I love the way you visualize things in a very clear and easy to understand. This really helps with my projects I’m working on.
Cheers from your biggest fan/student/whatever from Bangkok!!!! Keep doing great job!! Peace out!!!! All the best!! 🥳🥳🥳
Welcome from Udemy. Hope to see you around in the comments here on TH-cam (I’m not on Udemy a whole lot).🙂
Right on! ✌🏻✌🏻😊😊
Caleb .. Thanks alot bro .. Never have thought anyone could teach these subjects with ease, specially in a fun way .. you have done a great job ..
Caleb Curry your video content is awesome and mesmerizing.
The way you explained just wow, simple and precised. It helped me a lot.
Keep it up.
Thank you Caleb Curry.
I really love this because not only are you super informative, but you also keep it fun. You're great at what you do.
So much easier to read your whiteboard when you changed to black at almost 8 hour mark. Thanks for this free lesson, it has been helpful for a total noob.
an amazing easy to understand yet thorough series. thanks a lot
Dude you're awesome. I hate having searched for stuff like this specifically for years pretty much and youtube doesn't recommend them. Glad I finally found your channel. I subscribed and hit the bell man. Thanks for this stuff.
Dude... You are great., Keep doing what you are doing. It is easy to learn from you because you keep it real and it is obious you have a passion for what you are doing
Caleb,
I am watching this four years after the original posting and it is very informative. Thank you for your excellent work!😁
Sincerely,
your newest subscriber
Finished this course in a thorough manner, feels good. Thank you Caleb.
Hi Caleb! I love your tutorials, they have helped me A LOT, not even exaggerating. I have an exam in a few days, and I was wondering if there would be some place where I can practice these concepts? I feel like I understand everything but I will have trouble once I need to apply them. Anyways, thanks for creating these tutorials. Keep creating amazing tutorials for us noobs to learn from :)
This really helped me to land a job in soft dev
I am from indonesia and I like this channel. I watch in 2021. Love from Indonesia :)
This is a great video--still watching. I am trying to figure out how to make a database for a school :S
Aww... old videos.. old sweet memories with your channel ❤️🙂
Man you are great.
I love the way you teach
I love how you used the CHALK rather than slides and bullshit like today's teaching approach!
THANK YOU!
YOU REALLY REALLY ARE SOOOOOOOO HELPFUL YOU DESERVE MOREEEEEEEE SUBSCRIBER
Thanks Caleb for making a video on database design that I can watch for more than 2 minutes without falling asleep.
Thanks for this video Caleb. Truly an interesting video on a not so fun to read about subject. I feel like this would have taken me a lot longer to learn if I just had to read it. Thanks for all those that recommended this video in Reddit and commented here to say it was helpful.
this video is very helpful for 100 years, thank you very much from UZBEKISTAN
Hi man! Would you mind sharing a little bit about how you prepared for these presentations? You flow very naturally. I'm an aspiring teacher!
Thanks Caleb! This has been really helpful.
I was recommended this video from a fellow student trying to get through the terrible resources for our Data Management Course.
"thanks for watching, make sure to subs- THAT's what's different, i didn't have a light on.. oh man.. well anyway, thanks for watching" lmao Caleb thank you for being you
Great video! Thank you so much for the effort you put in to teach us on here!
Dooooope! Thanks so much man, you've saved my life with ddbb
Thank you Caleb! You are an aawesome Teacher.
DUDE!!! Please tell me you are pursuing education as a career! I absolutely love your teaching style. Entertaining and very informative. Thank you for these videos.
I'd say get into the database business, enjoy building a life and family, and when the nest is empty and you want to give back to the community then pursue teaching. Your energy and attitude are great but it would be so much better if you let them grow and ripen through the years.
No way. I hope he stays on YT. Kids are so mean and eventually they will break him down. They always do. 😢
very useful for beginners. thanks, Mr. Caleb
outstanding work! easiest way to understand Database! Thank you so much
Bro you're so unintentionally funny. I love this video. I appreciate this video and hope you continue to make more insightful videos like this.
This is amazing content. Amazing job. Biggest respect, you are natural! I am watching it like a movie. I mean not I am even getting bored. I haven't got bored even once! This is just blowing my mind. And I have seen worse stuff on paid course platforms.
Thank you! Your vids are top notch. Great work, legend!
New subscriber here! I really appreciate this video as I am brand new to this stuff. I have learned A LOT. You're awesome! I will be watching your other stuff as I continue my education.
Man! Thanks for your content. Blessings from Peru!
Ok Caleb. I'm putting this video to the test. I'm the back end for a senior project. Did alpha on my own bc it was simple. Now the beta part I've watched your one to one,many videos and you did a great job explaining everything. I'm excited to start watching this video. I'm thinking I won't be let down
PS. Wow! I just saw you published this video today. I literally just found your videos two days ago. I'm feeling very lucky
Excellent Caleb, really enjoying, starting on Apex so needed to know the terminology, thank you!
Simple and plain english, excellent Caleb, well done!
I've completed the tutorial, thank you Caleb
Bright young man you are. I'm looking into Microsoft Sql as Dba. Maybe even Oracle, down the line.
Any recommendations? Thanks buddy.
All great choices but focus on the database design and SQL which will travel across all 🙂
@@codebreakthrough And that is not biased at all, I bet.
;)
Appreciated, buddy. So this here oughta be a start.
I've come to you channel to give you the views and thumbs up. great job. I will probably watch this a few times
Great video beautifully explained. I almost lost hope in Database Management course i'm taking. Thank you Caleb! (P.S. Watching the video in 2x made your random bursts of energy hilarious )
2:44:08 You draw a very detailed running fox with the wet cloth!
Thank you for this course🙏.....concepts and their explanation was really awesome👏
God Bless you Caleb ... great refresher training!!!
I appreciate your effort for putting this together...
This kid is gonna go places.
Caleb, You rock!!!!! I hope to run into you one day and shake your hand.
Nice combination of humor and knowledge, awesome tutorial, thanks for sharing it 👍
Caleb, do you think you would be able make a video series about Graphql? Thank you.
Hi Caleb,
Thank you for this update tutoriel. I am following you since a while now. Thank you for all the step by step tutoriel on Database.
I am just willing to let you know I am eager to see your tutoriel about Fact Tables also known as Data Tables.
If you have done such kind of tutoriel on another platform please send the link to me.
Kind regards
Nice work Caleb
Concepts are explained in a clear and easy manner
Caleb, is there any chance you could split these videos up into playlists? That way I can pick up where I left off easier? In the Free Code Camp video someone posted a comment showing each of the minute locations of each of the topics, it would be great if I could just click on the video with that title instead of relying on someone's comment to navigate the video? Just a thought...
I love the long video because I can play them while I am at work or working out.
In a Database Development and Implementation class....Thank you for the video.
Omg dude...thanku smmmmmmmmmmmmmm u literally saved me af
Thanks Caleb I finished the full 8 hours
@7:55:13 left outer join with users on the left returns all users in the column bc it is a left outer join and returns all comments associated with the user bc it is not null
you awesome, you rock
all the way from ZIMBABWE
Collins Kanazache ndeip
@@harrisong953 good man
Big fan of your work man!!!!
Thank you for this Caleb
beloved teacher
Thanks for the video Caleb!
Thanks , it was very helpful
When you explain designing many-to-many relationships through the use of an intermediary. Would both the keys for the intermediary be Foreign or is the class one primary, vice versa. Or would you have an id collum and have both the keys as foreign. Anyways, I love your tutorials and the way you explain the content, keep it up man :).
Crazy Crafter181 In a many to many relationship you'll break up the relationship into separate tables with their own primary keys. The intermediary table uses the primary keys of the other tables that become that become foreign keys that link to the other tables. You can also have a primary key for the intermediary table that may be useful in other cases. Hope I'm right Caleb
From 5:45:10 to 5:45:11 ten years have passed
Thank you, Caleb! Great videos! Working on my IT degree and needed some database instruction. Love that you be yourself and have fun! I'm also a Crypto Day Trader, so I'm to going to check out your crypto videos.
thanks man for the course
caleb is da best!
Caleb well done you hero
Awesome and thank you
He is such a baby😭😭😭❤
I love the shirt!
Love love you Caleb
I like your shirt. "By His stripes we are healed."
Thanks for this
Thanks bro!
Hi, can anyone recommend a resource(book?) with exercises to practice these concepts? thanks
I wouldn't use a username as a PK bcs, sometime It would change if the user wants (mainly bcs UX).
Thank you🤗
Claire - 666 hahaha. Classic good sir, classic. Thank you for the lessons and the laughs man!
Thank you
Very very useful tutorial
this is young caleb curry
So for a one to many relationship, is this an example that would work?
A head chef has many relationships with members on his cooking line, but all those chefs relate to him as the head chef and no one else?