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

[@codebreakthrough]

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]

Does this also applies with nosql databases?

[@tahsinmayeesha1440]

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]

thanks man for helping others

[@GamesindieSR]

Caleb Curry thanks mate

[@tadejdanev5030]

bravo thank you !!!!

[@andreaho4841]

This channel should be nominated for an educational Nobel prize.

[@jamespottex5197]

So, true.. U just took my words

[@dayanandarajapakse5623]

Yes. You are correct.

[@mahajanravish]

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]

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

[@shashwatsaini2720]

Tru dat bruh ❤️

[@ObaidurRehmanX]

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]

@Harsh Vardhan corrected. Thanks!

[@Snoo29293]

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

[@oluwaferanmikolawole3546]

@@Snoo29293 I don’t think he did 💀

[@KrishnaPatel-qu6nh]

@@ObaidurRehmanX 😀

[@jeremiah3178]

So what do you do now?

[@williamjamesrapp7356]

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.

[@tesfaysimon2727]

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

Appreciate ! Thankyou

[@pastuh]

But i see timestamps in video description :F

[@lalaithan]

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

[@DhannyaSuresh]

Good Job Bro. Thank u

[@adilismail3593]

Thank u

[@amazhobner]

Entity: It is anything we store data about. Attribute: They are the things we store. E.g: Entity-Person, Attribute-Name, Age, Gender Entity Type: The specific person which is being referred to. Attribute Type: The specific column which is being referred to. Database Design: 1. Conceptual 2. Logical 3. Physical. As we go from 1 to 3, we go from general design to specific design. Data Integrity: 1. Entity Integrity: How to identify each user/record uniquely. 2. Referential Integrity: Integrity in tables having relationship. 3. Domain Integrity: Refers to integrity of values in a column. E.g. PhoneNo column can't have alphabets. Designing 1:1 relationships: This can be done in 2 ways, 1. Attribute: Everything is stored in 1 table. For e.g. We have say data of a user and his credit car number, then we will keep it in 1 table has only 1 additional column is there and the table is still about the user. 2. Entity: Here 2 tables are maintained, w.r.t above example, say along with CC number we also want to store date of issue, expiry date, cvv etc then putting it in 1 table will make that table about users as well as cards, so we make 2 different tables one containing user info and card no, or unique id for that card and another table having information about cards. Keys: 3 main points: 1) Unique 2) Never Changing 3) Never NULL Superkey: It is any number of columns needed which forces every single row to be unique. Candidate key: It is the least number number of columns needed to force every single row to be unique. You can have multiple columns possible to make a row unique like username, or email address, etc in that case select the column which satisfies the 3 criteria of KEYS, that is your primary key, the others which we did not select become our candidate key. Natural Key: A column which is a primary key and is available in table and has real world value like username. Surrogate Key: A column which is a primary key but is not available in table and has no real world value. We add this column in table like a auto-incremental ID. Foreign Key Constraint: Action: 1) On Update. 2) On Delete. Type: 1) Restrict (No Action): Error is thrown 2) Cascade: Action is reflected in FK columns. 3) Set NULL: Values in FK column are set to NULL. Compound Key: It is a key which is made up of multiple columns and all columns are keys themselves. Modality: It tells if the fk is Not nullable or Nullable, denoted by, nullable(1) and not nullable(0), basically saying that at least 0 values are required or at least 1 value is required. (5:34:40) for quick revision. Database Normalization: 1NF: 1) Columns should have atomic(single) values. 2) There shouldn't be any duplicates. 2NF: 1) Should be in 1 NF. 2) There should be no partial dependency. Point 2, if a primary key isn't composite then it automatically is in 2NF. If composite, then if non-key column in a table is dependent on partial columns of composite key (i.e. not dependent on all columns forming composite key) then this is not in 2NF and we need to make a separate table to remove this. 3NF : 1) Should be in 2NF. 2) There should be no transitive dependency. Indexes: Say you have a index on 2 columns ln and fn, then if u put in where clause, 1) both ln and fn then index would be hit. 2) only ln, then as it is on the left then index would be hit. 3) only fn, then as it is on the right then index wouldn't be hit. Point 2&3 work in MySQL, will have to verify for other Databases.

