MySQL 2017

Overview

Dive into a comprehensive 6-hour MySQL tutorial series covering essential concepts from installation to advanced data types. Begin with an introduction to MySQL and its installation process, then explore the MySQL Workbench interface. Learn crucial database terminology, understand various relationship types (one-to-one, one-to-many, many-to-many), and grasp integrity concepts. Discover the importance of primary and foreign keys, auto-increment functionality, and ON DELETE/UPDATE clauses. Delve into database normalization principles, including 1NF, 2NF, and 3NF. Explore a wide range of data types such as CHAR, VARCHAR, TEXT, ENUM, SET, INT, DECIMAL, FLOAT, DOUBLE, and date/time types. Conclude with a quick 3-hour recap of all concepts covered in the series.

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!).