The PASS Application Development VG is a developer community with free training and information for developers working with data.

Welcome & Updates

Welcome to the Application Development Virtual Group!
We are delighted to share expert teachings and knowledge with our community. Please join us! There is no cost to join. We offer free training at your fingertips.

Please subscribe to our YouTube channel, connect with us on LinkedIn, follow us on Twitter or reach out to us via email.

View past recordings to brush up on a skill or to learn new skills. Our presenters typically share their presentation content and code examples after the presentation. Presentations are demo heavy for our technical audience of mostly developers.  We welcome novice, expert and no-code developers.  We encourage you to get hands-on with the code examples and share your findings.

EventDisplay

T-SQL Window Functions

Thu, Jul 13 2017 19:00 UTC

T-SQL Window Functions

T-SQL window functions allow you to perform data analysis calculations like aggregates, ranking, offset and more. When compared with alternative tools to achieve similar tasks like grouping, joining, using subqueries, window functions have several interesting advantages that allow you to solve your tasks often more elegantly and more efficiently. Furthermore, as it turns out, window functions can be used to solve a wide variety of T-SQL querying tasks well beyond their original intended use case, which is data analysis. This session introduces window functions and their evolution from SQL Server 2005 to SQL Server 2017, explains how they get optimized, and shows practical use cases.


Itzik Ben-Gan

Itzik Ben-Gan is a mentor and Co-Founder of SolidQ. A Data Platform Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning and programming. Itzik is the author of several books including T-SQL Fundamentals Third Edition and T-SQL Querying. Itzik’s speaking activities include SQLPASS, SQLBits, SQL Nexus, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for their T-SQL related activities.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids