Cynosure Knowledge Solutions

Teradata Overview

WHAT IS TERADATA?
WHY TERADATA?
SCALABILITY IN A PRODUCTION ENVIRONMENT
TERADATA ADVANTAGES
TERADATA A BRIEF HISTORY
HOW LARGE IS A TRILLION?
DESIGNED FOR TODAYS BUSINESS
TERADATA MANAGEABILITY

Relational Database Concepts

WHAT IS A DATABASE?
LOGICAL/RELATIONAL MODELING
RELATIONAL DATABASES
PRIMARY KEYS
FOREIGN KEYS
RELATIONAL ADVANTAGES

Components and Architecture

WHAT IS A NODE?
MPP SYSTEM
CLIQUES
MAJOR COMPONENTS OF A TERADATA SYSTEM
THE PARSING ENGINE
BYNET
THE ACCESS MODULE PROCESSOR (AMP)
DISK ARRAYS

Accessing Teradata Objects

TERADATA OBJECTS
THE DATA DICTIONARY (DD)
STRUCTURED QUERY LANGUAGE (SQL)
THE SELECT STATEMENT
THE JOIN OPERATION
VIEWS
MULTI-TABLE VIEWS
MACROS

Teradata Tools

QUERY SUBMITTING TOOLS
FASTLOAD UTILITY
MULTILOAD UTILITY
FASTEXPORT UTILITY
TPUMP

Creating a Teradata Database

A TERADATA DATABASE
A TERADATA USER
INITIAL TERADATA SYSTEM
TERADATA SPACE MANAGEMENT
CREATING TABLES
ACCESS RIGHTS

Storing and Accessing Data Rows

HOW DOES TERADATA STORE ROWS?
HOW DO OTHER DATABASES STORE ROWS?
PRIMARY INDEXES
CREATING A PRIMARY INDEX
ACCESSING VIA A UNIQUE PRIMARY INDEX
ACCESSING VIA A NON-UNIQUE PRIMARY INDEX
PRIMARY KEYS AND PRIMARY INDEXES
ROW DISTRIBUTION USING A UPI
ROW DISTRIBUTION USING A NUPI
ROW DISTRIBUTION USING A HIGHLY NON-UNIQUE INDEX
PARTITIONED PRIMARY INDEX

Secondary Indexes and Table Scans

SECONDARY INDEXES
CHOOSING A SECONDARY INDEX
UNIQUE SECONDARY INDEX (USI) ACCESS
NON-UNIQUE SECONDARY INDEX (NUSI) ACCESS
OTHER TYPES OF SECONDARY INDEXES
COMPARISON OF PRIMARY AND SECONDARY INDEXES
FULL-TABLE SCANS
PPI ACCESS

Data Protection

LOCKS
TRANSIENT JOURNAL
RAID PROTECTION
FALLBACK
FALLBACK CLUSTER
RECOVERY JOURNALS FOR DOWN AMPS
CLIQUES
ARCHIVING AND RECOVERING DATA
PERMANENT JOURNAL

Data Protection

Test Case Discussion
Sample Test Document