Teradata Training
Module 3 – Teradata Basics
Teradata Storage Architecture..................................................................................................... 3-4
Teradata Retrieval Architecture................................................................................................... 3-6
Multiple Tables on Multiple AMPs............................................................................................. 3-8
Linear Growth and Expandability ............................................................................................. 3-10
Teradata Objects........................................................................................................................ 3-12
The Data Dictionary Directory (DD/D)..................................................................................... 3-14
Structure Query Language (SQL).............................................................................................. 3-16
CREATE TABLE – Example of DDL...................................................................................... 3-18
Views......................................................................................................................................... 3-20
Multi-Table Views..................................................................................................................... 3-22
SELECT – Example of DML .................................................................................................... 3-24
The JOIN Operation .................................................................................................................. 3-26
Macros ....................................................................................................................................... 3-28
HELP Commands...................................................................................................................... 3-30
SHOW Command...................................................................................................................... 3-34
EXPLAIN Facility..................................................................................................................... 3-36
Teradata Features Review.......................................................................................................... 3-38
Review Questions...................................................................................................................... 3-40
Module 4 – Teradata Database Architecture
Teradata and MPP Systems ......................................................................................................... 4-4
Teradata Functional Overview ....................................................................................................4-6
Channel-Attached Client Software Overview ............................................................................. 4-8
Network-Attached Client Software Overview........................................................................... 4-10
The Parsing Engine.................................................................................................................... 4-12
Message Passing Layer.............................................................................................................. 4-14
The Access Module Processor (AMP) ......................................................................................4-16
Teradata Parallelism .................................................................................................................. 4-18
Review Questions...................................................................................................................... 4-20
Course Introduction
Page 0-20