• tomcoffing

Learn SQL with Tera-Tom: RANK Ordered Analytic

Updated: Sep 16


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 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.


https://www.youtube.com/watch?v=o7YGXfxrJOM&t=24s.



The picture above shows Nexus in dark mode, querying Teradata. Notice all of the systems Nexus can query, join, and migrate to in the systems tree on the left.



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.



RANK Ordered Analytic Video


This video shows the Teradata syntax for RANK, which might not work on other databases, but it also shows the ANSI version of RANK, which works across all database platforms.






This picture shows Tom Coffing (left) at the Olympic trials held in Cincinnati, Ohio. Tom won two Olympic trials in 1980 in the 149.5-pound weight class.




13 views0 comments