This course aims to teach students the fundamentals of MySQL, including database relationships, integrity, normalization, data types, and quick concepts. The course covers installing MySQL, using MySQL Workbench, and understanding key concepts like primary keys, foreign keys, and normalization. The teaching method includes lectures and practical examples. This course is designed for beginners who want to learn about MySQL and database management.
Overview
Syllabus
MySQL 1 - Intro to MySQL.
MySQL 2 - Installing MySQL.
MySQL 3 - MySQL Workbench.
MySQL 4 - Beginner Terms Part 1.
MySQL 5 - Beginner Terms Part 2.
MySQL 6 - Beginner Terms Part 3.
MySQL 7 - One-to-One Relationship.
MySQL 8 - One-to-Many Relationship.
MySQL 9 - Many-to-Many Relationship.
MySQL 10 - Summary of Relationships.
MySQL 11 - Entity Integrity.
MySQL 12 - Referential Integrity.
MySQL 13 - Domain Integrity.
MySQL 14 - Primary Key.
MySQL 15 - Auto Increment (AUTO_INCREMENT).
MySQL 16 - Foreign Key.
MySQL 17 - ON DELETE and ON UPDATE.
MySQL 18 - Intro to Normalization.
MySQL 19 - 1NF.
MySQL 20 - 2NF.
MySQL 21 - 3NF.
MySQL 22 - Normalization Summary.
MySQL 23 - Intro to Data Types.
MySQL 24 - Important Data Types.
MySQL 25 - CHAR Data Type.
MySQL 26 - VARCHAR Data Type.
MySQL 27 - TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT.
MySQL 28 - ENUM.
MySQL 29 - SET Data Type.
MySQL 30 - INT Data Type.
MySQL 31 - DECIMAL Data Type.
MySQL 32 - FLOAT and DOUBLE Data Types.
MySQL 33 - Datetime, Date, Time Data Types.
MySQL All-in-One Quick Concepts Tutorial Series (3 HOURS!).
Taught by
Caleb Curry