[@shahodanyali6062]

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

[@agamenon1953]

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.

[@AbbigailGreene-x9r]

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

[@mjshaheed]

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

[@normanhenderson7300]

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

[@nene_san]

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

[@mohammedfalih8713]

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

[@taeesavage5443]

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]

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

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

[@drop_messages6226]

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]

Alas, there are ads now.

[@drop_messages6226]

@@TokyoXtreme damn, that sucks

[@draybaba]

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

[@aleksadacic]

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]

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.

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

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

[@mohammedal-lami6595]

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

[@mostafa4321]

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]

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

[@veikoplays]

Funny, mee too.. Middle age crisis?

[@nickfleming3719]

You can learn faster at 50

[@aguantejp]

@@gabesegun7966 it's never too late!

[@jesusisgod4638]

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

[@danielude6720]

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]

is it still relevant in 2023?

[@AMINE-dd1qy]

@@kavyajaswani1801 2024 ma man

[@frankellyguzman4297]

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

[@joslynnehill6309]

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

[@burhanuddinmerchant877]

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

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

[@topsl69]

duude 8 hours without ads

[@allisonbramhall8509]

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.

[@MaveLight2030]

This tutorial changed the trajectory of my career years ago 🙏🏾 thank you so much! Just wanted to say that so you know how much impact you have! There’s a reason why there’s 9M views!

[@EvilTim1911]

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]

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]

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

[@LilDad]

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

[@Latertqq]

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

[@ferdianfh]

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

[@Latertqq]

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

[@kangmoabel]

@@Latertqq what does 1NF mean ?

[@Kenney9120]

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.

[@etornamtsyawo6407]

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

[@OneStopMusic.]

Hey, is it worth watching in 2023?

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

[@jibzeejay7648]

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

[@MarioZamoraMusic]

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

[@americatoken3334]

I study this in College and I can tell you this 8hrs were a Full Semestre in College. If want to save thousands of dollars and learn at your own paste watch this video. Great Presentation.

[@mitchell4217]

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.

[@jonac1144]

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

[@d0cn0tes]

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

[@bornkool]

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.

[@NovaliaMedia]

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

[@DepressedMonkeyGaming]

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

[@youssefadel6374]

- 4:04:50 we add an index to alternatives keys or the unique columns that could be used as a primary key to use them in searching later on if we need. - 5:08:25 we should use either surgoate or natural key and stick with it for the entire database but we can switch between either simple, composite or compound key normaly.

[@davidschreiter1483]

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

[@gabryos3807]

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

[@DumindaKuruppu]

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

[@sahiltaneja8247]

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

[@mb77mb66]

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]

Ok Darth Vader=)

[@aksharsolanki328]

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

[@brandonking3665]

@@aksharsolanki328 Caleb reminds me of a helpful TA (teaching assistant) that I might have had for the discussion class component of a course in addition to the main lecture with the professor back in college.

[@TOPELECTRIC123]

thhis young prodigy of Caleb should get a Nobel Prize! Amazingly focus on teaching. You will make a great contribution to this country America and the world I am so sure.

[@J_prath]

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

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

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

Can I have the notes mate?

[@BossLevelPro]

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

[@lansanakabbah4834]

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

[@hackeduc]

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

[@themaggattack]

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.

[@olgagem351]

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

[@wisjnujudho3152]

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

[@MuhammadZohaib.]

⭐ 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

[@parish3281]

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]

adventurous is pretty funny

[@kafychannel]

It is the masterpiece . I'm work as an android developer and I'm also interested in backend development . I like this video so much. Everything is clear thanks a lot

[@tdp2190]

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

[@samschlenner6582]

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

[@johnsmith7774]

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.

