🗄️
MySQL Tutorial
MySQL is an open-source relational database management system used to store, query, and manage structured application data.
Goal Oriented
Every lesson is built around a practical goal to ensure you gain usable skills immediately.
Complete Reference
From basic tags to advanced APIs, we cover everything you need to become a pro.
Course Information
View Topic HubLessons
206
Duration
34h 20m
Level
All Levels
Certificate
Included
MySQL Course Syllabus
5 chapters · 206 lessons · 34h 20m
1. MySQL Fundamentals
31 lessons- MySQL Aggregate Functions10 min
- MySQL ALL Operator10 min
- MySQL Editors and Clients10 min
- MySQL MAX() Function10 min
- MySQL Built-in Functions Reference10 min
- MySQL Introduction10 min
- MySQL RDBMS Concepts10 min
- MySQL SQL Syntax10 min
- MySQL SELECT Statement10 min
- MySQL SELECT DISTINCT10 min
- MySQL WHERE Clause10 min
- MySQL ORDER BY Clause10 min
- MySQL AND Operator10 min
- MySQL OR Operator10 min
- MySQL NOT Operator10 min
- MySQL INSERT INTO10 min
- MySQL NULL Values10 min
- MySQL UPDATE Statement10 min
- MySQL DELETE Statement10 min
- MySQL LIMIT and OFFSET10 min
- MySQL MIN and MAX10 min
- MySQL COUNT() Function10 min
- MySQL SUM() Function10 min
- MySQL AVG() Function10 min
- MySQL LIKE Operator10 min
- MySQL Wildcards10 min
- MySQL IN Operator10 min
- MySQL BETWEEN Operator10 min
- MySQL Aliases (AS)10 min
- MySQL Comments10 min
- MySQL Operators10 min
2. MySQL Joins
15 lessons- MySQL Joins Overview10 min
- MySQL INNER JOIN10 min
- MySQL LEFT JOIN10 min
- MySQL RIGHT JOIN10 min
- MySQL CROSS JOIN10 min
- MySQL Self Join10 min
- MySQL GROUP BY10 min
- MySQL HAVING Clause10 min
- MySQL EXISTS Operator10 min
- MySQL ANY and ALL Operators10 min
- MySQL UNION Operator10 min
- MySQL UNION ALL10 min
- MySQL INSERT INTO SELECT10 min
- MySQL CASE Expression10 min
- MySQL IFNULL() and COALESCE()10 min
3. MySQL Management
7 lessons4. MySQL Advanced
15 lessons- MySQL Constraints10 min
- MySQL NOT NULL Constraint10 min
- MySQL UNIQUE Constraint10 min
- MySQL PRIMARY KEY10 min
- MySQL FOREIGN KEY10 min
- MySQL CHECK Constraint10 min
- MySQL DEFAULT Constraint10 min
- MySQL Indexes10 min
- MySQL AUTO_INCREMENT10 min
- MySQL Views10 min
- MySQL Stored Procedures10 min
- MySQL Prepared Statements10 min
- MySQL SQL Injection Prevention10 min
- Install MySQL on Windows10 min
- Install MySQL on Linux10 min
5. MySQL Functions
138 lessons- MySQL ASCII() Function10 min
- MySQL CHAR_LENGTH() Function10 min
- MySQL CHARACTER_LENGTH() Function10 min
- MySQL CONCAT() Function10 min
- MySQL CONCAT_WS() Function10 min
- MySQL FIELD() Function10 min
- MySQL FIND_IN_SET() Function10 min
- MySQL FORMAT() Function10 min
- MySQL INSERT() Function10 min
- MySQL INSTR() Function10 min
- MySQL LCASE() Function10 min
- MySQL LEFT() Function10 min
- MySQL LENGTH() Function10 min
- MySQL LOCATE() Function10 min
- MySQL LOWER() Function10 min
- MySQL LPAD() Function10 min
- MySQL LTRIM() Function10 min
- MySQL MID() Function10 min
- MySQL POSITION() Function10 min
- MySQL REPEAT() Function10 min
- MySQL REPLACE() Function10 min
- MySQL REVERSE() Function10 min
- MySQL RIGHT() Function10 min
- MySQL RPAD() Function10 min
- MySQL RTRIM() Function10 min
- MySQL SPACE() Function10 min
- MySQL STRCMP() Function10 min
- MySQL SUBSTR() Function10 min
- MySQL SUBSTRING() Function10 min
- MySQL SUBSTRING_INDEX() Function10 min
- MySQL TRIM() Function10 min
- MySQL UCASE() Function10 min
- MySQL UPPER() Function10 min
- MySQL ABS() Function10 min
- MySQL ACOS() Function10 min
- MySQL ASIN() Function10 min
- MySQL ATAN() Function10 min
- MySQL ATAN2() Function10 min
- MySQL AVG() Function10 min
- MySQL CEIL() Function10 min
- MySQL CEILING() Function10 min
- MySQL COS() Function10 min
- MySQL COT() Function10 min
- MySQL COUNT() Function10 min
- MySQL DEGREES() Function10 min
- MySQL DIV Operator10 min
- MySQL EXP() Function10 min
- MySQL FLOOR() Function10 min
- MySQL GREATEST() Function10 min
- MySQL LEAST() Function10 min
- MySQL LN() Function10 min
- MySQL LOG() Function10 min
- MySQL LOG10() Function10 min
- MySQL LOG2() Function10 min
- MySQL MAX() Function10 min
- MySQL MIN() Function10 min
- MySQL MOD() Function10 min
- MySQL PI() Function10 min
- MySQL POW() Function10 min
- MySQL POWER() Function10 min
- MySQL RADIANS() Function10 min
- MySQL RAND() Function10 min
- MySQL ROUND() Function10 min
- MySQL SIGN() Function10 min
- MySQL SIN() Function10 min
- MySQL SQRT() Function10 min
- MySQL SUM() Function10 min
- MySQL TAN() Function10 min
- MySQL TRUNCATE() Function10 min
- MySQL ADDDATE() Function10 min
- MySQL ADDTIME() Function10 min
- MySQL CURDATE() Function10 min
- MySQL CURRENT_DATE() Function10 min
- MySQL CURRENT_TIME() Function10 min
- MySQL CURRENT_TIMESTAMP() Function10 min
- MySQL CURTIME() Function10 min
- MySQL DATE() Function10 min
- MySQL DATEDIFF() Function10 min
- MySQL DATE_ADD() Function10 min
- MySQL DATE_FORMAT() Function10 min
- MySQL DATE_SUB() Function10 min
- MySQL DAY() Function10 min
- MySQL DAYNAME() Function10 min
- MySQL DAYOFMONTH() Function10 min
- MySQL DAYOFWEEK() Function10 min
- MySQL DAYOFYEAR() Function10 min
- MySQL EXTRACT() Function10 min
- MySQL FROM_DAYS() Function10 min
- MySQL HOUR() Function10 min
- MySQL LAST_DAY() Function10 min
- MySQL LOCALTIME() Function10 min
- MySQL LOCALTIMESTAMP() Function10 min
- MySQL MAKEDATE() Function10 min
- MySQL MAKETIME() Function10 min
- MySQL MICROSECOND() Function10 min
- MySQL MINUTE() Function10 min
- MySQL MONTH() Function10 min
- MySQL MONTHNAME() Function10 min
- MySQL NOW() Function10 min
- MySQL PERIOD_ADD() Function10 min
- MySQL PERIOD_DIFF() Function10 min
- MySQL QUARTER() Function10 min
- MySQL SECOND() Function10 min
- MySQL SEC_TO_TIME() Function10 min
- MySQL STR_TO_DATE() Function10 min
- MySQL SUBDATE() Function10 min
- MySQL SUBTIME() Function10 min
- MySQL SYSDATE() Function10 min
- MySQL TIME() Function10 min
- MySQL TIME_FORMAT() Function10 min
- MySQL TIME_TO_SEC() Function10 min
- MySQL TIMEDIFF() Function10 min
- MySQL TIMESTAMP() Function10 min
- MySQL TO_DAYS() Function10 min
- MySQL WEEK() Function10 min
- MySQL WEEKDAY() Function10 min
- MySQL WEEKOFYEAR() Function10 min
- MySQL YEAR() Function10 min
- MySQL YEARWEEK() Function10 min
- MySQL BIN() Function10 min
- MySQL BINARY Operator10 min
- MySQL CASE Expression10 min
- MySQL CAST() Function10 min
- MySQL COALESCE() Function10 min
- MySQL CONNECTION_ID() Function10 min
- MySQL CONV() Function10 min
- MySQL CONVERT() Function10 min
- MySQL CURRENT_USER() Function10 min
- MySQL DATABASE() Function10 min
- MySQL IF() Function10 min
- MySQL IFNULL() Function10 min
- MySQL ISNULL() Function10 min
- MySQL LAST_INSERT_ID() Function10 min
- MySQL NULLIF() Function10 min
- MySQL SESSION_USER() Function10 min
- MySQL SYSTEM_USER() Function10 min
- MySQL USER() Function10 min
- MySQL VERSION() Function10 min