Getting Started
Select
Select and filter
Less than and greater than
Less than and greater than with equal to
Comments
AND & OR
BETWEEN & NOT BETWEEN
IN & NOT IN
NULL value
LIKE value
NOT LIKE value
DISTINCT operator
Select specific column
COUNT operator
AS operator
COUNT & DISTINCT
SUM and AVG
MAX and MIN
Select multiple data
ORDER BY
ORDER BY - Ascending and Descending
ORDER BY - More use cases
LIMIT
LIMIT with ordering and offset
Using LENGTH
Date functions
Arithmetic - Operations on columns
Arithmetic - Filtering and Ordering
Selecting modified data from rows
Combining data from columns
Handling NULL
GROUP BY - with COUNT
GROUP BY - with other aggregate functions
GROUP BY - more use cases
GROUP BY - multiple columns
GROUP BY - GROUP_CONCAT
JOINS - INNER JOIN
JOINS - OUTER JOIN
JOINS - SELF JOIN
JOINS - Multiple tables
JOINS - Filtering and Ordering
JOINS - Grouping
JOINS - Complex grouping
JOINS - Cartesian Product
UNION
INTERSECT and EXCEPT
Subqueries
Subqueries in FROM clause
Correlated subqueries
Subqueries - EXISTS operator
Creating tables
Inserting data in tables
Executing multiple statements
Column constraints - NOT NULL and UNIQUE
Column constraints - DEFAULT and CHECK
Table constraints - PRIMARY KEY
PRIMARY KEY - AUTOINCREMENT
Table constraints - FOREIGN KEY
Updating data in tables
Deleting data from tables
Adding and updating columns
Renaming and deleting tables
SQL statements with subqueries
VIEWS