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

Go to class Write review
Scrimba Ad

Our career paths help you become job ready faster

Learn More → Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.