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.
Overview
Syllabus
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.
Taught by
Quentin Watt Tutorials
Related Courses
Reviews
5.0 rating, based on 1 Class Central review
-
"MySQL for Beginners" is a highly recommended course for anyone looking to become proficient in SQL for data analysis. It's well-structured, offers ample resources, and provides practical learning experience. I now feel well-equipped to apply SQL in my professional work. Kudos to the course creators!
