Tera-Tom's 1000 page e-Book on Teradata

Author Tera-Tom Coffing

Release Date: 2012/07/01

ISBN: 9780985916404

Topic:

• Data

47
Chapters

0-1
Hours read

0k
Total Words

    Start Reading Now    
       Add to Wishlist       
View table of contents

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