Database Design Course – Learn how to design and plan a database for beginners
August 14, 2024 2024-08-14 10:02Database Design Course – Learn how to design and plan a database for beginners
Database Design Course – Learn how to design and plan a database for beginners
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: https://www.calebcurry.com/freecodecamp-database-design-full-course/
⭐️ 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 YouTube channel: https://www.youtube.com/user/CalebTheVideoMaker2
🐦Follow Caleb on Twitter: https://twitter.com/calebcurry
—
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org
source
Comments (43)
@codebreakthrough
I'm honored to be featured here 🙂
If you'd like to be notified of new content from me, please join my newsletter! https://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
@themevrouwdewi
8 hours of free database content! It was all so new for me despite having the CompTIA trifecta, which I think is weird imo. Hope I pass my database exam tomorrow 🙂
@Muhammad.Kashif31
Atlast, I have completely watched the video!
@NeneThe129
This course is a gem, thanks! I learned no so much, very easy to understand and follow.
@Whisper-i3k
Caleb thank you so much for the clear explanations and the jokes in between. You,re a great great teacher!
@lifemomentums
I am enjoying the simplicity of the tutorial in basic concepts and examples well done, though at the same time, I keep hoping that he must have now much better board to write on, like a white board e.g.
@more-uv4nl
heyyy im left handed toooo yeeeeeee
@ahmedahmedabdalmaksoud5977
For the One-To-One relationship example, ehm, actually a man can have multiple wifes in multiple countries and cultures🙃.
@drewxx8527
People who dislike this video must be an Atheist xD
@hellosi1706
Awesome video and really really entertaining instructor!
@nasimahmad9530
his way of teaching is so addictive that it did not even feel that i have completed the whole video in one 2 sitting
@thetasworld
6:37:14 From now on, I will refer to the tables I get after using JOIN as GRT (Grandma Readable Table).
@suvitsharma7432
I want to complete this course, just one question is this course still good considering its 8 yrs old?
@bouallaguiali2906
I experienced deja vu at 6:20
@joshsinger8
I may not give it to you, I may only spell it with you
@dboyedoe
Wait, this guy taught me how to mine Chia too 😂
@mitchellduncan7983
5:47:26 he finally pronounced “attribute” right, I was so surprised I had to replay it a few times to be sure
@okpeamaka5279
Thank you for this!
@sabihass5361
one of the best courses on this channel!
@migsy1
Man, I want to make a database, but I have no reason to 🙁
@antoniofuller2331
Jesus Christ
@rodinamohamed6372
when will it the turn to image processing ?
@hellzbellz272
Lefties unite ❤
@programacion3694
owo
@user-jm3bq8yl4r
thank you bro authentic video
@wadiibounenni4848
Thanks a lot for this tutorial
@pako4555
Watched. Done
@timmytesla9655
8 hours video on database design. This is gold.
@teachanything
This is 2024 . I watch this amazing video after 5 year
@data_science_with_deeshu
Old but gold, amazing Video.
@Anushkagupta_9119
Thank you so much❤
@rstack13
Thanks!
@user-lg8ck6yq9c
I love the video. It really helps.
I only struggle now at 5:45:20 I don't see why having a unique email_id would prevent from entering the email twice. Like he said before someone could insert an email into the input field separate it by comma and than enter another email. Would that problem not rest the same with the bigger user table and also with email table? Because the value or the insertion of the value was the issue no? Couldn't someone still enter two emails within the same table even we have know a separate email table?
I hope it is understandable haha.
Would be glad about an explanation 😀 Thank you !
But anyways everything is extremely well explained and entertained.
@JackHandy7385
I hope you learned how to properly pronounce "attribute" in the past 5 years 😀 Saying it like Atreyu from Neverending Story 😀
@Ali_vazife
that is really good, well done!
@SothearithKONGMrMuyKhmer
❤🎉
@youssefadel6374
– 4:04:50 we add an index to alternatives keys or the unique columns that could be used as a primary key to use them in searching later on if we need.
– 5:08:25 we should use either surgoate or natural key and stick with it for the entire database but we can switch between either simple, composite or compound key normaly.
@mathildaduku
Great video, detailed, easy to digest and fun to watch. Well done 👍
@dummyaccount5960
My Progress
Day 1 : 01:10:00
@adanos2006
i had a good time watching this video. great job. this is how educational materials should look like
@Headon2580
there is a simple misunderstanding of physical, logical, view (schema)
@Mari_Selalu_Berbuat_Kebaikan
Let's always do alot of good 🔥
@deepaksingh-qd7xm
1:51:12 : I think this should be many to many in todays world…… 😂😂😂😂