Relational Database Design - Full Course

Relational Database Design - Full Course

freeCodeCamp.org via freeCodeCamp Direct link

Foreign Keys in SQL

4 of 28

4 of 28

Foreign Keys in SQL

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Relational Database Design - Full Course

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Relational Databases for Beginners — Tables, Entities, Keys & SQL
  2. 2 SQL Filtering & Aggregation
  3. 3 SQL Table Commands
  4. 4 Foreign Keys in SQL
  5. 5 How SQL JOINs Work
  6. 6 How to learn SQL on your own
  7. 7 Database Design Goals
  8. 8 Database Design Lifecycle
  9. 9 From Real-World Ideas to Tables
  10. 10 Primary Key, Candidate Key, and Super Key
  11. 11 Don't Use the Wrong SQL String Type
  12. 12 The FLOAT Mistake That Crashed a Stock Exchange
  13. 13 SQL Date and Time Types Explained
  14. 14 Connecting Entities in an ER Diagram
  15. 15 One-to-One Relationships
  16. 16 One-to-Many Relationships
  17. 17 Many-to-Many Relationships
  18. 18 Strong vs Weak Entities
  19. 19 First Normal Form - Primary Keys and Atomic Values
  20. 20 Second Normal Form - Partial Keys and Functional Dependencies
  21. 21 Third Normal Form - Transitive Dependencies
  22. 22 The Untold Story of BCNF
  23. 23 Primary Key vs Unique Constraints
  24. 24 Foreign Key Constraints - ON DELETE & ON UPDATE
  25. 25 Other Constraints: NOT NULL, DEFAULT, and CHECK
  26. 26 Access Control, Hashing & Encryption
  27. 27 B-Tree vs Full-Text Indexes
  28. 28 Denormalization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.