Learn MySQL from the ground up in this comprehensive 3-hour video tutorial. Begin with installation instructions for both Windows and Mac OS, then dive into essential concepts like creating databases and tables, inserting and selecting data, and performing updates and deletions. Master advanced topics including autocommit, rollback, primary and foreign keys, joins, functions, and wildcards. Explore practical skills such as using ORDER BY, LIMIT, and UNION clauses, creating views and indexes, writing subqueries, and implementing stored procedures and triggers. Perfect for beginners, this course covers everything needed to become proficient in MySQL database management.
Overview
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
Taught by
Bro Code
