Database Design All-in-One Tutorial Series (8 HOURS!)

[@codebreakthrough]

(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

[@JimRohn-u8c]

Is there a good book that we can look at to learn this as well?

[@raidoung4100]

@@JimRohn-u8c i guess it would be good to write in google : main book on database design with :d and just stick to it :d

[@TRD_Mike]

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.

[@raidoung4100]

how much time did it take you ?:d

[@no1up]

Anyone from WGU here because Zybooks got you feeling like you're an idiot?

[@the_chemist8144]

Zybook is trash!

[@markrose9957]

yerp

[@OEFTF11]

Yeppers, Zybooks for Calc 1 and 2, Discrete Math I and II, D426, and all my other courses. It's been hell.

[@Jaeta]

Same

[@BackTheARay]

Yes. BTW This is the child.

[@samiaghezal]

⌨️ ( 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

[@arc8696]

Thanks

[@solacegrace1344]

Not sure what happened but these times are off by like 20 minutes.

[@gawdawful3378]

@@solacegrace1344 some are but others are off like 2 or 3. Atomic Values starts at like 1:40 and not 1:38

[@raidoung4100]

oh please pin this answer

[@WilliamMoore-Crispin]

Thank you

[@aayush1204]

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 😁😁

[@jdharlan4149]

I love this kid ... found him 3 days ago and I'm at 6:52:00 right now! (Watch on 1.5 speed)

[@aayush1204]

@@jdharlan4149 hey, thanks for the suggestion.

[@jdharlan4149]

Just now finishing ... great refresher!

[@aayush1204]

Am almost there, watch about 6hrs xd, 2 more days to go then I'll start SQL

[@jdharlan4149]

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

[@EricaGreene-v8g]

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!

[@Genovia816]

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!

[@brkwebdesigns179]

Just looked at your C++ tutorial , and looking back at this one, it shows how far you’ve come #you really are a legend

[@Wolfgang_von_Caelid]

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

[@TRD_Mike]

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.

[@fmartinez004]

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.

[@ninjahr859]

Really great course, thank you! Just finished over the course of 2 days for review after finishing my database fundamentals class, really helped solidify my knowledge and filled in most of the gaps I had. Very succinct which is rare on this website!

[@feelsmall315]

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)

[@24HrBusinessFromHome]

Stressin rn bc it keeps getting hyped up as hard and there is SO much stuff to SQL.

[@Wesleym63]

my advisor told me this class should take a few weeks but after reading zybooks i’ve learned nothing

[@24HrBusinessFromHome]

@@Wesleym63 Mine took 2 weeks. Reading the .docx in the coursechatter over and over did it for me. GL!!

[@davidcoveroff7856]

@@24HrBusinessFromHome did you do the zybooks assignment

[@24HrBusinessFromHome]

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

[@codygosney976]

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.

[@patrickconrad396]

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.

[@iFlyny]

Keep up the good work Caleb. I really appreciate you talking your precious time to teach others. Good job!!

[@thefaketashalyn]

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

[@viorom]

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!! 🥳🥳🥳

[@codebreakthrough]

Welcome from Udemy. Hope to see you around in the comments here on KZbin (I’m not on Udemy a whole lot).🙂

[@viorom]

Right on! ✌🏻✌🏻😊😊

[@thuvarakan6974]

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 ..

[@bigburt9302]

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

[@aniketp.8596]

A tutor saying . "What was I going to say ? Oh fck , idk." Lol loved it.

[@saadaziz6316]

@crypto cave➕① ⑤⑧⑥⑨⑧①③⑨⑨⓪ shutup no ones gonna text you

[@mann3-w1u]

I am from indonesia and I like this channel. I watch in 2021. Love from Indonesia :)

[@sethsends]

I really love this because not only are you super informative, but you also keep it fun. You're great at what you do.

[@Hector221b]

an amazing easy to understand yet thorough series. thanks a lot

[@guyspy8643]

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

[@alebupeseyie5622]

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.

[@TheManTone]

I was recommended this video from a fellow student trying to get through the terrible resources for our Data Management Course.

[@snowfreak4002]

Thank you for the video series! Nice work Caleb!

[@allezzthepunk]

This really helped me to land a job in soft dev

[@DR-gg1gi]

Thanks Caleb for making a video on database design that I can watch for more than 2 minutes without falling asleep.

[@ManishMysoreRajeshGangadhar]

Finished this course in a thorough manner, feels good. Thank you Caleb.

[@3a_nurulasyiqin394]

YOU REALLY REALLY ARE SOOOOOOOO HELPFUL YOU DESERVE MOREEEEEEEE SUBSCRIBER

[@xgherix]

Caleb, really appreciated your work, i know this comment is gonna get lost, but I wanted to express my gratitude!

[@YahYaAlabrash98]

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!

[@evemary5133]

Aww... old videos.. old sweet memories with your channel ❤️🙂

[@TanjinaAkter-cy7rd]

I am starting to learn it .. Thanks for making these type of Informational vedio

[@SergioRamos-kw6uy]

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

[@DuB_2k]

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.

[@chaselewis3819]

