Introduction

Installation & Workbench

Create Table

Insert

INSERT Multiple

Constraints

SELECT & WHERE

AND, OR, NOT

IN & NOT IN

BETWEEN & NOT BETWEEN

LIKE Operator & Wildcards

Regular Expression

ORDER BY & DISTINCT

IS NULL & IS NOT NULL

LIMIT & OFFSET

Count, Sum, Min, Max, Avg

UPDATE

COMMIT & ROLLBACK

DELETE

PRIMARY KEY & FOREIGN KEY

INNER JOIN

LEFT JOIN & RIGHT JOIN

CROSS JOIN

JOIN MULTIPLE TABLES

GROUP BY & HAVING

SubQuery with EXISTS & NOT EXISTS

UNION & UNION ALL

IF & CASE Statement

Arithmetic Functions

String Functions

String Functions - II

Date Functions

Date Functions - II

Time Functions

ALTER

DROP & TRUNCATE

VIEW

INDEX