Basic SQL
a. Types of Table – Global Temporary Table
b. Constraints
c. Views
d. Indexes
e. Synonyms
f. Sequences
g. Aggregated Function
h. Joins
i. Sub queries / Correlated sub queries
j. Set Operators
k. Hierarchical Queries
PL/SQL
o Procedure
o Function
o Package
o Trigger
o Cursors – Ref Cursor / System Cursors
o Bulk Collect
o Exception – Execution flow of Exception
o Dynamic SQL
o Collection – Types of collection