Database Design Course - Learn how to design and plan a database for beginners

Рет қаралды 2,865,186

Күн бұрын

This database design course will help you understand database concepts and give you a deeper grasp of database design.
Database design is the organisation of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.
Learn more about this course on Caleb Curry's website: www.calebcurry.com/freecodeca...
⭐️ Contents ⭐
⌨️ (0:00:00) Introduction
⌨️ (0:03:12) What is a Database?
⌨️ (0:11:04) What is a Relational Database?
⌨️ (0:23:42) RDBMS
⌨️ (0:37:32) Introduction to SQL
⌨️ (0:44:01) Naming Conventions
⌨️ (0:47:16) What is Database Design?
⌨️ (1:00:26) Data Integrity
⌨️ (1:13:28) Database Terms
⌨️ (1:28:28) More Database Terms
⌨️ (1:38:46) Atomic Values
⌨️ (1:44:25) Relationships
⌨️ (1:50:35) One-to-One Relationships
⌨️ (1:53:45) One-to-Many Relationships
⌨️ (1:57:50) Many-to-Many Relationships
⌨️ (2:02:24) Designing One-to-One Relationships
⌨️ (2:13:40) Designing One-to-Many Relationships
⌨️ (2:23:50) Parent Tables and Child Tables
⌨️ (2:30:42) Designing Many-to-Many Relationships
⌨️ (2:46:23) Summary of Relationships
⌨️ (2:54:42) Introduction to Keys
⌨️ (3:07:24) Primary Key Index
⌨️ (3:13:42) Look up Table
⌨️ (3:30:19) Superkey and Candidate Key
⌨️ (3:48:59) Primary Key and Alternate Key
⌨️ (3:56:34) Surrogate Key and Natural Key
⌨️ (4:03:43) Should I use Surrogate Keys or Natural Keys?
⌨️ (4:13:07) Foreign Key
⌨️ (4:25:15) NOT NULL Foreign Key
⌨️ (4:38:17) Foreign Key Constraints
⌨️ (4:49:50) Simple Key, Composite Key, Compound Key
⌨️ (5:01:54) Review and Key Points....HA GET IT? KEY points!
⌨️ (5:10:28) Introduction to Entity Relationship Modeling
⌨️ (5:17:34) Cardinality
⌨️ (5:24:41) Modality
⌨️ (5:35:14) Introduction to Database Normalization
⌨️ (5:39:48) 1NF (First Normal Form of Database Normalization)
⌨️ (5:46:34) 2NF (Second Normal Form of Database Normalization)
⌨️ (5:55:00) 3NF (Third Normal Form of Database Normalization)
⌨️ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index)
⌨️ (6:14:36) Data Types
⌨️ (6:25:55) Introduction to Joins
⌨️ (6:39:23) Inner Join
⌨️ (6:54:48) Inner Join on 3 Tables
⌨️ (7:07:41) Inner Join on 3 Tables (Example)
⌨️ (7:23:53) Introduction to Outer Joins
⌨️ (7:29:46) Right Outer Join
⌨️ (7:35:33) JOIN with NOT NULL Columns
⌨️ (7:42:40) Outer Join Across 3 Tables
⌨️ (7:48:24) Alias
⌨️ (7:52:13) Self Join
🎥Course developed by Caleb Curry. Check out his KZfaq channel: / calebthevideomaker2
🐦Follow Caleb on Twitter: / calebcurry
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: medium.freecodecamp.org

Пікірлер: 1 400

@codebreakthrough 5 жыл бұрын

