Learning MySQL Development

Common Database Terms Database Best Practices Advantages And Disadvantages Of MySQL Exploring MySQL Workbench MySQL Data Types – Part 1 MySQL Data Types – Part 2

Create A Database Create A Table Use CREATE And ALTER To Define A Table Primary Keys And Foreign Keys Display Database Relationships With Reverse Engineering Load Bulk Data Challenge – Explore The Built-In Databases Solution – Explore The Built-In Databases

The Basics Of SELECT Refine SELECT Queries Filter Results With WHERE

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

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 Level Up Your MySQL Knowledge