Level: Intermediate

Steve Hughes

Business Intelligence Architect

Pragmatic Works

Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.

You will learn:

• How to use window functions with the OVER() clause
• Compare the various ranking, aggregation, and analytic functions
• Evaluate the performance impacts of using the OVER() clause