SQL

• Introduction

DQL :Data Query

• select
• alias
• where
• operators
• like
• order by
• group by
• join
• inner join
• left join
• right join

DML :Data Manipulation

• insert
• update
• delete

DDL :Data Definition

• create
• alter
• truncate
• drop

TCL :Transaction Control

• Commit, Rollback, savepoint

DCL :Data Control

• grant, revoke

SQL others

• use
• not null
• default
• unique
• check
• primary key
• foreign key
• create view
• create index

SQL Function

• avg
• distinct
• count
• max
• min
• sum
• having
• round
• ucase
• lcase
• abs
• rand
• degrees
• floor
• ceiling
• log
• log10
• power
• square
• pi
• sqrt
• radians
• exp
• sign
• sin
• asin
• concatinate
• substring
• instr
• trim
• length
• replace