Windowing functions in SQL add flexibility and efficiency to your queries.
This session is designed to introduce a intermediate level T-SQL developer to the concept of windowing functions, and give you a level of comfort in working with these types of queries.
The slide deck introduces the theory and uses and visual representation of a table to show the behaviours of each component of a windowing function query.
The demo data set and demo scripts allow you to practice the techniques and see them in action.
This session has been presented at Johannesburg SQL User Group, and SQL Saturday Los Angeles.
2 comments