Analytic functions still bamboozle many SQL practitioners out there. So I’m building a suite of videos to walk people through some of the common questions we get asked that we need to solve with SQL, and look at how we can often solve them most simply using Analytic functions.
It will all be based on the KISS principle – Keep It Simply SQL, as it pertains to understanding the Analytic syntax.
You can find my introductory video here, with more to come as we solve problems simply with (analytic) SQL. There is also an “Analytics” playlist on my channel, which will grow each time I add a new video.
I hope you enjoy it – and feel free to comment or offer feedback.