top of page
tomcoffing

Learn SQL with Tera-Tom: Cumulative Sum Ordered Analytic

Updated: Sep 16, 2022


Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands of people became Teradata Certified Masters from Tom's books.


Are you ready to learn SQL from the best technical trainer the world has ever seen? Tom Coffing, AKA Tera-Tom, makes learning fun, exciting, and easy. Learning SQL is one of the best moves you can make in your career because you can query every database with SQL.


Tom became famous as a teacher because he memorized every student's name when he greeted them. Tom has taught over 1,000 classes and never missed a single name. Ask anyone who attended a class taught by Tom Coffing.


Tom has also led a team of developers for almost 20 years to create the Nexus, which queries, migrates, and joins data across all systems. The database list below shows which systems users can query, migrate, and join data automatically with Nexus.


Nexus version 17 can migrate from every combination between all systems as the source or the target.


• MySQL

• Excel

• Microsoft Access

• Snowflake

• Redshift

• Synapse

• BigQuery

• Teradata

• Oracle

• SQL Server

• DB2

• Hadoop

• MapR

• Greenplum

• Postgres

• Vertica

• Netezza

• SAP HANA

• Yellowbrick • SQLite

You can download a free trial of Nexus at CoffingDW.com. You can also see some of the great features of Nexus right here.



The picture above is Nexus in dark mode, querying Teradata. The user has chosen the book mode option to place the answer set to the right of the query window.


This video is part of the Tera-Tom SQL series, where Tom provides over 100 videos that are only five minutes long. You can take your time and go at your own pace.



Cumulative Sum Ordered Analytic Video





This picture is of Tom Coffing, his wife, Leona, and their three children back in the late 80s. Tom has been married for 41 years.




23 views0 comments

Comments


bottom of page