Data Integrity Demystified

Data Integrity Demystified

PASS Data Community Summit via YouTube Direct link

Tip: Identify the Primary key Column(s)

13 of 23

13 of 23

Tip: Identify the Primary key Column(s)

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Data Integrity Demystified

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

  1. 1 Intro
  2. 2 Session Evaluation
  3. 3 Data Integrity
  4. 4 What Does It Mean???
  5. 5 Why Does This Matter?
  6. 6 Data Storage & Data Engines
  7. 7 How Do Data Storage & Data Engine Create Integrity?
  8. 8 Naming Convention Examples
  9. 9 How Do Naming Conventions Create Integrity?
  10. 10 Different Types of Integrity
  11. 11 How Does Relational Database Design Create Integrity?
  12. 12 Primary key Constraint
  13. 13 Tip: Identify the Primary key Column(s)
  14. 14 How do Surrogate Primary Keys Create Integrity?
  15. 15 Unique Key Constraint
  16. 16 Foreign Key Constraint
  17. 17 Foreign Key Example
  18. 18 How Do Data Types Create Integrity?
  19. 19 How Does NOT NULL Create Integrity?
  20. 20 How Do Default Constraint Create Integrity?
  21. 21 How Do Check Constraints Create Integrity?
  22. 22 Clustered index: Integrity or Performance
  23. 23 Integrity Used By the Query Optimizer

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.