• tomcoffing

Learn Teradata with Tera-Tom - Multi-Column 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.

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.



The Teradata Multi-Column Primary Index


Teradata tables can be extremely large and might use thousands of AMPs, but use the Primary Index in the WHERE clause, and you will use only one AMP in the query. Teradata allows you to have a multi-column Primary Index, but you might need to know a few things to make it effective.


Watch the video and understand the advantages of a Multi-Column Primary Index.






Tom Coffing has an 1120-page book with hundreds of examples designed to teach you everything about the Snowflake architecture and SQL. The book is available for purchase for individuals and entire companies. Contact Tom at Tom.Coffing@CoffingDW.com.



1 view0 comments