Database Design Course - Learn how to design and plan a database for beginners
Vložit
- čas přidán 28. 06. 2024
- This database design course will help you understand database concepts and give you a deeper grasp of database design.
Database design is the organisation of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.
Learn more about this course on Caleb Curry's website: www.calebcurry.com/freecodeca...
⭐️ Contents ⭐
⌨️ (0:00:00) Introduction
⌨️ (0:03:12) What is a Database?
⌨️ (0:11:04) What is a Relational Database?
⌨️ (0:23:42) RDBMS
⌨️ (0:37:32) Introduction to SQL
⌨️ (0:44:01) Naming Conventions
⌨️ (0:47:16) What is Database Design?
⌨️ (1:00:26) Data Integrity
⌨️ (1:13:28) Database Terms
⌨️ (1:28:28) More Database Terms
⌨️ (1:38:46) Atomic Values
⌨️ (1:44:25) Relationships
⌨️ (1:50:35) One-to-One Relationships
⌨️ (1:53:45) One-to-Many Relationships
⌨️ (1:57:50) Many-to-Many Relationships
⌨️ (2:02:24) Designing One-to-One Relationships
⌨️ (2:13:40) Designing One-to-Many Relationships
⌨️ (2:23:50) Parent Tables and Child Tables
⌨️ (2:30:42) Designing Many-to-Many Relationships
⌨️ (2:46:23) Summary of Relationships
⌨️ (2:54:42) Introduction to Keys
⌨️ (3:07:24) Primary Key Index
⌨️ (3:13:42) Look up Table
⌨️ (3:30:19) Superkey and Candidate Key
⌨️ (3:48:59) Primary Key and Alternate Key
⌨️ (3:56:34) Surrogate Key and Natural Key
⌨️ (4:03:43) Should I use Surrogate Keys or Natural Keys?
⌨️ (4:13:07) Foreign Key
⌨️ (4:25:15) NOT NULL Foreign Key
⌨️ (4:38:17) Foreign Key Constraints
⌨️ (4:49:50) Simple Key, Composite Key, Compound Key
⌨️ (5:01:54) Review and Key Points....HA GET IT? KEY points!
⌨️ (5:10:28) Introduction to Entity Relationship Modeling
⌨️ (5:17:34) Cardinality
⌨️ (5:24:41) Modality
⌨️ (5:35:14) Introduction to Database Normalization
⌨️ (5:39:48) 1NF (First Normal Form of Database Normalization)
⌨️ (5:46:34) 2NF (Second Normal Form of Database Normalization)
⌨️ (5:55:00) 3NF (Third Normal Form of Database Normalization)
⌨️ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index)
⌨️ (6:14:36) Data Types
⌨️ (6:25:55) Introduction to Joins
⌨️ (6:39:23) Inner Join
⌨️ (6:54:48) Inner Join on 3 Tables
⌨️ (7:07:41) Inner Join on 3 Tables (Example)
⌨️ (7:23:53) Introduction to Outer Joins
⌨️ (7:29:46) Right Outer Join
⌨️ (7:35:33) JOIN with NOT NULL Columns
⌨️ (7:42:40) Outer Join Across 3 Tables
⌨️ (7:48:24) Alias
⌨️ (7:52:13) Self Join
🎥Course developed by Caleb Curry. Check out his CZcams channel: / calebthevideomaker2
🐦Follow Caleb on Twitter: / calebcurry
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: medium.freecodecamp.org
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?
no ads >>>>>>>>> respect
duude 8 hours without ads
⌨️ (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
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.
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.
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.
This is unbelievable. This 8 hour video completely covered the 2 topics I had done in two semesters.
This channel should be nominated for an educational Nobel prize.. Mad respect for Caleb Curry for recording this absolutely amazing course.
Mad respect for Caleb Curry for recording this absolutely amazing course🙌
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.
Caleb you are a brilliant teacher. Making complex ideas very simple. Thank you. Wish I had you as a teacher 45 years ago.
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, great stuff. This guy is a great teacher. Almost done with the 8+ hour video series. It actually makes me excited to design databases.
Caleb is one of the nicest and genuine persons on CZcams. 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 😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂
This is of tremendous help. Love that is it not language specific and focuses on the conceptual level. Thank you much!
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.
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
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
This Freecode camp Caleb Grew Up litterally in The Video he Actually Grew a Beard.... That's Dedication and Consistancy..... I subscribed ....
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
This dude deserves millions of views. Great work, really appreciate his work
Thanks man ❤
Old school teaching with a chalk and super clear explanations.
And a super awesome teacher
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.
Just finished to watch this, cannot imagine how much work you put into this. Well done!
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
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
finishing a BA computer science you have been a big help along the way ...THIS IS THE BEST CONSEPT DRIVEN ON DATABASE DESIGN ON CZcams
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!!
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.
Thank you so much for making this. Exactly what I was looking for.
Best teacher, best channel, always expecting the best from that channel , this video is a treasure
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.
Lmao I love how excited he got when "we" asked what is a database? This guy is awesome so far 10/10.
Very useful content.. just finished watching and the content is good
Best vídeo about db! I learned in 8 hrs what i didnt in two semesters!
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
Exactly what I needed RIGHT NOW! THANK YOU!!!!
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.
😂😂😂
😂😂
😂😂😂
😂😂😂
Great effort Caleb!! Thanks for sharing the video. Explaining a concept is always a tough job. You did it brilliantly.
Caleb thank you for your presentation. I am working my way through and wanted to thank you.
this dude saved my grades bro thanks
This is exactly what I was looking for today!!😊
Tanmay are you single?
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
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
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
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!
I have MS MTA exam in a couple of days, finally got good tutorial worth watching. I can clear my DBMS/RDBMS basic.
Thanks for taking all of the time you put into this and sharing it, very much appreciated!
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
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!!
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.
The way that the teacher explain concepts is Amazing
I grade you as one of the greatest database instructor. what an opener and best database vivid explanation. I am impressed about your work.
Watching this at 1.5 speed is perfect. Also, this guy seems like the friend everyone needs but only some deserve.
Plowing through this for work. Caleb you're a hero.
Thank you to whoever took their time and added in the video chapters. 🙏
8 hours? Holy sweet Mercy. I ain't sleepin.
not if you run it a 1.25 or 1.5 speed
speed it up to 1.5.
I can feel the knowledge
are flowing inside my brain
8 hour and no ads. Respect
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 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 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 like the way of your teaching in this video. It helps me to understand easily the database fundamental theory. Thank you!
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
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!
The best course ever, I will watch the others videos too. Great explaining skills and personality, I love it.
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.
Caleb is a legend.
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 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 ?
Thoroughly enjoying this thanks so much... nothing like going down to the basics to give clear eyed view of stuff
I love the sound effects while erasing the blackboard. Please keep'em coming.
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
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 🤗🤗🤗
man i have been following you for sometime now am glad that you also made this great beginner course. thanks a lot
That's it, the fully completed database course... no BS... Thanks mate!
I love this guy, fantastic explanation for someone trying to learn this stuff in order to understand how to get started implementing db design.
Huuuuuuge thanks! Learned a Lot! Thank's to You I was able to start my project and excel at it!
Please consider adding more code exaples, like table creation and FOREIGN KEY assignment..
Did you say excel?? That's not a database. It's a spreadsheet. LoL. Gotcha!!
@@bruderjr you know excel is a word in English?
Best database course I've watched. Great teacher 👍
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
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?
Thank u for this awesome video
Just what I need right now! Thank you!
Love the "By His stripes we are healed t-shirt'. God bless you bro. Thanks for the amazing lessons, from Ireland.
Respect for this long very nice powerful information Video ... Thank you
Sir your are awesome
I think the only thing people need from youtube is the youtube learning certificate - this is a good class.
Thank you very much for this all in one course :)
Want to know what to learn next? Learn SQL: czcams.com/video/HXV3zeQKqGY/video.html
please add automatic subtitle
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.
Awesome! Have watched this on a single day without getting bored.
You rock Caleb! Thanks for sharing your knowledge!
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 (:
You're hella funny bro lol. Loved the lecture! You really make it easy to understand. Cheers!
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?
Thanx for this course buddy!!
Just completed it through a week!
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