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.
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)
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!
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.
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.
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.
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!
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!
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
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.
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.
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!
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
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
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!!!!
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 :)
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.
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
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!!
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!
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.
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.
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.
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!
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.
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.
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.
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.
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!!
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 🤗🤗🤗
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
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.
That is serious judgement. Caleb is better than professors. Agreed. My professor had her own struggle to understand and teach the theoretical concepts.
@@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.
Man you are the best I found so far. Great presentation. And do not worry about talking fast. I set the speed to 1.5 to get the data flowing faster and I could comprehand everything.
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.
Caleb, what a guy !! This tutorial is very well put, anyone with litterly zero background knowlege can watch this and understand. It's like learning from your funny friend who is smart as well. He is so funny, that many to many example had me cracking up, also the "you can't born again, unless you become christian" killed me. Great stuff man !!
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
- 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.
*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*
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
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.
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 :)
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
Does this also applies with nosql databases?
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.
thanks man for helping others
Caleb Curry thanks mate
bravo thank you !!!!
This channel should be nominated for an educational Nobel prize.
So, true.. U just took my words
Yes. You are correct.
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)
at least, be recognized by UNESCO or any other international organization
Tru dat bruh ❤️
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!
@Harsh Vardhan corrected. Thanks!
You watched the whole thing in one sitting? I tried watching 1 hour per day.
@@Snoo29293 I don’t think he did 💀
@@ObaidurRehmanX 😀
So what do you do now?
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.
⌨️ (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
Appreciate ! Thankyou
But i see timestamps in video description :F
Thank you kind person. The ones in the description aren't clickable. (now they are)
Good Job Bro. Thank u
Thank u
This is unbelievable. This 8 hour video completely covered the 2 topics I had done in two semesters.
no ads >>>>>>>>> respect
This channel should be nominated for an educational Nobel prize.. Mad respect for Caleb Curry for recording this absolutely amazing course.
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.
Caleb is one of the nicest and genuine persons on TH-cam. I am glad that I have been following him for more than 5 years.
Followed him for 5 years?, he must have been very young at that time.
@@brandonmohammed2234 now build a database to store your stupidity.
@@nene_san 😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂
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
duude 8 hours without ads
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.
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!
love to see someone of my father's age learning about DBs ,learning has no age they say
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!
I know, this is Awsome, he's a like a Old-School Professor, that is So Cute. I am an Old-school person.
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
Alas, there are ads now.
@@TokyoXtreme damn, that sucks
@@drop_messages6226 Doesn't matter, the ads could be skipped and you can even download and watch offline in 720 HD without ads!
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
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.
Caleb you are a brilliant teacher. Making complex ideas very simple. Thank you. Wish I had you as a teacher 45 years ago.
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.
What's more impressive is that he wrote everything backwards with his right hand, then flipped the video horizontally just to mess with us!
@@jeffjacques are you being sarcastic 🙄 cuz I am not able to figure out what you are trying to say
some people are left handed? lol
@@shang_chi4651 video could be mirrored is what he is implying BUT he's wrong, the words would be backwards if it were mirrored.
@@idc20627 oh I see
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.
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.
is it still relevant in 2023?
@@kavyajaswani1801 2024 ma man
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
Mad respect for Caleb Curry for recording this absolutely amazing course🙌
finishing a BA computer science you have been a big help along the way ...THIS IS THE BEST CONSEPT DRIVEN ON DATABASE DESIGN ON TH-cam
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!
I think the only thing people need from youtube is the youtube learning certificate - this is a good class.
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
I'm in my 50s too and I'm trying to get in. My friends are saying it's too late
Funny, mee too.. Middle age crisis?
You can learn faster at 50
@@gabesegun7966 it's never too late!
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
This dude deserves millions of views. Great work, really appreciate his work
This Freecode camp Caleb Grew Up litterally in The Video he Actually Grew a Beard.... That's Dedication and Consistancy..... I subscribed ....
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!!!!
Want to know what to learn next? Learn SQL: th-cam.com/video/HXV3zeQKqGY/w-d-xo.html
please add automatic subtitle
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.
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
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 :)
This is a “must watch” video for all students who pursuing a CS degree. Your database design course will be piece of cake 😁
hello, i currently learning how to design a database ERD, is it worth to watch?
@@ferdianfh 100% espesially for 1NF, 2NF, 3NF etc
@@Latertqq what does 1NF mean ?
Just finished to watch this, cannot imagine how much work you put into this. Well done!
I've just done half of the course and I'm enjoying it! 4 years ago and still relevant!
Hey, is it worth watching in 2023?
speed it up to 1.5.
I can feel the knowledge
are flowing inside my brain
Thanks man ❤
Old school teaching with a chalk and super clear explanations.
And a super awesome teacher
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.
Watching this at 1.5 speed is perfect. Also, this guy seems like the friend everyone needs but only some deserve.
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
I think a collective "shoplifter" can be an entity
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!!
This is of tremendous help. Love that is it not language specific and focuses on the conceptual level. Thank you much!
I have MS MTA exam in a couple of days, finally got good tutorial worth watching. I can clear my DBMS/RDBMS basic.
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!
Plowing through this for work. Caleb you're a hero.
I completed full course and also took notes great weekend
Can you share me the drive link or anything for that? will be helpful, Thanks in advance
Can you share notes plz.
Can I have the notes mate?
I grade you as one of the greatest database instructor. what an opener and best database vivid explanation. I am impressed about your work.
Lmao I love how excited he got when "we" asked what is a database? This guy is awesome so far 10/10.
The best course ever, I will watch the others videos too. Great explaining skills and personality, I love it.
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
The way that the teacher explain concepts is Amazing
8 hours? Holy sweet Mercy. I ain't sleepin.
not if you run it a 1.25 or 1.5 speed
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.
Best vídeo about db! I learned in 8 hrs what i didnt in two semesters!
That's it, the fully completed database course... no BS... Thanks mate!
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.
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.
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!
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.
Best teacher, best channel, always expecting the best from that channel , this video is a treasure
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.
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.
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.
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!
adventurous is pretty funny
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.
this dude saved my grades bro thanks
Caleb is a legend.
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
8 hours video on database design. This is gold.
This video so long you can see his beard growing
😂😂😂💙
😂😂😂😂😂😂😂😂
😄😂😂😄
he even gained a couple pounds after finishing the video … lol
you talk about beard the guy shifted to marker from chalk xD
Your explanations are so clear and easy to understand! Please make more videos like these, These are so helpful . Thank you
Yup
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!!
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.
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 🤗🤗🤗
Awesome! Have watched this on a single day without getting bored.
Caleb thank you for your presentation. I am working my way through and wanted to thank you.
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
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.
Ok Darth Vader=)
That is serious judgement. Caleb is better than professors. Agreed. My professor had her own struggle to understand and teach the theoretical concepts.
Kids are always better than adults
@@aksharsolanki328"her"? The IT field must have only men
@@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.
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
Because i'm japanese, this channel gives me English and IT skill.
Nice! Same for me, from Venezuela-Latinamerica. Spanish speaker. Btw, japanese is cool (:
Man you are the best I found so far. Great presentation. And do not worry about talking fast. I set the speed to 1.5 to get the data flowing faster and I could comprehand everything.
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.
Caleb, what a guy !! This tutorial is very well put, anyone with litterly zero background knowlege can watch this and understand. It's like learning from your funny friend who is smart as well. He is so funny, that many to many example had me cracking up, also the "you can't born again, unless you become christian" killed me. Great stuff man !!
its literally btw, and not litterly
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
- 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.
*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*
8 hour and no ads. Respect
Very useful content.. just finished watching and the content is good
Awesome Course, keeping it funny and informative at same time
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
2 days with 1.75speed to finish this class! Thank you for the course, Caleb.
This is exactly what I was looking for today!!😊
Tanmay are you single?
one of the best courses on this channel!
Save yourself 2 hours and 45 minutes by watching this at 1.5x speed
you are the man, man
Save yourself the full 8 hours by watching this while you drive to and from work.
@@invictuz4803 save your self from all your lifespan hours watching this while you drive
Save yourself some time by watching in 2x speed and using the table of contents in the description 😂
@@RehannahB You ruined it.
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.
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.
😂😂😂
😂😂
😂😂😂
😂😂😂
Hopefully it’s a 1-to-1 relationship
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 :)
Thank you so much for making this. Exactly what I was looking for.
Bro is entertaining as heck. Thank you for explaining what my college profs could not