I'm honored to be featured here 🙂 If you'd like to be notified of new content from me, please join my newsletter! calcur.tech/newsletter ⭐ Timestamps ⭐ ⌨ (0:00:00) Introduction ⌨ (0:03:12) What is a Database? ⌨ (0:11:04) What is a Relational Database? ⌨ (0:23:42) RDBMS ⌨ (0:37:32) Introduction to SQL ⌨ (0:44:01) Naming Conventions ⌨ (0:47:16) What is Database Design? ⌨ (1:00:26) Data Integrity ⌨ (1:13:28) Database Terms ⌨ (1:28:28) More Database Terms ⌨ (1:38:46) Atomic Values ⌨ (1:44:25) Relationships ⌨ (1:50:35) One-to-One Relationships ⌨ (1:53:45) One-to-Many Relationships ⌨ (1:57:50) Many-to-Many Relationships ⌨ (2:02:24) Designing One-to-One Relationships ⌨ (2:13:40) Designing One-to-Many Relationships ⌨ (2:23:50) Parent Tables and Child Tables ⌨ (2:30:42) Designing Many-to-Many Relationships ⌨ (2:46:23) Summary of Relationships ⌨ (2:54:42) Introduction to Keys ⌨ (3:07:24) Primary Key Index ⌨ (3:13:42) Look up Table ⌨ (3:30:19) Superkey and Candidate Key ⌨ (3:48:59) Primary Key and Alternate Key ⌨ (3:56:34) Surrogate Key and Natural Key ⌨ (4:03:43) Should I use Surrogate Keys or Natural Keys? ⌨ (4:13:07) Foreign Key ⌨ (4:25:15) NOT NULL Foreign Key ⌨ (4:38:17) Foreign Key Constraints ⌨ (4:49:50) Simple Key, Composite Key, Compound Key ⌨ (5:01:54) Review and Key Points....HA GET IT? KEY points! ⌨ (5:10:28) Introduction to Entity Relationship Modeling ⌨ (5:17:34) Cardinality ⌨ (5:24:41) Modality ⌨ (5:35:14) Introduction to Database Normalization ⌨ (5:39:48) 1NF (First Normal Form of Database Normalization) ⌨ (5:46:34) 2NF (Second Normal Form of Database Normalization) ⌨ (5:55:00) 3NF (Third Normal Form of Database Normalization) ⌨ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index) ⌨ (6:14:36) Data Types ⌨ (6:25:55) Introduction to Joins ⌨ (6:39:23) Inner Join ⌨ (6:54:48) Inner Join on 3 Tables ⌨ (7:07:41) Inner Join on 3 Tables (Example) ⌨ (7:23:53) Introduction to Outer Joins ⌨ (7:29:46) Right Outer Join ⌨ (7:35:33) JOIN with NOT NULL Columns ⌨ (7:42:40) Outer Join Across 3 Tables ⌨ (7:48:24) Alias ⌨ (7:52:13) Self Join

@spacetimekiddo 5 жыл бұрын

Does this also applies with nosql databases?

@tahsinmayeesha1440 5 жыл бұрын

the course is great, but please take some steps to remove or mute the chalk sounds on board, for people with high noise sensitivity its very hard to listen to 8 hours of board erasing and writing. Again, I have no trouble with the course content and currently using it for a database course project.

@dawah7556 5 жыл бұрын

thanks man for helping others

@GamesindieSR 5 жыл бұрын

Caleb Curry thanks mate

@tadejdanev5030 5 жыл бұрын

bravo thank you !!!!

@andreaho4841 3 жыл бұрын

This channel should be nominated for an educational Nobel prize.

@jamespottex5197 3 жыл бұрын

So, true.. U just took my words

@dayanandarajapakse9476 3 жыл бұрын

Yes. You are correct.

@mahajanravish 3 жыл бұрын

Freecodecamp must be officially considered an open university by countries so that one can earn credits and earn degree. You do not realize how much help you are providing students in poor countries( I hope they have internet connection)

@miguelangelvillafuerte3328 2 жыл бұрын

at least, be recognized by UNESCO or any other international organization

@shashwatsaini2720 2 жыл бұрын

Tru dat bruh ❤️

@ObaidurRehmanX 4 жыл бұрын

I enjoyed watching 8 hours without getting bored, and even reversing. This guy has teaching skills, naturally. Loved the lecture as well as the teaching style!

@ObaidurRehmanX 3 жыл бұрын

@Harsh Vardhan corrected. Thanks!

@Snoo29293 3 жыл бұрын

You watched the whole thing in one sitting? I tried watching 1 hour per day.

@oluwaferanmikolawole3546 2 жыл бұрын

@@Snoo29293 I don’t think he did 💀

@KrishnaPatel-qu6nh Жыл бұрын

@@ObaidurRehmanX 😀

@jeremiah3178 Жыл бұрын

So what do you do now?

@drop_messages6226 4 жыл бұрын

8 hour video, check using a chalk board, because old school (as in teaching style, not tech) teachers are the best., check no ads, check one guy, talking about one topic for 8 hours, in a free video check ..... I remind myself how lucky I am to get a free education on you tube

