SQL Learning

Learning SQL

Query Basics

Query Filtering

Operators Order By Like In Between Join Union Group By Having Case Distinct Exists Any, All Ifnull Null Values Aliases

Functions

Aggregate

COUNT AVG SUM MAX MIN

Window

Window Function Basics LAG LEAD FIRST_VALUE LAST_VALUE

String

CONCAT LEN UPPER LOWER

Numeric

RAND ROUND FLOOR CEIL

Math

ABS POWER SQRT

Date

CURRENT_TIMESTAMP YEAR MONTH DAY

Tables

Datatypes Create Table Drop Table Alter Table Constraint Not Null Unique Primary Key Foreign Key Check Default Auto Increment Index