The session focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this session you will learn the details and capabilities of T-SQL: Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Type Related Problems; Programmable Objects; Graphs, Trees and Hierarchies.
Along the session you will learn how to use T-SQL to solve practical problems for common requirements via SQL Server SET based approach. We will try to cover close to 10 different scenario’s and their practical solution via ...