Teradata Architecture for IT and Developers

  • 2h 8m
  • John Nolan, Tom Coffing
  • Coffing Data Warehousing
  • 2013

This book will make every IT/Developer in your company a superstar. This book is designed to teach IT and developers everything they want to know about Teradata while leaving no stone unturned. They are going to see and understand Teradata at a level they’ve never understood it before. It is a brilliant way to explain what is happening in Teradata down to the most detailed levels. Like the rest of the Genius Series, it takes a building block approach to allow readers to continually see how the data is laid out, how to design the tables, as well as understand the mechanisms that Teradata uses, and understand why Teradata is the best data warehouse in the world. -

About the Authors

Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 20 years. Tom has written over 50 books on all aspects of Teradata, Netezza, Kognitio, Redshift, ParAccel, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 Teradata classes in places such as India, Africa, Europe, China, Malaysia, and throughout North America.

Tom is also the owner and designer of the Nexus Query Chameleon, the most sophisticated enterprise query tool in the industry. The Nexus works on all platforms, including Hadoop, converts table structures between all systems, and allows companies to load their ERwin logical model inside Nexus. The Nexus guides users like a GPS system. Users point and click on any table or view from any system, and they are guided to what joins to what. As users choose the columns they want on their report, the SQL is built automatically.

In High School, Tom was the first athlete from his school to ever place at state. He was selected by his school to represent them at Buckeye Boys State, and Tom was inducted into the first class of the Lakota High School Hall of Fame.

At the University of Arizona and University of Nevada Las Vegas, Tom was a two-time All-American wrestler, Sophomore Athlete of the year, and a two-time winner of the 1980 Olympic wrestling trials. Tom graduated with a Bachelor's degree in Speech Communications.

After college, Tom became a state and national champion speech winner for Toastmasters and won two orchid awards as an actor. Tom is the proud father of three wonderful children and has been married for the past 32 years.

John Nolan is the Director of Sales and Marketing for Coffing Data Warehousing. In his role with CoffingDW, he has orchestrated multiple strategic partnerships with major international technology and data warehousing companies. Through his leadership and sales, he has been instrumental in helping to bring the Nexus Query Chameleon to the largest data warehouses in the world. He is responsible for testing and key development of the Nexus across the globe.

John brings with him a wealth of sales and marketing experience from a diverse background including his time spent at Fidelity Investments where he became Series 7 and 63 licensed and TQL where he built and maintained a portfolio of clients across the US.

John is a graduate of Xavier University where he was captain of an Academic All-American swim team and obtained a BSBA in Marketing with a minor in Biology.

In this Book

  • The Teradata Architecture
  • The Primary Index
  • Hashing of the Primary Index
  • Teradata - The Cold Hard Facts
  • Inside the AMPs Disk
  • Partition Primary Index (PPI) Tables
  • Columnar Tables
  • Space
  • The User Environment
  • Secondary Indexes
  • Temporal Tables Create Functions
  • How Joins Work Internally
  • Join Indexes
  • Collect Statistics
  • Temporary Tables
  • Teradata Load Utilities Introduction
  • Top SQL Commands Cheat Sheet
SHOW MORE
FREE ACCESS