Pivot - View - Transaction - Trigger - Cursor - Backup
Index - Inserted - Updated- Hash
Stored Procedures - Return Value - Output - TVP - Functions
Exists - Ranking Functions - Row Number - Rank - Dense Rank - NTile - Stored Procedures
Aggregate Function - Group By - Join - Union - Self Join - Subquery - CTE