Coursera Plus Annual is 40% Off — Ends July 13.

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

Lead AI-Native Products with Microsoft's Agentic AI Program

Learn More → Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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.