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

/learn-sql/getting-started/all-you-need-is-a-working-internet-connection

BigBinary Academy