MySQL for Beginners

Learn the fundamentals of MySQL in this comprehensive 2.5-hour tutorial series. Begin with an introduction to MySQL and progress through essential concepts such as primary keys, data selection, and filtering techniques. Master the use of SQL clauses like LIMIT, OFFSET, and ORDER BY, and explore advanced filtering with WHERE, AND, and OR operators. Discover how to use LIKE and wildcards for pattern matching, and learn to perform aggregate functions such as COUNT, SUM, and AVERAGE. Gain hands-on experience with data manipulation, including inserting, updating, and deleting rows. Delve into table management by creating, dropping, and altering tables. Finally, explore the power of joining tables, using aliases, and implementing foreign keys to establish relationships between data sets.

MySQL Beginner Tutorial 1 - Introduction to MySQL.
MySQL Tutorial 2 - Primary Keys.
MySQL tutorial 3 - Selecting stuff.
MySQL tutorial 4 - Limit, Offset and Ordering.
MySQL tutorial 5 - Using "Where".
MySQL tutorial 6 - Where, And, Or.
MySQL tutorial 7 - Like and Wildcards.
MySQL tutorial 8 - Where Not.
MySQL tutorial 9 - Count, Sum and Average.
MySQL tutorial 10 - Inserting a new row.
MySQL tutorial 11 - Update a row.
MySQL tutorial 12 - Deleting data.
MySQL tutorial 13 - Creating and dropping tables.
MySQL tutorial 14 - Altering tables.
MySQL tutorial 15 - joining 2 tables.
MySQL tutorial 16 - joining many tables.
MySQL tutorial 17 - Aliases.
MySQL tutorial 18 - Foreign Keys.