1. DDL (Create, Alter,Truncate,Drop)
2. DML (insert,Update ,Delete)
3. TCL (Commit,SavePoint,RollBack)
4. Constraints (NotNull,Unique,Default,Check,PrimaryKey,ForeignKey)
5. Clauses (Where,In Operator,SubQuery,Groupby,Having,Orderby)
6. Joins (InnerJoin,LeftOuterJoin,RightOuterJoin,FullOuterJoin,CrossJoin)
7. Cast, Convert
8. Union all,Union,Except,NotIn,Intersect
9. Functions (String Functions,Mathematical Functions,Date Functions)
10. String Functions (Substring,Ltrim,Rtrim,Left,Right,Replicate,CharIndex, Length,Replace,Upper,Lower,Stuff)
11. Mathematical Functions(Maximum,Minimum,Sum,Average,Count,CountDistinct)
12. Date Functions (DateAdd,DatePart,DateDiff,DateName)
13. Row Number,Rank,DenseRank,TopFunction,CTE,Isnull
14. View (Simple View,Complex View,View with Schemabinding)
15. Case Statement
16. Table Variable
17. Temporary tables(Normal temp Table,Global temp Table)
18. TSQL (Iteratives.Functions,Procedures,Indexes,Triggers)
19. Iterative(If,While,)
20. Functions (ScalarValued Functions,Table Valued Functions)
21. Stored Procedures
22. Indexes (ClusteredIndex,Non Clustered Index)
23. Triggers (DDL Triggers,DML Triggers)
24. Cursor