@TokyoXtreme 3 жыл бұрын

Alas, there are ads now.

@drop_messages6226 3 жыл бұрын

@@TokyoXtreme damn, that sucks

@draybaba 3 жыл бұрын

@@drop_messages6226 Doesn't matter, the ads could be skipped and you can even download and watch offline in 720 HD without ads!

@aleksadacic 2 жыл бұрын

for this video, at least we can do is click skip ad after 5 seconds so the guy get an extra buck for his efforts

@ignacioreyna1271 2 жыл бұрын

Still these guys deserve some kind of revenue, being all this content incredible invaluable and given to us for free. I think it's totally deserved.

@tesfaysimon2727 5 жыл бұрын

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

@aerilashraf 5 жыл бұрын

Appreciate ! Thankyou

@pastuh 5 жыл бұрын

But i see timestamps in video description :F

@lalaithan 5 жыл бұрын

Thank you kind person. The ones in the description aren't clickable. (now they are)

@DhannyaSuresh 5 жыл бұрын

Good Job Bro. Thank u

@adilismail3593 5 жыл бұрын

Thank u

@williamjamesrapp7356 4 жыл бұрын

WOW !!!!! This is the FIRST video I have seen over the last 10 years ( in my search for learning HTML CSS JS SQL PHP ...) Where someone is actually TEACHING information instead of just glossing over information and saying JUST DO WHAT I DO. I greatly appreciate actually LEARNING something that is being TAUGHT THANK YOU YOUNG MAN THANK YOU.

@mohammedal-lami6595 5 жыл бұрын

no ads >>>>>>>>> respect

@shahodanyali6062 3 жыл бұрын

This is unbelievable. This 8 hour video completely covered the 2 topics I had done in two semesters.

@topsl69 5 жыл бұрын

duude 8 hours without ads

@agamenon1953 3 жыл бұрын

Watching the video in 2021. This is so good. After 3 hours I realized I love this guy. Caleb is great at explaining each concept with amazing simplicity while being funny at the same time. You're a database hero Caleb! Thank you so much for your outstanding job.

@taeesavage5443 5 жыл бұрын

Shoutout to you for breaking this down to my understanding. I recently enrolled in a database class and was referred from a classmate to watch it. Im glad I did, thank you so much. You are awesome!

@12567NoYouCannot 3 жыл бұрын

I know, this is Awsome, he's a like a Old-School Professor, that is So Cute. I am an Old-school person.

@freecodecamp 5 жыл бұрын

Want to know what to learn next? Learn SQL: kzfaq.info/get/bejne/fr6GZt2WtrHVd40.html

@lephenix1387 5 жыл бұрын

please add automatic subtitle

@supersoniqamanyi3075 11 ай бұрын

Last night wifey asked me why I was watching a relationship video. This morning she wakes up to hearing “Parent and child”, I’ll be back guys.

@suziewilliams3194 2 ай бұрын

😂😂😂

@giveawayteam 2 ай бұрын

😂😂

@user-kricks 2 ай бұрын

😂😂😂

@theaviator69 Ай бұрын

😂😂😂

@Chasing_speed 24 күн бұрын

Hopefully it’s a 1-to-1 relationship

@user-sh6sr6pe3c Жыл бұрын

This channel should be nominated for an educational Nobel prize.. Mad respect for Caleb Curry for recording this absolutely amazing course.

@MarioZamoraMusic 5 жыл бұрын

This series was amazing!!! Thanks so much Caleb. I've been able to design a few databases because of this and I feel so confident! So thankful I found your course :)

@mjshaheed 5 жыл бұрын

Caleb is one of the nicest and genuine persons on KZfaq. I am glad that I have been following him for more than 5 years.

@normanhenderson7300 5 жыл бұрын

Followed him for 5 years?, he must have been very young at that time.

@nene_san 3 жыл бұрын

@@brandonmohammed2234 now build a database to store your stupidity.

@mohammedfalih8713 3 жыл бұрын

@@nene_san 😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂

@EvilTim1911 4 жыл бұрын

Not only did this guy do an 8 hour tutorial on databases but he did it all using his left hand to write. Truly impressive.

@jeffjacques 3 жыл бұрын

