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