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 JOIN MULTIPLE TABLES
MySQL GROUP BY & HAVING
MySQL SubQuery with EXISTS & NOT EXISTS
MySQL UNION & UNION ALL
MySQL IF & CASE Statement
MySQL Arithmetic Functions
MySQL String Functions
MySQL String Functions - II
MySQL Date Functions
MySQL Date Functions - II
MySQL Time Functions
MySQL ALTER
MySQL DROP & TRUNCATE
MySQL VIEW
MySQL INDEX
