MySQL Full Course - 2023

This beginner course teaches MySQL and SQL for relational databases, from installation and table operations through queries, constraints, joins, views, indexes, stored procedures, and triggers. It uses MySQL Workbench and covers Windows and macOS installation.

Syllabus

#1 MySQL intro + installation
Windows installation
MAC OS installation
#2 DATABASES
#3 TABLES
#4 INSERT ROWS
#5 SELECT
#6 UPDATE & DELETE
#7 AUTOCOMMIT, COMMIT, ROLLBACK
#8 CURRENT_DATE & CURRENT_TIME
#9 UNIQUE
#10 NOT NULL
#11 CHECK
#12 DEFAULT
#13 PRIMARY KEYS
#14 AUTO_INCREMENT
#15 FOREIGN KEYS
#16 JOINS
#17 FUNCTIONS
#18 AND, OR, NOT
#19 WILD CARDS
#20 ORDER BY
#21 LIMIT
#22 UNIONS
#23 SELF JOINS
#24 VIEWS
#25 INDEXES
#26 SUBQUERIES
#27 GROUP BY
#28 ROLLUP
#29 ON DELETE
#30 STORED PROCEDURES
#31 TRIGGERS