CF

Learn Database Design with MySQL

6h 14m 51s
English
Paid

Learn Database Design with MySQL is a 31-lesson 6 hours 14 minutes self-paced course by O'Reilly Media. Unlock the potential of database design with this comprehensive course on MySQL.

Course facts

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

Unlock the potential of database design with this comprehensive course on MySQL. Perfect for beginners, it swiftly covers fundamental topics, demonstrating what MySQL can offer. Database design is a crucial part of web programming, and successful data storage systems rely on effective design. To create exceptional databases, you must master both the technology and the design process, including normalization.

Course Overview

This course aims to turn you into a SQL power user. You’ll start with an introduction to data storage, followed by insights into different storage engines and essential tools. Discover the process of installing MySQL and the fundamentals of database design.

Database Design Process

Explore topics such as normalization, structure mapping, and the use of keys and junction tables. These are essential skills for crafting robust databases that are both effective and efficient.

SQL and Advanced SQL

The course progresses to cover SQL, equipping you with the ability to create, manipulate, and manage data. You’ll delve into advanced SQL techniques that will enhance your command over this powerful language.

Integrating PHP with MySQL

Learn how to integrate PHP with MySQL, a vital skill for those looking to develop dynamic web applications. This integration is key to creating sophisticated, data-driven websites.

Upon completing this course, you will emerge as a proficient database design guru, ready to tackle any web programming challenge with confidence.

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?

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.