If someone told me I could master ordered analytics/window functions in 20 minutes, I would pinch myself to see if I was dreaming.
Tom Coffing has written 85 books and taught over 1,000 classes because he is an incredible teacher with simple step-by-step explanations. Tom, better known as Tera-Tom, will teach you everything you want and need to know about the row_number, rank, cumulative sum, moving sum, average, and the moving difference.
Tom has taken his vast knowledge and experience and, for the last 20 years, has led a team of developers in building the Nexus, the only software that can query, migrate, and join data across over 25 relational database systems. Tom recently shocked the computer world by doing a 30-table join spanning 30 systems in a single query.
Celebrate today because you will master ordered analytics/window functions in 20 minutes. And without further adieu, here is Tom Coffing.
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.