You are previewing Tera-Tom's 1000 page e-Book on Teradata.
O'Reilly logo
Tera-Tom's 1000 page e-Book on Teradata

Book Description

This book covers the Teradata Architecture with brilliant simplicity and every SQL command in detail!

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. About Tom Coffing
  5. About Warehouse William Coffing
  6. Table of Contents
  7. Chapter 1 – The Teradata Architecture
  8. Chapter 2 – Primary Index
  9. Chapter 3 – Hashing of the Primary Index
  10. Chapter 4 – Space
  11. Chapter 5 – Partition Primary Index (PPI) Tables Subquery
  12. Chapter 6 – Secondary Indexes
  13. Chapter 7 – Columnar Tables
  14. Chapter 8 – Temporal Tables Create Functions
  15. Chapter 9 – How Joins work internally
  16. Chapter 10 – Join Indexes
  17. Chapter 11 – Basic SQL Functions
  18. Chapter 12 – The WHERE Clause
  19. Chapter 13 – Distinct Vs Group By
  20. Chapter 14 – The TOP Command
  21. Chapter 15 – Review
  22. Chapter 16 – HELP and SHOW
  23. Chapter 17 – Aggregation Function
  24. Chapter 18 – Join Functions
  25. Chapter 19 – Date Functions
  26. Chapter 20 – Format Functions
  27. Chapter 21 – OLAP Functions
  28. Chapter 22 – The Quantile Function
  29. Chapter 23 – Temporary Tables
  30. Chapter 24 – Sub-query Functions
  31. Chapter 25 – Substrings and Positioning Functions
  32. Chapter 26 – Interrogating the Data
  33. Chapter 27 – View Functions
  34. Chapter 28 – Macro Functions
  35. Chapter 29 – Set Operators Functions
  36. Chapter 30 – Table Create and Data Types (DML)
  37. Chapter 31 – Data Manipulation Language
  38. Chapter 32 – Stored Procedure Functions
  39. Chapter 33 – Trigger Functions
  40. Chapter 34 – Math Functions
  41. Chapter 35 – The SAMPLE Function
  42. Chapter 36 – Statistical Aggregate Functions
  43. Chapter 37 – Explain
  44. Chapter 38 – Collect Statistics
  45. Chapter 39 – Hashing Functions
  46. Chapter 40 – BTEQ – Batch Teradata Query
  47. Chapter 41 – Your Nexus Query Chameleon