Sql clause: TOP,WHERE,AND/OR/IN/BETWEEN,LIKE, GROUP BY,ORDER BY,Count,Having, Unions,intersect,Except etc. Sql join : Inner join, Left Join, Right Join, SelfJoins in Sql clustered and nonclustered index in Sql Stored Procedures in Sql Server Advantage and Disadvantage of stored procedure Implement data integrity in Microsoft SQLServer by using Triggers Implement views Cursor, Indexer etc… Different way of creating database Backup