Database

MySQL — Relational Databases

Store and query structured data with SQL — the language of relational databases behind most of the world’s applications.

13 lessons5 chaptersStart: What is a Relational Database? →

1Database Basics

What is a Relational Database?30 min Setting Up MySQL & phpMyAdmin25 min Creating Databases & Tables35 min

2CRUD with SQL

INSERT — Adding Data25 min SELECT — Reading Data35 min WHERE — Filtering35 min UPDATE & DELETE30 min

3Querying Data

ORDER BY & LIMIT25 min LIKE, IN & Aggregate Functions35 min JOINs — Combining Tables40 min

4Database Design

Keys & Relationships30 min Normalization Basics30 min

5Projects

Project: Design & Query a Database120 min