• رقم الدرس : 06
  • 00:06:57

  • Database Design 4 - Introduction to SQL

  • تشغيل

دروس الكورس

  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