1.DML Statements
DMl Statements
SELECT Statement
WHERE
GROUP BY
WITH CUBE or WITH ROLLUP
HAVING
SELECT
DISTINCT
ORDER BY
TOP
INNER JOINS
OUTER JOINS
LEFT JOIN or LEFT OUTER JOIN
RIGHT JOIN or RIGHT OUTER JOIN
FULL JOIN or FULL OUTER JOIN
CROSS JOIN
GROUPING
Union
Union ALL
ROLL UP
MERGE
Advance Query Techniques
Common Table Expression (Recursive Queries)
Correlated Vs No Correlated Queries
Ranking Function
SubQueries
Typical query Examples