One of my biggest regrets was not learning SQL-ordered analytics and window functions immediately. Because I was unclear and frightened, I put them off for years, yet they are so easy and powerful once you understand them. So, I put together a 20-minute video on YouTube that will make you an absolute analytic genius.

Below is the video where you will learn the cumulative sum, moving sum and average, row number, rank, and moving difference for all database platforms! Plus, you will see the QUALIFY statement, which is only in Teradata, BigQuery, Databricks, and Snowflake.

I am also excited to show you the video because I want you to see my teaching style, how clearly I instruct, how easy I make it to understand, how I build lessons in learning blocks, and why so many people tell me I am the greatest technical teacher of all time.

I also have hundreds of blogs on all technical subjects for all databases and hundreds of YouTube videos where you can learn for free.

But I also hope you will consider bringing me in to teach your team, whether a class on-premises at your company or a virtual class using Microsoft Teams or Zoom.

Over the past 30 years, I have taught over 1,000 classes with a 9.8 out of 10 rating and written over 90 books on all databases and subjects. My favorite classes are database architecture and SQL, which I teach with performance tuning in mind.

All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know the best technical trainer in the world. Ask them to hire me to train at your company, either on-site or with a virtual class. They can see our classes, outlines, and a sample of my teaching at this link on our website.

https://coffingdw.com/education/



Thank you,

Tera-Tom

Tom Coffing
CEO, Coffing Data Warehousing
Phone: 513 300-0341
Email: Tom.Coffing@CoffingDW.com
Website: https://coffingdw.com/
YouTube: https://www.youtube.com/coffingdw

Posted in Blog