What's more impressive is that he wrote everything backwards with his right hand, then flipped the video horizontally just to mess with us!

@shang_chi4651 2 жыл бұрын

@@jeffjacques are you being sarcastic 🙄 cuz I am not able to figure out what you are trying to say

@idc20627 Жыл бұрын

some people are left handed? lol

@idc20627 Жыл бұрын

@@shang_chi4651 video could be mirrored is what he is implying BUT he's wrong, the words would be backwards if it were mirrored.

@shang_chi4651 Жыл бұрын

@@idc20627 oh I see

@burhanuddinmerchant877 3 жыл бұрын

Mad respect for Caleb Curry for recording this absolutely amazing course🙌

@joslynnehill6309 4 жыл бұрын

Caleb you are a brilliant teacher. Making complex ideas very simple. Thank you. Wish I had you as a teacher 45 years ago.

@shelleybrent-charette9499 Жыл бұрын

I took SQL years ago, that saying, you don't use it, you will lose it. Caleb, I love your teaching structure. I'm in my 50's. You keep the course engaging. The sky is the limit for you!

@AMINE-dd1qy 6 ай бұрын

love to see someone of my father's age learning about DBs ,learning has no age they say

@davidschreiter1483 5 жыл бұрын

This is of tremendous help. Love that is it not language specific and focuses on the conceptual level. Thank you much!

@mostafa4321 5 жыл бұрын

Excellent work Caleb. I am actually trying to learn SQL and Database design and your explanation is so basic makes accessible and easy to grasp. BTW I am in my 50s so it may be a bit challenging but I am getting it. keep up the awesome job

@gabesegun7966 5 жыл бұрын

I'm in my 50s too and I'm trying to get in. My friends are saying it's too late

@veikoplays 5 жыл бұрын

Funny, mee too.. Middle age crisis?

@nickfleming3719 5 жыл бұрын

You can learn faster at 50

@aguantejp 5 жыл бұрын

@@gabesegun7966 it's never too late!

@jesusisgod4638 4 жыл бұрын

Gabe Segun why are you listening to dumb people?? My dad just turned 51 he’s thinking to go back to school and have plan to work until he turns 67 which is for 16 years

@Blaskillo Жыл бұрын

I am a senior software engineer and I would like to say that your explanations are brilliant. Thank you for sharing your knowledge for free

@allisonbramhall8509 4 жыл бұрын

I came here from Caleb's blog, and was so surprised to see how young he was and also how great his content was! I needed an overview of database logic as a refresher, and this was solid. Really appreciated the examples, the quick-jump links in the description, and his clear language when explaining concepts. He also sprinkles in some genuine funny moments which had me laughing at my desk. I second Christopher Harwell - listen to it at 1.5x speed for sure and slow down to review new concepts.

@mitchell4217 2 жыл бұрын

Wow, great stuff. This guy is a great teacher. Almost done with the 8+ hour video series. It actually makes me excited to design databases.

@frankellyguzman4297 3 жыл бұрын

Just got done watching it, one semester couldn't teach me all this information, I rlly wish i could meet caleb and thank him personally

@LilDad 5 жыл бұрын

This Freecode camp Caleb Grew Up litterally in The Video he Actually Grew a Beard.... That's Dedication and Consistancy..... I subscribed ....

@jonac1144 3 жыл бұрын

I cant believe that I make a semester to learn all this and you explain it for a couple of hours 😐 I can't believe this is Free

@alexdorosin8280 5 жыл бұрын

This video so long you can see his beard growing

@RehannahB 5 жыл бұрын

😂😂😂💙

@Norbert_Assenga 5 жыл бұрын

😂😂😂😂😂😂😂😂

@sajibchakma2766 4 жыл бұрын

😄😂😂😄

@cosmicdarkmatter1128 4 жыл бұрын

he even gained a couple pounds after finishing the video … lol

@ke-n 4 жыл бұрын

you talk about beard the guy shifted to marker from chalk xD

@NovaliaMedia Жыл бұрын

I think the only thing people need from youtube is the youtube learning certificate - this is a good class.

@johnsmith7774 3 жыл бұрын

hour and 38 minutes in this is amazing, what a great instructor you are. I just may have a chance to be working with a database:) Thank you for making it very easy to understand and follow.

@DumindaKuruppu 3 жыл бұрын

