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.
Overview
Syllabus
- 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
Taught by
Jeffrey Way