Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Database design is the organization of data according to a database model. The designer determines what data needs to be stored and how the data elements relate to each other. With this information, he or she 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/
️ Content
️ (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-on-one relationships
️ (1:53:45) One-to-many relationships
️ (1:57:50) Many-to-many relationships
️ (2:02:24) Creating 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 the keys
️ (3:07:24) Primary key index
️ (3:13:42) Lookup table
️ (3:30:19) Superkeys and candidate keys
️ (3:48:59) Primary key and alternate key
️ (3:56:34) Replacement 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, compound key, compound key
️ (5:01:54) Review and key points… HA, GOT IT? THE MOST IMPORTANT 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) AKA
️ (7:52:13) Join yourself
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 program for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.