<DIV><p><b>Perform efficient database queries with T-SQL window functions</b></p><p>Get a detailed look into the practical applications of window functions in Transact-SQL—the database programming language built into Microsoft SQL Server. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to perform calculations against sets of rows in your database—in a flexible, clear, and efficient manner. Delve into SQL windowing concepts and discover practical uses for various T-SQL window functions.</p><p> Discover how to:</p><ul><li>Apply SQL windowing concepts and window function design </li><li>Gain experience with window aggregate, ranking, offset, and distribution functions </li><li>Know when to use SQL ordered set functions, such as hypothetical set functions and inverse distribution functions </li><li>Optimize window functions in SQL Server 2012 </li><li>Use practical examples of T-SQL window functions to address common business tasks </li></ul></div>