Thanks man ❤ Old school teaching with a chalk and super clear explanations. And a super awesome teacher

@Latertqq 2 жыл бұрын

This is a “must watch” video for all students who pursuing a CS degree. Your database design course will be piece of cake 😁

@ferdianfh 2 жыл бұрын

hello, i currently learning how to design a database ERD, is it worth to watch?

@Latertqq 2 жыл бұрын

@@ferdianfh 100% espesially for 1NF, 2NF, 3NF etc

@kangmoabel 2 жыл бұрын

@@Latertqq what does 1NF mean ?

@gabryos3807 Жыл бұрын

Just finished to watch this, cannot imagine how much work you put into this. Well done!

@nasimahmad9530 17 күн бұрын

his way of teaching is so addictive that it did not even feel that i have completed the whole video in one 2 sitting

@danielude6720 9 ай бұрын

This is hands down the best explanation i have ever seen on DB. It is broken down in a very simplistic manner with really good examples. Thank you very much for making this content available for free to everyone.

@kavyajaswani1801 8 ай бұрын

is it still relevant in 2023?

@AMINE-dd1qy 6 ай бұрын

@@kavyajaswani1801 2024 ma man

@parish3281 4 жыл бұрын

Well I am glad that I found a person who's hand writing is equally as adventurous as mine. ;) Thanks a lot for this course mate!

@jsihavealotofplaylists 4 жыл бұрын

adventurous is pretty funny

@bornkool 3 жыл бұрын

Wow, I serendipitously stumbled upon this most informative Database tutorial. I am enjoying this young man's presentation. I appreciate the efforts he has made to eloquently present this subject matter. I give much respect and thanks for this enormous presentation of Database design, use, manipulation, and administration. This video is expanding my knowledge of database design and structure. Thank you.

@joehibbler7120 Жыл бұрын

finishing a BA computer science you have been a big help along the way ...THIS IS THE BEST CONSEPT DRIVEN ON DATABASE DESIGN ON KZfaq

@J_prath 5 жыл бұрын

Lmao I love how excited he got when "we" asked what is a database? This guy is awesome so far 10/10.

@mb77mb66 3 жыл бұрын

I am 37 years old and professional developer, watching this to refresh my knowledge about Databases. Can say with certainty that this kid is better than my professors. Congratulations, hope you are living happy life and are not addicted to some drugs or something.

@tc7662 3 жыл бұрын

Ok Darth Vader=)

@aksharsolanki328 3 жыл бұрын

That is serious judgement. Caleb is better than professors. Agreed. My professor had her own struggle to understand and teach the theoretical concepts.

@antoniofuller2331 Ай бұрын

Kids are always better than adults

@antoniofuller2331 Ай бұрын

@@aksharsolanki328"her"? The IT field must have only men

@DJEYkanjaria 4 жыл бұрын

This dude deserves millions of views. Great work, really appreciate his work

@EmmanuelAdefila 4 жыл бұрын

I just stumbled on this and was hoping to just watch the first 5 mins then close but ended up watching everything. Great video and so helpful! Well done Caleb and thank you very much.

@hackeduc2456 4 жыл бұрын

Best vídeo about db! I learned in 8 hrs what i didnt in two semesters!

@tanmaymishra3639 5 жыл бұрын

This is exactly what I was looking for today!!😊

@justnazmus8140 4 жыл бұрын

Tanmay are you single?

@akshaykudale4762 Жыл бұрын

This is the best database design tutorial I have came across. All the concepts have been throughly explained in very simple words. Thank you very much for posting this!!

@wisjnujudho3152 4 жыл бұрын

speed it up to 1.5. I can feel the knowledge are flowing inside my brain

@brightonchabula2021 5 жыл бұрын

Very useful content.. just finished watching and the content is good

@richie-bonilla 4 жыл бұрын

Thank you so much for making this. Exactly what I was looking for.

@sahiltaneja8247 4 жыл бұрын

I have MS MTA exam in a couple of days, finally got good tutorial worth watching. I can clear my DBMS/RDBMS basic.

@BossLevelPro Жыл бұрын

Watching this at 1.5 speed is perfect. Also, this guy seems like the friend everyone needs but only some deserve.

@Rickytastic1 5 жыл бұрын

Caleb thank you for your presentation. I am working my way through and wanted to thank you.

