Introduction to Databases and Database Design
- Introduction
- What is a Database?
- What is a Relational Database?
- RDBMS
- Introduction to SQL
- Naming Conventions
- What is Database Design?
- Data Integrity
- Database Terms
- More Database Terms
- Atomic Values
Relationships
- Relationships
- One-to-One Relationships
- One-to-Many Relationships
- Many-to-Many Relationships
- Design One-to-One Relationships
- Designing One-to-Many Relationships
- Parent Tables and Child Tables
- Designing Many-to-Many Relationships
- Summary of Relationships
Keys
- Introduction to Keys
- Primary Key Index
- Look up Table
- Superkey and Candidate Key
- Primary Key and Alternate Key
- Surrogate Key and Natural Key
- Should I use Surrogate Keys or Natural Keys?
- Foreign Key
- NOT NULL Foreign Key
- Foreign Key Constraints
- Simple Key, Composite Key, Compound Key
- Review of Keys and Key Points
Introduction to Modeling
- Introduction to Entity Relationship Modeling
- Cardinality
- Modality
Introduction to Database Normalization
- Introduction to Database Normalization
- 1NF
- 2NF
- 3NF
- Indexes
- Data Types
Joins
- Introduction to Joins
- Inner Join
- Inner Join on 3+ Tables
- Inner Join on 3 Tables (Example)
Outer Joins
- Introduction to Outer Joins
- Right Outer Join
- JOIN with NOT NULL Columns
- Outer Join Across 3 Tables
- Alias
- Self Join
Resources
- Blog Posts
