SQL

CL2 (Competent)
Creating, modifying, removing database objects

Aggregations (ORDER BY, GROUP BY, HAVING, SUM, COUNT, AVG, etc)

Combining the results of multiple queries (union, except, intersect, minus, subqueries)

Sessions, transactions, locks

Implementing stored procedures, user-defined functions, triggers

Cursors