Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL

  • 5h 50m
  • Tom Coffing, William Coffing
  • Coffing Data Warehousing
  • 2013

This single book teaches the reader everything they need to know about Teradata, the architecture, and how Teradata works. It then gives over 1000 SQL examples that teach them everything. If you went to a desert island and could only take one book, this is the one you want.

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.

William Coffing is a Teradata Certified Master who has written multiple books on Teradata including the Teradata User's Guide. William, better known as Warehouse William, has taught Teradata internationally and throughout the United States. He has been an integral part of programming the Nexus Query Chameleon.

William graduated from Eastern Michigan University where he earned a Bachelor's Degree in Creative Writing and Communication/Theater Arts and then spent an additional year at the New York Film Academy. He has written and directed a feature film called "Switching Roles" and has directed multiple commercials.

In this Book

  • Introduction and Good Advice
  • 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
  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs. Group By
  • The TOP Command
  • Review
  • HELP and SHOW
  • Aggregation Function
  • Join Functions
  • Date Functions
  • Format Functions
  • OLAP Functions
  • The Quantile Function
  • Temporary Tables
  • Sub-query Functions
  • Substrings and Positioning Functions
  • Interrogating the Data
  • View Functions
  • Macro Functions
  • Set Operators Functions
  • Creating Tables, Secondary Indexes, and Join Indexes
  • Data Manipulation Language (DML)
  • Stored Procedure Functions
  • Trigger Functions
  • Math Functions
  • Sample
  • Statistical Aggregate Functions
  • Explain
  • Collect Statistics
  • Hashing Functions
  • BTEQ - Batch Teradata Query
  • Top SQL Commands Cheat Sheet