CF

Learn Database Design with MySQL

6h 14m 51s
English
Paid
Updated September 2026

Learn Database Design with MySQL is a 31-lesson 6 hours 14 minutes self-paced course by O'Reilly Media. Good database design is the part of web development that's easy to skip and expensive to fix later.

Course facts

Lessons
31
Duration
6 hours 14 minutes
Level
All levels
Language
English
Updated
2026-09-11
Instructor
O'Reilly Media
Price
Premium

Good database design is the part of web development that's easy to skip and expensive to fix later. This course moves quickly through the fundamentals of MySQL, aimed squarely at beginners who want to understand what solid data storage actually looks like.

What's covered

  • An introduction to data storage concepts, storage engines, and installing MySQL
  • The database design process: normalization, structure mapping, keys, and junction tables
  • SQL and more advanced SQL for creating, manipulating, and managing data
  • Integrating PHP with MySQL to power dynamic, data-driven websites

By the end, you'll understand both the technology and the design thinking behind it – the combination that separates a database that scales cleanly from one that doesn't.

Who teaches Learn Database Design with MySQL? O'Reilly Media

O'Reilly Media thumbnail

O'Reilly Media is one of the oldest and most authoritative technical book publishers in software, founded in 1978 by Tim O'Reilly. The publisher has shaped the field's literature for over four decades — the animal books series anchored a generation of working developers' learning, and the modern O'Reilly Online Learning platform extends that catalog into video, live training, and interactive sandboxes.

The CourseFlix listing carries two O'Reilly titles: Learn Database Design with MySQL and Streaming Databases. The catalog represented here is a small slice of O'Reilly's broader library, which spans essentially every active technology track from foundational CS through emerging fields like AI engineering and platform engineering.

Material is paid; O'Reilly Online Learning runs on a monthly / annual subscription on the original platform. Courses are aimed at working professionals across software, IT, and adjacent technical disciplines.

What lessons are included in Learn Database Design with MySQL?

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 31 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Intro
All Course Lessons (31)
#Lesson TitleDurationAccess
1
Intro Demo
03:33
2
MySQL overview
09:00
3
Understanding data types
07:41
4
Understanding storage engines
08:29
5
What is a database?
11:07
6
Environment setup with Xampp
07:12
7
Linux installation
04:11
8
MySQL Workbench setup
10:38
9
PHPMyAdmin
13:14
10
Windows installation
10:37
11
Database design process
05:18
12
Map out structure
14:58
13
Principles & normalization
10:58
14
Create tables & columns
12:23
15
Importing & exporting
05:16
16
Junction tables
04:46
17
Relations & foreign keys
13:15
18
Aliases & joins
18:39
19
Basic select queries
14:45
20
Command line & inserting data
28:58
21
Updating & deleting data
09:06
22
Math & subqueries
09:43
23
Union, concat & count
11:18
24
Using group by
07:29
25
Using the IN clause
09:12
26
Insert data with PHP
29:20
27
PHP fundamentals
21:00
28
Select & display with PHP
16:55
29
Template & MySQL connect
19:03
30
Update & delete with PHP
22:58
31
Wrap up
03:49
Unlock unlimited learning

Get instant access to all 30 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

What courses are similar to Learn Database Design with MySQL?

More courses by O'Reilly Media

  • Streaming Databases thumbnailUpdated 2y ago

    Streaming Databases

    Real-time applications are becoming the norm. However, for the model to function properly, it is necessary to obtain data in real-time, process it on the fly.
    5/5

Frequently asked questions

What are the prerequisites for taking this course?
This course is designed for beginners, so there are no formal prerequisites. However, having a basic understanding of web programming and familiarity with PHP can be beneficial, as the course includes a section on integrating PHP with MySQL to develop dynamic web applications.
What projects or exercises will I work on during the course?
Throughout the course, you'll engage in exercises like mapping out database structures, creating tables and columns, and using junction tables to define relationships. You'll also practice importing and exporting data, writing SQL queries, and integrating PHP to manipulate databases, culminating in building data-driven web applications.
Who is the target audience for this course?
The course is aimed at beginners interested in learning database design using MySQL. It's particularly suitable for aspiring web developers who want to build efficient data storage systems and understand how to create and manage databases for dynamic websites.
How does this course compare in depth to other MySQL courses?
This course provides a comprehensive introduction to MySQL with a focus on database design principles such as normalization, keys, and structure mapping. It progresses from basic SQL to advanced techniques, making it suitable for beginners aiming to become proficient in both MySQL and database design.
What specific tools will I learn to use in this course?
You'll learn to use several tools and environments, including MySQL Workbench, PHPMyAdmin, and the command line for database manipulation. The course also covers environment setup with Xampp and installation processes for different operating systems.
What topics are not covered in this course?
While the course offers a broad overview of database design and MySQL, it does not cover non-SQL databases or advanced database administration topics. The focus remains on SQL, database design principles, and PHP integration rather than broader database management systems.
What is the time commitment required for this course?
The course consists of 31 lessons. While no specific runtime is provided, students should budget time for both video content and hands-on practice with exercises, especially in SQL scripting and PHP integration, to fully grasp the concepts and skills taught.