MySQL Database Design

Developers often dive in without taking the necessary time to learn the fundamentals of the technologies they're using. Basic database design is a perfect example of this, unfortunately. Let's fix this. Step by step, I'll introduce you to the techniques and jargon that you've been meaning to learn for years now.

• Setup
• The Example MySQL Database
• Keys
• Primary and Foreign Keys
• Foreign Key Constraints
• Laravel and Foreign Key Constraints
• Joins
• The Difference Between MySQL Join Types
• Group Results With Aggregate Functions
• Multiple Joins in One Query
• Filtering Aggregated Data
• Relationships
• One-to-One
• One-to-Many
• Many-to-Many
• Use Unique Keys to Avoid Duplication
• Indexing
• Apply an Index to Drastically Improve Performance
• Reduce a Query From 12 Seconds to 1 Millisecond
• MySQL Automatically Creates an Index for Foreign Keys
• Exercises
• Fetch the Most Popular Authors
• Determine the Average Rentals Per Day