Learn SQL with Tera-Tom: RANK, PARTITION BY, and QUALIFY
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 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.
• Microsoft Access
• SQL Server
• SAP HANA
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 the Nexus Super Join Builder automatically building the SQL on Teradata. Notice all systems in the systems tree that users can query, migrate, or join with Teradata.
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, PARTITION BY, and QUALIFY Video
You are never too young to begin dreaming of becoming the greatest data scientist ever!