This course aims to teach beginners the fundamentals of MySQL. By the end of the course, students will be able to understand primary keys, select data, use various clauses like Where, And, Or, and Like, perform data manipulation operations such as inserting, updating, and deleting data, create and modify tables, and work with joins and foreign keys. The course duration is 2 hours and 30 minutes, and the teaching method includes tutorials covering each topic sequentially. This course is intended for individuals who are new to MySQL and want to learn the basics of database management.
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!
