• tomcoffing

Learn Teradata with Tera-Tom - How Hashing Works with a Unique Primary Index

Updated: Sep 16


This picture shows Tom Coffing (Tera-Tom) teaching Teradata certification 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 about Teradata from the best technical trainer the world has ever seen? Tom Coffing, AKA Tera-Tom, makes learning fun, exciting, and easy. Learning Teradata Architecture is one of the best moves you can make in your career because Teradata has the most comprehensive design in the industry.


Tom Coffing is an expert on all database systems as he has written over 85 books covering them all. Once Tom understood the Teradata Architecture, the other databases were easy to learn.


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. Check out the list of databases below that 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.


You can also see the Nexus in action migrating data to the cloud here.

https://www.youtube.com/watch?v=_9ABivdwJPk&t=3s.


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



How Hashing Works with a Unique Primary Index


Getting a picture in your mind about Teradata Architecture can be extremely valuable. Tera-Tom explains what you need to know in the video below.


Watch the video and understand how all systems hash data using a math formula.





Above is a picture of the Nexus, which Tom has spent 18 years working with his development team. The Nexus Chameleon can migrate data automatically between all systems. In our example, Nexus has successfully migrated data from Oracle to Snowflake.


18 views0 comments