Table of Contents

•   Chapter 1 – The Teradata Architecture

•   Chapter 2 – Primary Index

•   Chapter 3 – Hashing of the Primary Index

•   Chapter 4 – Space

•   Chapter 5 – Partition Primary Index (PPI) Tables Subquery

•   Chapter 6 – Secondary Indexes

•   Chapter 7 – Columnar Tables

•   Chapter 8 – Temporal Tables Create Functions

•   Chapter 9 – How Joins work internally

•   Chapter 10 – Join Indexes

•   Chapter 11 – Basic SQL Functions

•   Chapter 12 – The WHERE Clause

•   Chapter 13 – Distinct Vs Group By

•   Chapter 14 – The TOP Command

•   Chapter 15 – Review

•   Chapter 16 – HELP and SHOW

•   Chapter 17 – Aggregation Function

•   Chapter 18 – Join Functions

•   Chapter 19 – Date Functions

•   Chapter 20 – Format Functions

•   Chapter 21 – OLAP Functions

•   Chapter 22 – The Quantile Function

•   Chapter 23 – Temporary Tables

•   Chapter 24 – Sub-query Functions

•   Chapter 25 – Substrings and Positioning Functions

•   Chapter 26 – Interrogating the Data

•   Chapter 27 – View Functions

•   Chapter 28 – Macro Functions

•   Chapter 29 – Set Operators Functions

•   Chapter 30 – Table Create and Data Types (DML)

•   Chapter 31 – Data Manipulation Language

•   Chapter 32 – Stored Procedure Functions

•   Chapter 33 – Trigger Functions

•   Chapter 34 – Math Functions

•   Chapter 35 – The SAMPLE Function

•   Chapter 36 – Statistical Aggregate Functions

•   Chapter 37 – Explain

•   Chapter 38 – Collect Statistics

•   Chapter 39 – Hashing Functions

•   Chapter 40 – BTEQ – Batch Teradata Query

•   Chapter 41 – Your Nexus Query Chameleon