retail_academy · self-paced

Staging to Signal

A full MySQL course built around one real workflow: take a messy raw export, clean it, load it into a normalized production schema, and turn it into an EDA report a manager would read.

0 / 11 modules

Active database

SQLite vs. MySQL, quick notes

This console runs SQLite (the only SQL engine that runs entirely in a browser). Everything from Modules 1–6 and most of 7–8 runs unchanged.
STR_TO_DATE / DATE_FORMAT don't exist — use date() / strftime().
ON DUPLICATE KEY UPDATE → INSERT ... ON CONFLICT(col) DO UPDATE SET ...
AUTO_INCREMENT → INTEGER PRIMARY KEY AUTOINCREMENT; ENUM(...) → TEXT CHECK(col IN (...))
No stored procedures (Module 9) — those need real MySQL. Triggers and CTEs both work here.
Your queries persist in this browser between visits. Nothing leaves your machine.

Loading SQL engine…