Just passed my WGU D426, thanks Caleb.

[@abrorakhmedov7389]

this video is very helpful for 100 years, thank you very much from UZBEKISTAN

[@thebestclassicalmusic]

This is a great video--still watching. I am trying to figure out how to make a database for a school :S

[@RussellDreifus]

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.

[@RangusMcDangus]

"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

[@sonic797_youtube]

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!

[@vladimiraguilar6718]

Simple and plain english, excellent Caleb, well done!

[@FrazzledMom]

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.

[@watup1298]

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 )

[@zanetrain1651]

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

[@zanetrain1651]

PS. Wow! I just saw you published this video today. I literally just found your videos two days ago. I'm feeling very lucky

[@jdharlan4149]

God Bless you Caleb ... great refresher training!!!

[@thefettster]

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.

[@mingoflomingo8101]

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.

[@Gun1Up]

No way. I hope he stays on YT. Kids are so mean and eventually they will break him down. They always do. 😢

[@Alfenijonas]

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.

[@diegovalenzuelacierto]

Dooooope! Thanks so much man, you've saved my life with ddbb

[@juliadudkina1551]

Great video! Thank you so much for the effort you put in to teach us on here!

[@tamer392]

outstanding work! easiest way to understand Database! Thank you so much

[@b0nzai704]

Thank you Caleb! You are an aawesome Teacher.

[@fmartinez004]

@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

[@shanmugamn7866]

very useful for beginners. thanks, Mr. Caleb

[@VinitKumar-de3yd]

Nice work Caleb Concepts are explained in a clear and easy manner

[@HungPham-jg9xn]

I've completed the tutorial, thank you Caleb

[@mikedsjr]

I've come to you channel to give you the views and thumbs up. great job. I will probably watch this a few times

[@TRUEfoe]

Thanks Caleb! This has been really helpful.

[@VishiVish01]

This kid is gonna go places.

[@diegovalenzuelacierto]

Man! Thanks for your content. Blessings from Peru!

[@cyberstudy7033]

Excellent Caleb, really enjoying, starting on Apex so needed to know the terminology, thank you!

[@netghosta]

I appreciate your effort for putting this together...

[@franciscoyoutube891]

Nice combination of humor and knowledge, awesome tutorial, thanks for sharing it 👍

[@jamesmour6776]

Thank you! Your vids are top notch. Great work, legend!

[@dibeos]

From 5:45:10 to 5:45:11 ten years have passed

[@sumitrajhanwar9739]

Thank you for this course🙏.....concepts and their explanation was really awesome👏

[@djitiasontsa817]

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

[@AlFromPalletTown]

This dude grew up to be our favorite teacher in High School.

[@rics6035]

2:44:08 You draw a very detailed running fox with the wet cloth!

[@mingoflomingo8101]

Caleb, You rock!!!!! I hope to run into you one day and shake your hand.

[@fmartinez004]

Thanks Caleb I finished the full 8 hours

[@Moe_Lester_fromUptwn]

Bright young man you are. I'm looking into Microsoft Sql as Dba. Maybe even Oracle, down the line. Any recommendations? Thanks buddy.

[@codebreakthrough]

All great choices but focus on the database design and SQL which will travel across all 🙂

[@Moe_Lester_fromUptwn]

@@codebreakthrough And that is not biased at all, I bet. ;) Appreciated, buddy. So this here oughta be a start.

[@maurooliveira2715]

Big fan of your work man!!!!

[@missme8355]

I love the long video because I can play them while I am at work or working out.

[@muktakaradi4790]

Omg dude...thanku smmmmmmmmmmmmmm u literally saved me af

[@collinskanazache8682]

you awesome, you rock all the way from ZIMBABWE

[@HarrisonG02]

Collins Kanazache ndeip

[@collinskanazache8682]

@@HarrisonG02 good man

[@johnalieusaidyna6827]

Thanks for the video Caleb!

[@Don_terrenos]

Thank you for this Caleb

[@johnnymac4052]

In a Database Development and Implementation class....Thank you for the video.

[@muktakaradi4790]

He is such a baby😭😭😭❤

[@sarfarajshahjahan2745]

Caleb, do you think you would be able make a video series about Graphql? Thank you.

[@sanazkhosroshahi5393]

beloved teacher

[@TheC0mmentSection]

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...

[@towely]

Sweet chalkboard, bro! What did that run you, about 15 bucks?

[@VinTagebeats]

what is a good energy drink to take?

[@benysmart1643]

Thanks , it was very helpful

[@7222storm]

caleb is da best!

[@jordanstout1138]

Are we not writing out any of the SQL instruction through this video?

[@Andrew-oz5bv]

Caleb well done you hero

[@CrazyCrafter181gaming]

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

[@fmartinez004]

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

[@mfedhela2065]

thanks man for the course

[@davegoodell1354]

I love the shirt!

[@isharaudayangawimalaweera3642]

Awesome and thank you

[@trinhduyhung8211]

Love love you Caleb

[@izmar47]

Thanks bro!

[@TekTonGamingNetwork]

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.

[@RahulKumar-fp1gy]

Thank you🤗