@kurd-box7816 5 жыл бұрын

Best teacher, best channel, always expecting the best from that channel , this video is a treasure

@patils22 3 жыл бұрын

Great effort Caleb!! Thanks for sharing the video. Explaining a concept is always a tough job. You did it brilliantly.

@d0cn0tes 4 жыл бұрын

This is the best introduction on database design theory, I've seen. I wish this was out in the 90's. It would have made learning this stuff more pleasant. Kudos to you! By the way, you can have a sale without a user, its' called shoplifting lol

@SmartStartTEFL Жыл бұрын

I think a collective "shoplifter" can be an entity

@MaNiMaBaLLa 5 жыл бұрын

8 hours? Holy sweet Mercy. I ain't sleepin.

@gigelchiazna1573 5 жыл бұрын

not if you run it a 1.25 or 1.5 speed

@tomasjohansson8356 Жыл бұрын

I finally finished this whole video, after rewatching some parts quite a few times. I watched a shorter SQL tutorial before, and also a couple of tutorial projects where they built simple applications using PHP and SQL. But I’m feeling so much more confident now, and am starting to feel like I could actually begin building projects of my own rather than just making some small modifications and substitutions to a tutorial project. This really is the sort of material that you need to understand WHY things are done a certain way. It’s all well and good understanding how different tables in someone’s project relate to each other, and how primary and foreign keys are used to connect things etc. But it’s a whole different thing understanding why you’d make those design choices! It feels very empowering, which is exactly how a really good course or tutorial should make you feel. So many possibilities! Thanks a lot for this!

@sakarienuh6293 2 жыл бұрын

simplicity is a key and i rarely see that in tutorial videos on youtube. i haven't even finished an hour of this video but u already got my attention. im so keen on finishing this video now and thanks for ur effort.

@jibzeejay7648 10 ай бұрын

I am taking database design this semester. I am here to watch your videos as i understands it better than what my professor is teaching me. Thank you!!!!

@lansanakabbah4834 2 жыл бұрын

I grade you as one of the greatest database instructor. what an opener and best database vivid explanation. I am impressed about your work.

@nikoleta150 5 жыл бұрын

Exactly what I needed RIGHT NOW! THANK YOU!!!!

@mcanduiken2224 2 жыл бұрын

Thanks for taking all of the time you put into this and sharing it, very much appreciated!

@HGCSPAVANP Жыл бұрын

I completed full course and also took notes great weekend

@Vibewithgautam Жыл бұрын

Can you share me the drive link or anything for that? will be helpful, Thanks in advance

@MuhammadJamil-ho6wl Жыл бұрын

Can you share notes plz.

@thanasiszapatetas9907 10 ай бұрын

Can I have the notes mate?

@kenney9120 5 жыл бұрын

If the relational database is confusing to you pay extra special attention to the process of normalizing the database and the differences between first, second, third and fourth normal form. Once you master that concept it will be simple to grasp.

@dee6962 2 жыл бұрын

Hey Caleb , thank you for your database course , it's helping me a great deal and hopefully I'll be able to design a good database for my small business . Thanks for the great work , much appreciated and please buy yourself a whiteboard

@inesborges4857 3 жыл бұрын

Awsome video Caleb very well explained. Still being viewed after 6 years. I'm Going to recomend this to my friends who are learning database design.

@m.d8434 5 жыл бұрын

Thoroughly enjoying this thanks so much... nothing like going down to the basics to give clear eyed view of stuff

@wilsonwil657 3 жыл бұрын

I accidentally bumped into this video, it is great , Caleb makes me laugh while I am learning a lot. Well done Caleb and thanks a lot for sharing knowledge!

@olgagem351 Жыл бұрын

The best course ever, I will watch the others videos too. Great explaining skills and personality, I love it.

@MrDjRayner 3 жыл бұрын

Thank you to whoever took their time and added in the video chapters. 🙏

@evilpub 5 жыл бұрын

this dude saved my grades bro thanks

@safasady829 4 жыл бұрын

Caleb, this is the best tutorial I have ever watched anywhere!!!! I am new to this and your explanation and goofy sense of humor is just perfect!! Thank you so much for your efforts and good work!!

@themaggattack 3 жыл бұрын

