masters in mysql
masters in mysql
(popular database)
(popular database)
Duration: 1 month
Topics Covered:
MySQL Introduction
MySQL Installation & Workbench
MySQL Create Table
MySQL Insert
MySQL INSERT Multiple
MySQL Constraints
MySQL SELECT & WHERE
MySQL AND, OR, NOT
MySQL IN & NOT IN
MySQL BETWEEN & NOT BETWEEN
MySQL LIKE Operator & Wildcards
MySQL Regular Expression
MySQL ORDER BY & DISTINCT
MySQL IS NULL & IS NOT NULL
MySQL LIMIT & OFFSET
MySQL Count, Sum, Min, Max, Avg
MySQL UPDATE
MySQL COMMIT & ROLLBACK
MySQL DELETE
MySQL PRIMARY KEY & FOREIGN KEY
MySQL INNER JOIN
MySQL LEFT JOIN & RIGHT JOIN
MySQL CROSS JOIN
MySQL GROUP BY & HAVING
MySQL SubQuery
MySQL UNION & UNION ALL
MySQL ALTER
MySQL DROP & TRUNCATE
MySQL VIEW