Share Description
In this course, you will learn:
- Developers frequently plunge in without taking the time to master the foundations of the technology they use. Unfortunately, basic database design serves as an excellent example of this. Let us fix this. Step by step, I'll walk you through the techniques and lingo you've been wanting to learn for years.
Syllabus:
1. Setup
- The Example MySQL Database
2. Keys
- Primary and Foreign Keys
- Foreign Key Constraints
- Laravel and Foreign Key Constraints
3. Joins
- The Difference Between MySQL Join Types
- Group Results With Aggregate Functions
- Multiple Joins in One Query
- Filtering Aggregated Data
4. Relationships
- One-to-One
- One-to-Many
- Many-to-Many
- Use Unique Keys to Avoid Duplication
5. 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
6. Exercises
- Fetch the Most Popular Authors
- Determine the Average Rentals Per Day
