Learn Teradata with Tera-Tom - Non-Unique Primary Index
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. The chart below shows which systems users can query, migrate, and join data automatically with Nexus.
You can download a free trial of Nexus at CoffingDW.com. You can also see some of the great features of Nexus right here.
You can also see the Nexus in action migrating data to the cloud here.
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.
The Teradata Non-Unique Primary Index
Teradata tables can be extremely large and might use thousands of AMPs, but use the Teradata Non-Unique Primary Index in the WHERE clause, and you will use only one AMP in the query. Find out how and why in the video below.
Watch the video and understand the advantages of a Non-Unique Primary Index.
Tom Coffing's daughter followed in Tom's footsteps as she became a world-class athlete and speaker. Carling was a professional golfer who won the reality TV series The Big Break, and she starred in over 100 episodes of her television show with Jimmy Hamlin.