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

  Рет қаралды 2,951,613

freeCodeCamp.org

freeCodeCamp.org

Күн бұрын

Пікірлер: 1 400
@codebreakthrough
@codebreakthrough 6 жыл бұрын
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
@spacetimekiddo 6 жыл бұрын
Does this also applies with nosql databases?
@tahsinmayeesha1440
@tahsinmayeesha1440 6 жыл бұрын
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
@dawah7556 6 жыл бұрын
thanks man for helping others
@GamesindieSR
@GamesindieSR 6 жыл бұрын
Caleb Curry thanks mate
@tadejdanev5030
@tadejdanev5030 6 жыл бұрын
bravo thank you !!!!
@andreaho4841
@andreaho4841 3 жыл бұрын
This channel should be nominated for an educational Nobel prize.
@jamespottex5197
@jamespottex5197 3 жыл бұрын
So, true.. U just took my words
@dayanandarajapakse9476
@dayanandarajapakse9476 3 жыл бұрын
Yes. You are correct.
@mahajanravish
@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
@miguelangelvillafuerte3328 3 жыл бұрын
at least, be recognized by UNESCO or any other international organization
@shashwatsaini2720
@shashwatsaini2720 3 жыл бұрын
Tru dat bruh ❤️
@ObaidurRehmanX
@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
@ObaidurRehmanX 3 жыл бұрын
@Harsh Vardhan corrected. Thanks!
@Snoo29293
@Snoo29293 3 жыл бұрын
You watched the whole thing in one sitting? I tried watching 1 hour per day.
@oluwaferanmikolawole3546
@oluwaferanmikolawole3546 3 жыл бұрын
@@Snoo29293 I don’t think he did 💀
@KrishnaPatel-qu6nh
@KrishnaPatel-qu6nh 2 жыл бұрын
@@ObaidurRehmanX 😀
@jeremiah3178
@jeremiah3178 2 жыл бұрын
So what do you do now?
@williamjamesrapp7356
@williamjamesrapp7356 5 жыл бұрын
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
@tesfaysimon2727 6 жыл бұрын
⌨️ (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
@aerilashraf 6 жыл бұрын
Appreciate ! Thankyou
@pastuh
@pastuh 6 жыл бұрын
But i see timestamps in video description :F
@lalaithan
@lalaithan 6 жыл бұрын
Thank you kind person. The ones in the description aren't clickable. (now they are)
@DhannyaSuresh
@DhannyaSuresh 6 жыл бұрын
Good Job Bro. Thank u
@adilismail3593
@adilismail3593 6 жыл бұрын
Thank u
@shahodanyali6062
@shahodanyali6062 3 жыл бұрын
This is unbelievable. This 8 hour video completely covered the 2 topics I had done in two semesters.
@drop_messages6226
@drop_messages6226 5 жыл бұрын
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
@TokyoXtreme 4 жыл бұрын
Alas, there are ads now.
@drop_messages6226
@drop_messages6226 4 жыл бұрын
@@TokyoXtreme damn, that sucks
@draybaba
@draybaba 4 жыл бұрын
@@drop_messages6226 Doesn't matter, the ads could be skipped and you can even download and watch offline in 720 HD without ads!
@aleksadacic
@aleksadacic 3 жыл бұрын
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
@ignacioreyna1271 3 жыл бұрын
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.
@mjshaheed
@mjshaheed 6 жыл бұрын
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
@normanhenderson7300 6 жыл бұрын
Followed him for 5 years?, he must have been very young at that time.
@nene_san
@nene_san 3 жыл бұрын
@@brandonmohammed2234 now build a database to store your stupidity.
@mohammedfalih8713
@mohammedfalih8713 3 жыл бұрын
@@nene_san 😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂
@mohammedal-lami6595
@mohammedal-lami6595 5 жыл бұрын
no ads >>>>>>>>> respect
@AbbigailGreene-x9r
@AbbigailGreene-x9r Жыл бұрын
This channel should be nominated for an educational Nobel prize.. Mad respect for Caleb Curry for recording this absolutely amazing course.
@agamenon1953
@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.
@topsl69
@topsl69 6 жыл бұрын
duude 8 hours without ads
@taeesavage5443
@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
@12567NoYouCannot 4 жыл бұрын
I know, this is Awsome, he's a like a Old-School Professor, that is So Cute. I am an Old-school person.
@Blaskillo
@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
@shelleybrent-charette9499
@shelleybrent-charette9499 2 жыл бұрын
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
@AMINE-dd1qy 10 ай бұрын
love to see someone of my father's age learning about DBs ,learning has no age they say
@mostafa4321
@mostafa4321 6 жыл бұрын
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
@gabesegun7966 5 жыл бұрын
I'm in my 50s too and I'm trying to get in. My friends are saying it's too late
@veikoplays
@veikoplays 5 жыл бұрын
Funny, mee too.. Middle age crisis?
@nickfleming3719
@nickfleming3719 5 жыл бұрын
You can learn faster at 50
@aguantejp
@aguantejp 5 жыл бұрын
@@gabesegun7966 it's never too late!
@jesusisgod4638
@jesusisgod4638 5 жыл бұрын
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
@joslynnehill6309
@joslynnehill6309 5 жыл бұрын
Caleb you are a brilliant teacher. Making complex ideas very simple. Thank you. Wish I had you as a teacher 45 years ago.
@frankellyguzman4297
@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
@EvilTim1911
@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
@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
@shang_chi4651 2 жыл бұрын
@@jeffjacques are you being sarcastic 🙄 cuz I am not able to figure out what you are trying to say
@idc20627
@idc20627 Жыл бұрын
some people are left handed? lol
@idc20627
@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
@shang_chi4651 Жыл бұрын
@@idc20627 oh I see
@burhanuddinmerchant877
@burhanuddinmerchant877 4 жыл бұрын
Mad respect for Caleb Curry for recording this absolutely amazing course🙌
@MaveLight2030
@MaveLight2030 2 ай бұрын
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!
@allisonbramhall8509
@allisonbramhall8509 5 жыл бұрын
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.
@danielude6720
@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
@kavyajaswani1801 Жыл бұрын
is it still relevant in 2023?
@AMINE-dd1qy
@AMINE-dd1qy 10 ай бұрын
@@kavyajaswani1801 2024 ma man
@Latertqq
@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
@ferdianfh 2 жыл бұрын
hello, i currently learning how to design a database ERD, is it worth to watch?
@Latertqq
@Latertqq 2 жыл бұрын
@@ferdianfh 100% espesially for 1NF, 2NF, 3NF etc
@kangmoabel
@kangmoabel 2 жыл бұрын
@@Latertqq what does 1NF mean ?
@amazhobner
@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.
@LilDad
@LilDad 6 жыл бұрын
This Freecode camp Caleb Grew Up litterally in The Video he Actually Grew a Beard.... That's Dedication and Consistancy..... I subscribed ....
@joehibbler7120
@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
@tomasjohansson8356
@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!
@BossLevelPro
@BossLevelPro Жыл бұрын
Watching this at 1.5 speed is perfect. Also, this guy seems like the friend everyone needs but only some deserve.
@jonac1144
@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
@NovaliaMedia
@NovaliaMedia Жыл бұрын
I think the only thing people need from youtube is the youtube learning certificate - this is a good class.
@DepressedMonkeyGaming
@DepressedMonkeyGaming 4 жыл бұрын
This dude deserves millions of views. Great work, really appreciate his work
@DumindaKuruppu
@DumindaKuruppu 4 жыл бұрын
Thanks man ❤ Old school teaching with a chalk and super clear explanations. And a super awesome teacher
@MarioZamoraMusic
@MarioZamoraMusic 6 жыл бұрын
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 :)
@jibzeejay7648
@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!!!!
@wisjnujudho3152
@wisjnujudho3152 4 жыл бұрын
speed it up to 1.5. I can feel the knowledge are flowing inside my brain
@samschlenner6582
@samschlenner6582 8 ай бұрын
Plowing through this for work. Caleb you're a hero.
@mb77mb66
@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
@tc7662 3 жыл бұрын
Ok Darth Vader=)
@aksharsolanki328
@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
@antoniofuller2331 5 ай бұрын
Kids are always better than adults
@antoniofuller2331
@antoniofuller2331 5 ай бұрын
​@@aksharsolanki328"her"? The IT field must have only men
@brandonking3665
@brandonking3665 2 ай бұрын
@@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.
@etornamtsyawo6407
@etornamtsyawo6407 Жыл бұрын
I've just done half of the course and I'm enjoying it! 4 years ago and still relevant!
@OneStopMusic.
@OneStopMusic. Жыл бұрын
Hey, is it worth watching in 2023?
@Kenney9120
@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.
@tdp2190
@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
@d0cn0tes
@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
@SmartStartTEFL Жыл бұрын
I think a collective "shoplifter" can be an entity
@sahiltaneja8247
@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.
@davidschreiter1483
@davidschreiter1483 6 жыл бұрын
This is of tremendous help. Love that is it not language specific and focuses on the conceptual level. Thank you much!
@mitchell4217
@mitchell4217 3 жыл бұрын
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.
@bornkool
@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.
@Ardaagaxog
@Ardaagaxog Жыл бұрын
The way that the teacher explain concepts is Amazing
@gabryos3807
@gabryos3807 Жыл бұрын
Just finished to watch this, cannot imagine how much work you put into this. Well done!
@themaggattack
@themaggattack 4 жыл бұрын
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.
@supersoniqamanyi3075
@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
@suziewilliams3194 6 ай бұрын
😂😂😂
@giveawayteam
@giveawayteam 6 ай бұрын
😂😂
@user-kricks
@user-kricks 6 ай бұрын
😂😂😂
@theaviator69
@theaviator69 5 ай бұрын
😂😂😂
@Chasing_speed
@Chasing_speed 4 ай бұрын
Hopefully it’s a 1-to-1 relationship
@timmytesla9655
@timmytesla9655 6 ай бұрын
8 hours video on database design. This is gold.
@J_prath
@J_prath 6 жыл бұрын
Lmao I love how excited he got when "we" asked what is a database? This guy is awesome so far 10/10.
@akshaykudale4762
@akshaykudale4762 2 жыл бұрын
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!!
@lansanakabbah4834
@lansanakabbah4834 3 жыл бұрын
I grade you as one of the greatest database instructor. what an opener and best database vivid explanation. I am impressed about your work.
@Alfenijonas
@Alfenijonas 8 ай бұрын
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...
@HGCSPAVANP
@HGCSPAVANP Жыл бұрын
I completed full course and also took notes great weekend
@Vibewithgautam
@Vibewithgautam Жыл бұрын
Can you share me the drive link or anything for that? will be helpful, Thanks in advance
@MuhammadJamil-ho6wl
@MuhammadJamil-ho6wl Жыл бұрын
Can you share notes plz.
@thanasiszapatetas9907
@thanasiszapatetas9907 Жыл бұрын
Can I have the notes mate?
@TOPELECTRIC123
@TOPELECTRIC123 2 жыл бұрын
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.
@MaNiMaBaLLa
@MaNiMaBaLLa 6 жыл бұрын
8 hours? Holy sweet Mercy. I ain't sleepin.
@gigelchiazna_censored
@gigelchiazna_censored 6 жыл бұрын
not if you run it a 1.25 or 1.5 speed
@hackeduc
@hackeduc 5 жыл бұрын
Best vídeo about db! I learned in 8 hrs what i didnt in two semesters!
@alexdorosin8280
@alexdorosin8280 5 жыл бұрын
This video so long you can see his beard growing
@RehannahB
@RehannahB 5 жыл бұрын
😂😂😂💙
@Norbert_Assenga
@Norbert_Assenga 5 жыл бұрын
😂😂😂😂😂😂😂😂
@sajibchakma2766
@sajibchakma2766 5 жыл бұрын
😄😂😂😄
@cosmicdarkmatter1128
@cosmicdarkmatter1128 5 жыл бұрын
he even gained a couple pounds after finishing the video … lol
@ke-n
@ke-n 4 жыл бұрын
you talk about beard the guy shifted to marker from chalk xD
@olgagem351
@olgagem351 Жыл бұрын
The best course ever, I will watch the others videos too. Great explaining skills and personality, I love it.
@johnsmith7774
@johnsmith7774 4 жыл бұрын
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.
@kaustavbasu
@kaustavbasu 2 жыл бұрын
Caleb is a legend.
@parish3281
@parish3281 5 жыл бұрын
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
@jsihavealotofplaylists 4 жыл бұрын
adventurous is pretty funny
@pangyre
@pangyre 2 жыл бұрын
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.
@anta-zj3bw
@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.
@nasimahmad9530
@nasimahmad9530 4 ай бұрын
his way of teaching is so addictive that it did not even feel that i have completed the whole video in one 2 sitting
@kurd-box7816
@kurd-box7816 6 жыл бұрын
Best teacher, best channel, always expecting the best from that channel , this video is a treasure
@Adiyat_Coto
@Adiyat_Coto 11 ай бұрын
That's it, the fully completed database course... no BS... Thanks mate!
@Heyimmilker
@Heyimmilker 3 жыл бұрын
Because i'm japanese, this channel gives me English and IT skill.
@ricardorien
@ricardorien 3 жыл бұрын
Nice! Same for me, from Venezuela-Latinamerica. Spanish speaker. Btw, japanese is cool (:
@RaynerDaCruz
@RaynerDaCruz 3 жыл бұрын
Thank you to whoever took their time and added in the video chapters. 🙏
@evilpub
@evilpub 5 жыл бұрын
this dude saved my grades bro thanks
@americatoken3334
@americatoken3334 2 жыл бұрын
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.
@gauravarora8405
@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
@themevrouwdewi
@themevrouwdewi 3 ай бұрын
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 :)
@wilsonwil657
@wilsonwil657 4 жыл бұрын
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!
@konstantinospolemis3087
@konstantinospolemis3087 Жыл бұрын
2 days with 1.75speed to finish this class! Thank you for the course, Caleb.
@asdasdasdora
@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*
@sheikmohdzaheem3933
@sheikmohdzaheem3933 2 жыл бұрын
Your dedication to work with chalk piece is just awesome! 😀
@Rickytastic1
@Rickytastic1 5 жыл бұрын
Caleb thank you for your presentation. I am working my way through and wanted to thank you.
@shashwatsaini2720
@shashwatsaini2720 3 жыл бұрын
Just one thing we can do, don't skip ads. 🙌
@anjajurgenssen6976
@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 🤗🤗🤗
@kafychannel
@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
@safasady829
@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!!
@EmmanuelAdefila
@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.
@Fedupbrummie
@Fedupbrummie 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
@abdullahkhannn326
@abdullahkhannn326 4 жыл бұрын
I must say this work is excellent for one who wants to have an idea of what database design is.
@tanmaymishra3639
@tanmaymishra3639 6 жыл бұрын
This is exactly what I was looking for today!!😊
@justnazmus8140
@justnazmus8140 4 жыл бұрын
Tanmay are you single?
@adilmughal2251
@adilmughal2251 2 жыл бұрын
This guy have pretty good skills. Thanks caleb
@quantumquant2718
@quantumquant2718 4 жыл бұрын
I love this guy, fantastic explanation for someone trying to learn this stuff in order to understand how to get started implementing db design.
@ashenisuranga2915
@ashenisuranga2915 Жыл бұрын
you my guy, are made for teaching. not everybody can do that. excellent work 👍👍
@yashCeo
@yashCeo 3 жыл бұрын
This is not a database design course it’s just a introduction to basic rdbms. Database design is where you take a practical use case and design a dB schema for a particular application.
@ameyashetty1441
@ameyashetty1441 3 жыл бұрын
@@zachary9925 did you happen to find a video on that?
@rennansouza9629
@rennansouza9629 Жыл бұрын
Awesome! Have watched this on a single day without getting bored.
@dalimkobahc
@dalimkobahc 2 жыл бұрын
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
@inesborges4857
@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.
@spacecase4062
@spacecase4062 5 жыл бұрын
Save yourself 2 hours and 45 minutes by watching this at 1.5x speed
@aguantejp
@aguantejp 5 жыл бұрын
you are the man, man
@invictuz4803
@invictuz4803 5 жыл бұрын
Save yourself the full 8 hours by watching this while you drive to and from work.
@aguantejp
@aguantejp 5 жыл бұрын
@@invictuz4803 save your self from all your lifespan hours watching this while you drive
@RehannahB
@RehannahB 5 жыл бұрын
Save yourself some time by watching in 2x speed and using the table of contents in the description 😂
@invictuz4803
@invictuz4803 5 жыл бұрын
@@RehannahB You ruined it.
@AnnyMus-rc2zh
@AnnyMus-rc2zh 4 жыл бұрын
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.
@brightonchabula2021
@brightonchabula2021 6 жыл бұрын
Very useful content.. just finished watching and the content is good
@lenaara4569
@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
@AI-in-Action952 4 жыл бұрын
Yup
@candle-likeghost9523
@candle-likeghost9523 4 жыл бұрын
Legends says people watch til the end are now gods in database field
Databases In-Depth - Complete Course
3:41:20
freeCodeCamp.org
Рет қаралды 294 М.
Database Design All-in-One Tutorial Series (8 HOURS!)
8:21:35
Caleb Curry
Рет қаралды 225 М.
Из какого города смотришь? 😃
00:34
МЯТНАЯ ФАНТА
Рет қаралды 2,2 МЛН
When u fight over the armrest
00:41
Adam W
Рет қаралды 28 МЛН
Random Emoji Beatbox Challenge #beatbox #tiktok
00:47
BeatboxJCOP
Рет қаралды 67 МЛН
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 2 МЛН
Programming Is NOT Enough | Add these 7 skills…
13:19
Travis Media
Рет қаралды 419 М.
C Programming Tutorial for Beginners
3:46:13
freeCodeCamp.org
Рет қаралды 14 МЛН
I Studied Data Job Trends for 24 Hours to Save Your Career! (ft Datalore)
13:07
Thu Vu data analytics
Рет қаралды 275 М.
SQL Tutorial - Full Database Course for Beginners
4:20:39
freeCodeCamp.org
Рет қаралды 18 МЛН
Entity Relationship Diagram (ERD) Tutorial - Part 1
6:10
Lucid Software
Рет қаралды 495 М.
Design Good Schemas - Get a Better Database - Nuri Halperin - NDC Oslo 2023
1:02:19
Coding Was HARD Until I Learned These 5 Things...
8:34
Elsa Scola
Рет қаралды 670 М.
Из какого города смотришь? 😃
00:34
МЯТНАЯ ФАНТА
Рет қаралды 2,2 МЛН