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.

⭐️ 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

--

[codebreakthrough]

I'm honored to be featured here 🙂

⭐ 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

[andreaho]

This channel should be nominated for an educational Nobel prize.

[ObaidurRehmanX]

I enjoyed watching 8 hours without getting bored, and even reversing. This guy has teaching skills, naturally. Loved the lecture as well as the teaching style!

[agamenon]

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.

[tesfaysimon]

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

[williamjamesrapp]

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.

[taeesavage]

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!

[shahodanyali]

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

[mjshaheed]

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

[MarioZamoraMusic]

This series was amazing!!! Thanks so much Caleb. I've been able to design a few databases because of this and I feel so confident! So thankful I found your course :)

[burhanuddinmerchant]

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

[joslynnehill]

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

[davidschreiter]

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

[shsrpec]

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

[mitchell]

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.

[allisonbramhall]

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.

[mostafa]

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

[drop_messages]

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

[LilDad]

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

[shelleybrent-charette]

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!