Sorted:

MySQL ORDER BY: Sort Table Data

Creating Indexes in MySQL: A Beginner’s Guide

MySQL Backup & Restore Guide

SQL DELETE: Remove Database Data Safely

MySQL Triggers Explained

MySQL Locking: Optimistic vs Pessimistic

Insert Data in MySQL: Quick Guide

MySQL Date Range Query: BETWEEN Explained

MySQL MAX & MIN: Find Column Extremes

MySQL LEFT JOIN IS NULL: Find Non-Matching Records