8247  Reviews star_rate star_rate star_rate star_rate star_half

Teradata Architecture and Basics

Accelebrate'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...

Read More
Course Code TER-130
Duration 3 days
Available Formats Classroom

Accelebrate'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.

Skills Gained

  • 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

Prerequisites

No prior experience is required.

Course Details

Training Materials

All Teradata training students receive comprehensive courseware.

Software Requirements

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.

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