Teradata Basics

Teradata Basics Duration: 1-2 days

Course Number: ISI-TERA-01

Description This course details the fundamentals of the Teradata database and will get students Teradata Certified as Teradata Certified Professionals. Students learn about parallel processing, AMPs and PEPs, how Teradata lays out data evenly, Primary Index use, hashing, Perm and Spool Space, and protection features. Topics include: • • • • • •

Parallel Processing with AMPs and PEPs Role of the AMPs and how the Optimizer works How Teradata is incorporated into the 4850/5250 architecture AWS, BYNET, and RAID disk arrays Perm and Spool space, access rights, and the DDD system tables Fallback, clusters, and cliques.

Audience This course is intended for a mix of beginning, intermediate and advanced Teradata users. Prerequisites There are no prerequisites for this course.

Phone: Cellular: Fax:

888-811-0204 916-549-6306 419-844-5564

E-mail: [email protected]

1 of 5

1516 N. Elmhurst Road #168 Mt. Prospect, IL 60056

Teradata Basics Course Agenda The Rules of Data Warehousing • Teradata Facts • Teradata: Brilliant by Design • The Teradata Parallel Architecture • A Logical View of the Teradata Architecture • The Teradata Architecture: PE, AMP, and BYNET • The Parsing Engine • The AMPs • The BYNET • A Visual for Data Layout • Teradata is a Shared Nothing Architecture • Teradata has Linear Scalability • How Teradata Handles Data Access Data Layout: AutoMagically • Data Distribution Explained • Rows and Columns • The Primary Index • The Two Types of Primary Indexes • Unique Primary Index (UPI) • Non-Unique Primary Index • How Teradata Turns the Primary Index Value into the Row Hash • The Row Hash Value Determines the Rows Destination • The Row is Delivered to the Proper AMP • The AMP Will Add a Uniqueness Value • An Example of an UPI Table • An Example of an NUPI Table • How Teradata Retrieves Rows • Row Distribution • A Visual for Data Layout • Teradata Accesses Data in Three ways • Data Layout Summary

Phone: Cellular: Fax:

888-811-0204 916-549-6306 419-844-5564

E-mail: [email protected]

2 of 5

1516 N. Elmhurst Road #168 Mt. Prospect, IL 60056

Teradata Basics Course Agenda (continued) Teradata Space • How Permanent Space is Calculated • How Permanent Space is Given • The Teradata Hierarchy • How Spool Space is Calculated • A Spool Space Example • PERM, SPOOL and TEMP Space Partition Primary Indexes • V2R5 Partition Primary Indexes • V2R4 Example • V2R5 Partitioning • Partitioning Doesn't Have To Be Part The Primary Index • Partition Elimination Can Avoid Full Table Scans • The Bad News About Partitioning On A Column That Is Not Part Of The Primary Index • Two Ways To Handle Partitioning On A Column That Is Not Part Of The Primary Index • Partitioning with CASE_N • Partitioning with RANGE_N • NO CASE, NO RANGE, or UNKNOWN Data Protection • Transaction Concept and Transient Journal • How the Transient Journal Works • FALLBACK Protection • How Fallback Works • Fallback Clusters • Down AMP Recovery Journal (DARJ) • Redundant Array of Independent Disks (RAID) • Cliques • Permanent Journal • Locking Modes in Teradata

Phone: Cellular: Fax:

888-811-0204 916-549-6306 419-844-5564

E-mail: [email protected]

3 of 5

1516 N. Elmhurst Road #168 Mt. Prospect, IL 60056

Teradata Basics Course Agenda (continued) Loading the Data • Fastload • Multiload • Tpump • Fastexport Teradata Hardware • Teradata’s Building Block Approach • Multiple Nodes Are Connected Via The BYNET • Teradata Performance – The Divide and Conquer Theory • NCR 4950 and 5350 Systems • SMP Nodes are Attached to Disk Chapters • How Multiple Nodes are Connected Via the BYNET • What An Actual Cabinet Looks Like • TPA versus Non-TPA Nodes Secondary Indexes • Secondary Indexes Are Key To Good Performance • Unique Secondary Index (USI) • USI Subtable Example • NUSI Subtable Example • Syntax to create a Secondary Index • Value-Ordered NUSI • Collect Statistics • NUSI Bitmapping • Prototyping Indexes with EXPLAIN • Secondary Index Summary • Chart for Primary and Secondary Access

Phone: Cellular: Fax:

888-811-0204 916-549-6306 419-844-5564

E-mail: [email protected]

4 of 5

1516 N. Elmhurst Road #168 Mt. Prospect, IL 60056

Teradata Basics Course Agenda (continued) The Active Data Warehouse • OLTP Environments • The DSS environment • Mixing OLTP and DSS environments • Detail Data • Easy System Administration • Data Marts • Teradata Tools • SQL Assistant • TDQM • Teradata Index Wizard • Archive Recovery • Teradata Analyst Suite

Phone: Cellular: Fax:

888-811-0204 916-549-6306 419-844-5564

E-mail: [email protected]

5 of 5

1516 N. Elmhurst Road #168 Mt. Prospect, IL 60056