Outline
The Teradata Architecture o Born to be parallel o Collecting Statistics B H D
Logical Modeling o Logical Modeling – Primary and Foreign Keys o Normalization o Dimensional Modeling also called Star Schema
Security and permissions
Index o Unique Primary Index (UPI) o Non-Unique Primary Index (NUPI) o Multi-Column Primary Indexes o Secondary Indexes
Partitioned Tables o A Table used for our Partitioning Example o One Year of Orders Partitioned o Add the Partition to the Row-ID for the Row Key
Backup and restore
Transaction Concept
Trigger
Programme scope, delivery arrangements and suitability are confirmed during enquiry.