Teradata Architecture and Basics

Teradata Architecture and Basics

Bascom Bridge’s  Teradata Architecture and Basics training class teaches attendees how to take advantage of Teradata’s unique parallel architecture to interpret SQL requests, receive input records, and pass data.

TERADATA ARCHITECTURE TRAINING OBJECTIVES

All students will learn:

• The Teradata Architecture
• The Primary Index
• Hashing of the Primary Index
• Inside the AMPs Disk
• Join Functions
• Partition Primary Index (PPI) Tables
• Columnar Tables
• Temporary Tables
• Space
• Secondary Indexes
• Join Indexes
• Collect Statistics
• Temporal Tables Create Functions
• Teradata Load Utilities Introduction

TERADATA ARCHITECTURE TRAINING PREREQUISITES

No prior experience is required.

TERADATA ARCHITECTURE TRAINING MATERIALS

All Teradata training students receive comprehensive courseware.

SOFTWARE NEEDED FOR EACH PC:

We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

TERADATA ARCHITECTURE TRAINING OUTLINE

• Introduction
• The Teradata Architecture
• The Primary Index
• Hashing of the Primary Index
• Teradata – The Cold Hard Facts
• Inside the AMPs Disk
• Partition Primary Index (PPI) Tables
• Columnar Tables
• Space
• The User Environment
• Secondary Indexes
• Temporal Tables Create Functions
• How Joins Work Internally
• Join Indexes
• Collect Statistics
• Temporary Tables
• Teradata Load Utilities Introduction
• Conclusion