This is definitely the place to start before taking a DB boot camp. I'm doing a Bootcamp class now and I probably would have been at a loss had I not watched this lecture, first. It's long, but that's bc it's comprehensive. He really gives a good foundation of DB theory concepts, which is immensely helpful to have set in mind BEFORE you try to put it into practice. I like how he builds on concepts and repeats them as they apply to the new concepts he's introducing. This really helps set the basic framework into your mind. The repetition and incremental review is good.

@elliot2019 3 жыл бұрын

I like the way of your teaching in this video. It helps me to understand easily the database fundamental theory. Thank you!

@tdp2190 4 жыл бұрын

I value this young man's time and talent in teaching me a grown person old enough to be his parent Thank you for teaching me

@anjajurgenssen6976 3 жыл бұрын

Kudos to you, young man 🤗 You may not be a qualified educator but you have a way of getting the point across in a way that just ... well, works 🤷‍♀️ Please keep up this excellent work 🤗🤗🤗

@veikoplays 5 жыл бұрын

Huuuuuuge thanks! Learned a Lot! Thank's to You I was able to start my project and excel at it! Please consider adding more code exaples, like table creation and FOREIGN KEY assignment..

@bruderjr 4 жыл бұрын

Did you say excel?? That's not a database. It's a spreadsheet. LoL. Gotcha!!

@shacklezshowdown6697 3 жыл бұрын

@@bruderjr you know excel is a word in English?

@etornamtsyawo6407 Жыл бұрын

I've just done half of the course and I'm enjoying it! 4 years ago and still relevant!

@OneStopMusic. 9 ай бұрын

Hey, is it worth watching in 2023?

@kaustavbasu 2 жыл бұрын

Caleb is a legend.

@Heyimmilker 3 жыл бұрын

Because i'm japanese, this channel gives me English and IT skill.

@ricardorien 3 жыл бұрын

Nice! Same for me, from Venezuela-Latinamerica. Spanish speaker. Btw, japanese is cool (:

@AbhishekKumar-mq1tt 5 жыл бұрын

Thank u for this awesome video

@samschlenner6582 4 ай бұрын

Plowing through this for work. Caleb you're a hero.

@theblackelephant 2 жыл бұрын

man i have been following you for sometime now am glad that you also made this great beginner course. thanks a lot

@ShadowD71 5 жыл бұрын

Respect for this long very nice powerful information Video ... Thank you

@gauravarora8405 2 жыл бұрын

Hi @caleb , Please add BCNF, 4NF and 5NF .Nobody teaches like you...I'm obsessed with your teaching style...Great course Btw.I completed it in 4 days

@Ardaagaxog 9 ай бұрын

The way that the teacher explain concepts is Amazing

@lenaara4569 4 жыл бұрын

Your explanations are so clear and easy to understand! Please make more videos like these, These are so helpful . Thank you

@AI-in-Action952 3 жыл бұрын

Yup

@quantumquant2718 3 жыл бұрын

I love this guy, fantastic explanation for someone trying to learn this stuff in order to understand how to get started implementing db design.

@shishukumarchoudhary5989 5 жыл бұрын

Sir your are awesome

@ronoc89 3 жыл бұрын

Love the "By His stripes we are healed t-shirt'. God bless you bro. Thanks for the amazing lessons, from Ireland.

@StayHealthyWithDarya 3 жыл бұрын

Dear Caleb, thank you very much for such amazing tutorial! I've just finished watching it!

@dalimkobahc Жыл бұрын

I love how he pronounces the noun attribute like the verb attribute 😂 Overall great video with extensive coverage of database design from the ground up. Good job

@asdasdasdora 3 жыл бұрын

*Querry*: Sorta like searching, giving us cool results I just love it. I don't care how many points I lose, if it comes up in the test: I'm writing *THIS*

@tarikbelghouar5035 2 жыл бұрын

Great video, excellent trainer. Thanks Caleb this was a great refresher and would be perfect for people new to databases

@poojapatole3573 7 ай бұрын

Caleb is a great fun teacher. I have learnt so much from this video series and did not get bored at all. Thank you Caleb

@anta-zj3bw 5 жыл бұрын

50 minutes into this course. I'm an older guy so the presenter here looks really young to me. I just have to say this young man rocks.. He's a born teacher.. Makes concepts very easy to grasp. Awesome job.. keep up the good work.