Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Laracasts

MySQL Database Design

via Laracasts

Overview

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.

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

Reviews

Start your review of MySQL Database Design

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.