Roles and Responsibilities, Joins, Index, diff bw cursor and while loop, diff bw clustered and non clustered index, diff bw for and while loop, how to debug a procedure, Acid properties, Transactions and isolations, storeprocedure, 2nd highest salary, CTE, functions.