Intermediate
MySQL
Learn MySQL from CLI to schema design. SQL basics, joins, indexes, transactions, stored procedures, EXPLAIN, and operations.
13 lessons6.8h hands-on11 languages
Start learning freeMySQL course13 lessons, in order
- 120 min
What is MySQL
Relational databaseHistory and Oracle ownershipMariaDB forkMySQL vs Postgres trade-offsInnoDB default engine - 225 min
The mysql CLI and First Commands
Mysql clientConnecting with -u and -pSHOW DATABASESUSESHOW TABLESDESCRIBE+2 - 330 min
Creating Databases and Tables
CREATE DATABASECharacter sets and collationCREATE TABLEPRIMARY KEYAUTO_INCREMENTNOT NULL+3 - 430 min
Data Types
INT and BIGINTDECIMAL vs FLOATVARCHAR vs TEXTBOOLEAN as TINYINTDATE vs DATETIME vs TIMESTAMPENUM+1 - 530 min
SELECT and WHERE
SELECT columnsWHEREAND and ORBETWEENINLIKE with % and _+3 - 635 min
Joins
INNER JOINLEFT JOINRIGHT JOINNo FULL OUTER JOINUNION workaroundSelf-join+1 - 730 min
Aggregates and Grouping
COUNTSUMAVGMIN and MAXGROUP BYHAVING+2 - 830 min
Indexes
B-tree indexCREATE INDEXMulti-column index left-prefix ruleUNIQUE indexFULLTEXT indexIndexes hurt write performance - 935 min
Transactions and Storage Engines
InnoDB vs MyISAMSTART TRANSACTIONCOMMITROLLBACKIsolation levelsREPEATABLE READ default+1 - 1035 min
Stored Procedures and Triggers
DELIMITERCREATE PROCEDUREIN and OUT parametersCALLCREATE TRIGGERBEFORE INSERT and AFTER UPDATE+1 - 1135 min
EXPLAIN and Query Tuning
EXPLAINType column (ALL, ref, range, eq_ref, const)Key and rows columnsEXPLAIN ANALYZE (MySQL 8+)Adding a missing indexSlow query log - 1225 min
mysqldump and Restore
MysqldumpRedirecting to .sqlRestoring with mysql client--single-transaction for InnoDB--no-data for schema only--all-databases - 1350 min
Capstone: Design an Ecommerce Schema
Foreign keysON DELETE behaviorIndexes on lookup columnsTransactional order creationEXPLAIN on a real query
Learn MySQL in your language
Every lesson, quiz, and tutor reply renders in your language. The AI tutor matches the language you ask in.
Learn MySQL in EnglishAprende MySQL en españolAprenda MySQL em portuguêsتعلّم MySQL بالعربيةMySQL را به فارسی یاد بگیریدApprenez MySQL en françaisMySQL हिन्दी में सीखें用中文学习 MySQLPelajari MySQL dalam bahasa IndonesiaИзучайте MySQL на русскомMySQL auf Deutsch lernen
