MySQL Database Design

Go to class

Write Review

MySQL Database Design provided by Laracasts is a comprehensive online course, which lasts for 1-2 hours worth of material. MySQL Database Design is taught by Jeffrey Way. Upon completion of the course, you can receive an e-certificate from Laracasts. The course is taught in Englishand is Paid Course. Visit the course page at Laracasts for detailed price information.

via Laracasts

1-2 hours worth of material

Self Paced

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

- The Example MySQL Database
- Primary and Foreign Keys
- Foreign Key Constraints
- Laravel and Foreign Key Constraints
- The Difference Between MySQL Join Types
- Group Results With Aggregate Functions
- Multiple Joins in One Query
- Filtering Aggregated Data
- One-to-One
- One-to-Many
- Many-to-Many
- Use Unique Keys to Avoid Duplication
- Apply an Index to Drastically Improve Performance
- Reduce a Query From 12 Seconds to 1 Millisecond
- MySQL Automatically Creates an Index for Foreign Keys
- Fetch the Most Popular Authors
- Determine the Average Rentals Per Day

0, based on 0 Course votes at GetYourEducation

Start your review of MySQL Database Design

Add review ->

Language

English
Date of Start
30th December, 2022
Level
Beginner
Price
Paid Course
Provider
Laracasts
Taught By

Jeffrey Way
Share this course

MySQL Database Design

3D Wooden Textiles for Beginners

Digital Brand Strategy: Elevate The User Experience

Flavorful Food Illustration with Watercolor

FPGA computing systems: Background knowledge and introductory materials

Freehand Sketching with Acrylic and Watercolor

Fundamentals of the Chinese character writing. Part 2