SQL basics
DML, DDL & DQL
DDL: create, alter, drop
SQL constraints:
Not null, unique,
Primary & foreign key, composite key
Check, default
DML: insert, update, delete and merge
DQL : select
Select distinct
SQL where
SQL operators
SQL like
SQL order by
SQL aliases
SQL views
SQL joins
Inner join
Left (outer) join
Right (outer) join
Full (outer) join
SQL (Structured Query Language)
Mysql functions
String functions
Char_length
Concat
Lower
Reverse
Upper
Numeric functions
Max, min, sum
Avg, count, abs
Date functions
Curdate
Curtime
Now