sql2.docxT-sql Concepts :
1) Joins,self join sub query
2)groupby, Order by, where, having
3)set operators
4) t-sql programming
5) stored procedures
6) Indexes,views
7)user defined functions & difference between sp & udf
8) temp table/table variables,cursors,CTE
1) Joins,self join sub query
2)groupby, Order by, where, having
3)set operators
4) t-sql programming
5) stored procedures
6) Indexes,views
7)user defined functions & difference between sp & udf
8) temp table/table variables,cursors,CTE