Database Design Course for beginners

  Last Update - 2023-06-07

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 

 

 

Brijesh Patel

Share on Facebook Twitter LinkedIn