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
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired, 50% Off

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.