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.

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