MySQL Database Design
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.
Series episodes
Keys (3)
Primary and Foreign Keys
6m 31sUnderstand primary and foreign keys in databases—how unique identifiers and references link tables to keep your data organized and connected effortlessly.
Foreign Key Constraints
13m 9sProtect your database integrity by learning how foreign key constraints prevent orphaned records and keep your data accurate and reliable.
Laravel and Foreign Key Constraints
6m 6sLearn how to define foreign key constraints in Laravel migrations to enforce relationships and keep your database consistent. Build stronger apps with ease!
Joins (4)
The Difference Between MySQL Join Types
5m 35sConfused by MySQL join types? Learn the differences between Inner, Outer, Left, and Right Joins with clear examples to master database queries fast!
Group Results With Aggregate Functions
7m 13sLearn to group results using MySQL aggregate functions and GROUP BY to answer real-world questions like how many movies each user rented. Boost your query skills!
Multiple Joins in One Query
7m 12sLearn how to join multiple tables in one query with LEFT JOINs and explore subqueries. Simplify complex SQL in Laravel and level up your database skills!
Filtering Aggregated Data
5m 41sDiscover how to filter aggregated data in Laravel by finding top profitable movies and narrowing results with smart, practical queries. Boost your data skills today!
Relationships (4)
One-to-One
7m 59sLearn one-to-one relationships in Laravel with simple examples like users and profiles. Easily connect single records across tables and level up your database skills!
One-to-Many
4m 2sMaster one-to-many relationships in Laravel with clear examples like users, posts, and comments. Learn how to connect data effortlessly and boost your skills!
Many-to-Many
9m 47sLearn how to master many-to-many relationships in Laravel with clear examples using posts and tags. Simplify complex database links today!
Use Unique Keys to Avoid Duplication
3m 57sLearn how to use unique keys to prevent duplicate post-tag records in many-to-many relationships and keep your database clean and reliable.
Indexing (3)
Apply an Index to Drastically Improve Performance
5m 49sMaster database indexing with clear examples that show when and how to apply indexes to boost your query performance and speed up your apps.
Reduce a Query From 12 Seconds to 1 Millisecond
6m 46sLearn how to optimize your queries and slash execution time from 12 seconds to 1 millisecond by mastering indexing and smart query tweaks in this tutorial.
MySQL Automatically Creates an Index for Foreign Keys
3m 1sDiscover how MySQL automatically creates indexes for foreign keys to boost query performance—essential knowledge for optimizing your database design.
Exercises (2)
Fetch the Most Popular Authors
4m 1sLearn how to write a SQL query to fetch the top 10 most popular authors in your blog—perfect for rewarding your best writers with bonuses.
Determine the Average Rentals Per Day
2m 53sCalculate the average daily movie rentals using the Sakila database in this hands-on episode—perfect for mastering real-world Laravel data queries.
