Data Integrity Demystified
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Syllabus
Intro
Session Evaluation
Data Integrity
What Does It Mean???
Why Does This Matter?
Data Storage & Data Engines
How Do Data Storage & Data Engine Create Integrity?
Naming Convention Examples
How Do Naming Conventions Create Integrity?
Different Types of Integrity
How Does Relational Database Design Create Integrity?
Primary key Constraint
Tip: Identify the Primary key Column(s)
How do Surrogate Primary Keys Create Integrity?
Unique Key Constraint
Foreign Key Constraint
Foreign Key Example
How Do Data Types Create Integrity?
How Does NOT NULL Create Integrity?
How Do Default Constraint Create Integrity?
How Do Check Constraints Create Integrity?
Clustered index: Integrity or Performance
Integrity Used By the Query Optimizer
Taught by
PASS Data Community Summit
Related Courses
Cryptography IStanford University via Coursera MongoDB Advanced Deployment and Operations
MongoDB University Developing SQL Databases
Microsoft via edX Six Sigma Tools for Define and Measure
University System of Georgia via Coursera Using clinical health data for better healthcare
The University of Sydney via Coursera