Database

MySQL — Relational Databases

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

27 lessons6 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 LEFT, RIGHT, SELF & Multi-Table JOINs40 min GROUP BY & HAVING35 min Subqueries & Nested SELECTs35 min Built-in Functions: Text, Numbers & Dates35 min

4Database Design

Keys & Relationships30 min Constraints & Picking Data Types40 min Normalization Basics30 min

5Going Deeper: Professional SQL

Views & CASE Expressions35 min Transactions: COMMIT, ROLLBACK & ACID35 min Stored Procedures & Functions40 min Indexes & Reading EXPLAIN35 min DISTINCT, UNION & GROUP_CONCAT30 min Window Functions: Ranking & Running Totals40 min Common Table Expressions (WITH) & Recursion35 min Triggers & Scheduled Events35 min Users, Privileges & Backups35 min

6Projects

Project: Design & Query a Database120 min