[@exogendesign4582]

Didn't read anything about Database Schema and never thought it has (Conceptual, logical and Physical) I am just glad what I was doing was right. I Feel so good that I am on the right track despite not knowing the terms and The theory behind it.

[@wilsonwil657]

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!

[@pangyre]

Fun, excellent, comprehensive, clear and accessible. So good. I would only offer: when security does not start at the beginning of education, it can be extremely hard for some hackers to ever take seriously. Talking about never storing, let alone displaying passwords, only their hashes or encryption keys-instead of explicitly mentioning displaying them in one of the lessons o_0-or the security benefit/necessity of artificial keys would be a great addition to these talks.

[@MaNiMaBaLLa]

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

[@gigelchiazna_censored]

not if you run it a 1.25 or 1.5 speed

[@themevrouwdewi]

8 hours of free database content! It was all so new for me despite having the CompTIA trifecta, which I think is weird imo. Hope I pass my database exam tomorrow :)

[@kurd-box7816]

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

[@rahirai5305]

Thanks guy, this is cool and never boring.

[@gauravarora8405]

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

[@AnnyMus-rc2zh]

1:28:47 - An hour and a half into the video and we just learned what SQL stands for haha. All jokes aside though, great series, learnt a lot.

[@anta-zj3bw]

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.

[@kaustavbasu]

Caleb is a legend.

[@Rickytastic1]

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

[@OneStopMusic.]

Awesome Course, keeping it funny and informative at same time

[@brightonchabula2021]

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

[@inesborges4857]

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.

[@safasady829]

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

[@Adiyat_Coto]

That's it, the fully completed database course... no BS... Thanks mate!

[@freecodecamp]

Want to know what to learn next? Learn SQL: kzbin.info/www/bejne/fom5ZK2bhrCkfbs

[@lephenix1387]

please add automatic subtitle

[@EmmanuelAdefila]

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.

[@alexdorosin8280]

This video so long you can see his beard growing

[@RehannahB]

😂😂😂💙

[@Norbert_Assenga]

😂😂😂😂😂😂😂😂

[@sajibchakma2766]

😄😂😂😄

[@cosmicdarkmatter1128]

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

[@ke-n]

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

[@Ardaagaxog]

The way that the teacher explain concepts is Amazing

[@Fedupbrummie]

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

[@konstantinospolemis3087]

2 days with 1.75speed to finish this class! Thank you for the course, Caleb.

[@tanmaymishra3639]

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

[@justnazmus8140]

Tanmay are you single?

[@Alfenijonas]

The dude just did stuff with more charisma and in a much more interesting way than all of my teachers with their educational degrees and 30+ years in teaching kids... I have just accidentally watched more than 1.5 hours without any hesitation and I did not even realize that it's already been 1.5 hours...

[@Heyimmilker]

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

[@ricardorien]

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

[@lenaara4569]

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

[@AI-in-Action952]

Yup

[@evilpub]

this dude saved my grades bro thanks

[@ReshuBhatt-h4d]

Thanks brother for making this course for us, it really helps.

[@supersoniqamanyi3075]

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]

😂😂😂

[@giveawayteam]

😂😂

[@user-kricks]

😂😂😂

[@theaviator69]

😂😂😂

[@Chasing_speed]

Hopefully it’s a 1-to-1 relationship

[@XplorerSyed]

I am 31 years old with cs degree and 4 years of experience in backend tech .never have i ever had a smooth journey to learn anything bit lengthy but its easy as pie

[@asdasdasdora]

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

[@rennansouza9629]

Awesome! Have watched this on a single day without getting bored.

[@anjajurgenssen6976]

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

[@abdullahkhannn326]

I must say this work is excellent for one who wants to have an idea of what database design is.

[@quantumquant2718]

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

[@MissBlurryFace]

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

[@richie-bonilla]

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

[@sheikmohdzaheem3933]

Your dedication to work with chalk piece is just awesome! 😀