Chapter 1 — The Rules of Data Warehousing Teradata Certification Teradata: Brilliant by Design The Teradata Parallel Architecture A Logical View of the Teradata Architecture The BYNET Chapter 2 — Data Distribution Explained What is a Relational Data Model? Primary Keys are Different than Primary Indexes Foreign Keys Primary Key Foreign Key Quiz Primary Key Foreign Key Quiz Answers The Primary Index Two Types of Primary Indexes (UPI or NUPI) Unique Primary Index (UPI) Non-Unique Primary Index (NUPI) Primary Index Explained in Simple Terms Primary Index (PI) Data Distribution in Theory Primary Index with Row Hash Primary Index adding a Uniqueness Value Primary Index Quiz Turning the Primary Index Value into a Row Hash The Row Hash 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 with a Primary Index What is a Binary Search? What is a Collision or Synonym? Row Distribution A Visual for Data Layout Teradata accesses data in three ways Data Layout Summary Chapter 3 — 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 Spool Space controls system time A quiz on Perm and Spool Space Another quiz on Perm and Spool Space Chapter 4 — V2R6 Partition Primary Indexes V2R6 Partitioning Partitioning doesn’t have to be part of a Primary Index PPI Advantages and Disadvantages Partition Elimination can avoid Full Table Scans EXPLAIN – PPI Tables and Partitions Partitioning with CASE_N Partitioning with RANGE_N PPI Date Range in Months PPI Date Range in Weeks PPI Date Range in Days Finding the Rows in each Partition NO CASE, NO RANGE, or UNKNOWN Bad News about Partitioning on a column that is not part of the Primary Index Chapter 5 — Data Protection Transaction Concept & Transient Journal How the Transient Journal Works FALLBACK Protection How Fallback Works Fallback Clusters Fallback Exercises with Clusters Fallback – Performance Vs Protection Down AMP Recovery Journal (DARJ) Redundant Array of Independent Disks (RAID) Cliques Cliques – A two node example Cliques – A four node example Detailed Overview of System Protection Detailed Overview of System Protection Clusters Overview of System Protection (Answers) Permanent Journal Table create with Fallback and Permanent Journal Permanent Journals Permanent Journal Rules Some Permanent Journal Possibilities Creating a Permanent Journal Create Table Examples with Permanent Journals Each Permanent Journal is made up of 3 Areas Locks Teradata has 4 locks for 3 levels of Locking Locks and their compatibility What is a Row Hash Lock? Chapter 6 — Loading the Data FastLoad Multiload TPump FastExport Chapter 7 — Secondary Indexes Unique Secondary Index (USI) USI Subtable Example How Teradata retrieves an USI query NUSI Subtable Example How Teradata retrieves a NUSI query Value Ordered NUSI How Teradata retrieves a Value Ordered NUSI query Non-Unique Secondary Index (NUSI) Quiz Unique Secondary Index (USI) Quiz Secondary Index Summary Chart for Primary and Secondary Access Chapter 8 — The Active Data Warehouse Operational Data Stores Vs the Data Warehouse OLTP, DSS, OLCP, and OLAP OLTP Environments The DSS environment Mixing OLTP and DSS environments Detail Data Data Marts Logical and Dependent Data Marts Independent Data Marts Data Warehouses Evolve over Time Active Data Warehousing
“We chose TEKsystems Education Services due to their willingness to customize and work with our unique curriculum.” –Client