MySQL Class

MySQL CONTANT

• 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