Learning MySQL Development (2020)

Exploring MySQL Workbench MySQL Data Types, Part 1 MySQL Data Types, Part 2 Challenge – Explore The Built-In Databases Solution – Explore The Built-In Databases

Create A Database Create A Table Use CREATE And ALTER To Define A Table Primary Keys And Foreign Keys Load Bulk Data Challenge – Create Normalized Movies Table Solution – Create Normalized Movies Table

The Basics Of SELECT Refine SELECT Queries Filter Results With WHERE Display Data With CASE Challenge – Filter Movies By Score Solution – Filter Movies By Score

Add Data To Tables With INSERT Update Existing Rows With UPDATE Remove Data With DELETE Challenge – Clean Up The Movies Solution – Clean Up The Movies

The Basics Of JOIN Match Fields With INNER JOIN Match All Fields With Outer Joins Challenge – Find The Best Film Solution – Find The Best Film