Additional Training:
Other Trainings: www.AaronBuma.com/free-sql-server-training/
We cover features around the TOP(N) in your query, followed by using the RANK(), DENSE_RANK and ROW_NUMBER. Then on to Analytic Functions to help with your statistical analysis of data. Similar to aggregate functions, analytics functions compute over a group of rows with multiple results within each group. Learn how to properly use each of these analytics functions in combination with enhancements to the OVER clause. Learn the value of CUME_DIST and PERCENT_RANK in your analysis, use LAST_VALUE and FIRST_VALUE along with PERCENTILE_DISC, PERCENTILE_CONT, LEAD and LAG you can look at data in the next and previous row.
For previous presentations and notifications of upcoming events, checkout my blog: www.AaronBuma.com or follow @AaronDBuma
Slides and scripts are also available at: www.AaronBuma.com