MySQL Tutorial courses Content MySQL Introduction MySQL Installation and Setup Database and Table Management MySQL Data Types MySQL CREATE DATABASE MySQL DROP DATABASE MySQL CREATE TABLE MySQL DROP TABLE MySQL ALTER TABLE Basic Data Manipulation MySQL INSERT INTO MySQL SELECT Statement MySQL WHERE Clause MySQL AND, OR, NOT Operators MySQL ORDER BY MySQL LIMIT MySQL UPDATE Statement MySQL DELETE Statement MySQL TRUNCATE TABLE Data Integrity, Constraints & Indexing MySQL DISTINCT MySQL Constraints MySQL NOT NULL Constraint MySQL UNIQUE Constraint MySQL PRIMARY KEY MySQL FOREIGN KEY MySQL DEFAULT Constraint MySQL CHECK Constraint MySQL AUTO_INCREMENT MySQL Indexes MySQL DISTINCT Keyword MySQL Aliases (AS) Grouping, Aggregates & Pattern Matching MySQL Aggregate Functions MySQL GROUP BY MySQL HAVING Clause MySQL LIKE Operator MySQL IN Operator MySQL BETWEEN Operator MySQL IS NULL and IS NOT NULL Joins, Unions & Subqueries MySQL JOINS Overview MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL CROSS JOIN MySQL Self JOIN MySQL UNION Operator MySQL Subqueries MySQL EXISTS Operator MySQL ANY and ALL Operators Built-in Functions & Conditional Logic MySQL String Functions MySQL Numeric Functions MySQL Date and Time Functions MySQL CASE Expression MySQL IFNULL and COALESCE Advanced Features & Administration MySQL Views MySQL Stored Procedures MySQL Stored Functions MySQL Triggers MySQL Cursors MySQL Transactions MySQL COMMIT and ROLLBACK MySQL SAVEPOINT MySQL User Management MySQL GRANT and REVOKE MySQL Backup and Restore MySQL Import and Export Data MySQL Performance Optimization MySQL EXPLAIN Statement MySQL Normalization MySQL Window Functions MySQL Common Table Expressions (CTE) MySQL Recursive Queries MySQL JSON Support
