MySQL Tutorial for Beginners (Bro Code)

Bro Code's MySQL playlist, 31 short lessons and about 3 hours, a quick hands-on route into relational databases. After installing MySQL it creates a database and tables, then inserts, selects, updates and deletes rows, and explains autocommit, commit and rollback, and date and time functions. Constraints get their own lessons: UNIQUE, NOT NULL, CHECK, DEFAULT, primary keys, AUTO_INCREMENT and foreign keys. It then covers joins, built-in functions, logical operators, wildcards, ORDER BY, LIMIT, UNION, self joins, views, indexes, subqueries, GROUP BY and ROLLUP, ON DELETE behaviour, stored procedures and triggers. It suits students and junior web developers who want working SQL quickly, for example before building PHP or Node back ends.