Database Design

Database Design

Caleb Curry via YouTube Direct link

Database Design 24 - Primary Key and Alternate Key

26 of 52

26 of 52

Database Design 24 - Primary Key and Alternate Key

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Database Design

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

  1. 1 Database Design All-in-One Tutorial Series (8 HOURS!)
  2. 2 Database Design - Introduction
  3. 3 Database Design 1 - What is a Database?
  4. 4 Database Design 2 - What is a Relational Database?
  5. 5 Database Design 3 - RDBMS
  6. 6 Database Design 4 - Introduction to SQL
  7. 7 Database Design 5 - Naming Conventions
  8. 8 Database Design 6 - What is Database Design?
  9. 9 Database Design 7 - Data Integrity
  10. 10 Database Design 8 - Database Terms
  11. 11 Database Design 9 - More Database Terms
  12. 12 Database Design 10 - Atomic Values
  13. 13 Database Design 11 - Relationships
  14. 14 Database Design 12 - One-to-One Relationships
  15. 15 Database Design 13 - One-to-Many Relationships
  16. 16 Database Design 14 - Many-to-Many Relationships
  17. 17 Database Design 15 - Designing One-to-One Relationships
  18. 18 Database Design 16 - Designing One-to-Many Relationships
  19. 19 Database Design 17 - Parent Tables and Child Tables
  20. 20 Database Design 18 - Designing Many-to-Many Relationships
  21. 21 Database Design 19 - Summary of Relationships
  22. 22 Database Design 20 - Introduction to Keys
  23. 23 Database Design 21 - Primary Key Index
  24. 24 Database Design 22 - Look up Table
  25. 25 Database Design 23 - Superkey and Candidate Key
  26. 26 Database Design 24 - Primary Key and Alternate Key
  27. 27 Database Design 25 - Surrogate Key and Natural Key
  28. 28 Database Design 26 - Should I use Surrogate Keys or Natural Keys?
  29. 29 Database Design 27 - Foreign Key
  30. 30 Database Design 28 - NOT NULL Foreign Key
  31. 31 Database Design 29 - Foreign Key Constraints
  32. 32 Database Design 30 - Simple Key, Composite Key, Compound Key
  33. 33 Database Design 31 - Review and Key Points....HA GET IT? KEY points!
  34. 34 Database Design 32 - Introduction to Entity Relationship Modeling
  35. 35 Database Design 33 - Cardinality
  36. 36 Database Design 34 - Modality
  37. 37 Database Design 35 - Introduction to Database Normalization
  38. 38 Database Design 36 - 1NF (First Normal Form of Database Normalization)
  39. 39 Database Design 37 - 2NF (Second Normal Form of Database Normalization)
  40. 40 Database Design 38 - 3NF (Third Normal Form of Database Normalization)
  41. 41 Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index)
  42. 42 Database Design 40 - Data Types
  43. 43 Database Design 41 - Introduction to Joins
  44. 44 Database Design 42 - Inner Join
  45. 45 Database Design 43 - Inner Join on 3 Tables
  46. 46 Database Design 44 - Inner Join on 3 Tables (Example)
  47. 47 Database Design 45 - Introduction to Outer Joins
  48. 48 Database Design 46 - Right Outer Join
  49. 49 Database Design 47 - JOIN with NOT NULL Columns
  50. 50 Database Design 48 - Outer Join Across 3 Tables
  51. 51 Database Design 49 - Alias
  52. 52 Database Design 50 - Self Join

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.