• Online, Self-Paced
Course Description

Teradata provides a relational database system for data storage that offers various tools and utilities for management, administration, and querying. It offers a high quality system using a parallel database architecture providing a 'share nothing' architecture. This course will provide information on the basics of Teradata including what a data warehouse is along with its architecture and design, an overview of a relational database system, and the hardware and software used by Teradata for the database architecture.

Learning Objectives

Teradata Overview

  • start the course
  • identify what Teradata has to offer
  • describe what a data warehouse is and how it is used with Teradata
  • describe an active data warehouse in Teradata
  • describe Teradata active solutions, including
  • describe the concepts of a relational database system and its terminology
  • describe the goals of a Teradata data warehouse and its architecture
  • describe data marts and when they are appropriate to use with Teradata

Data Modeling

  • describe the enterprise data model
  • identify the database design life cycle and how logical data modeling is completed
  • describe the three-schema architecture
  • identify the Teradata logical data model frameworks and their pros and cons
  • describe performing entity relationships analysis for semantic data modeling
  • identify entities, attributes, and relationships in a E-R logical model
  • describe the normalization process

Teradata RDBMS

  • identify the capabilities of a Teradata database, its software, and tools
  • identify the main components of a Teradata architecture
  • describe the parsing engine in a Teradata database
  • describe the BYNET and how it is used in a Teradata database
  • describe AMPs and how they are used in a Teradata database
  • describe Teradatas virtual storage, its benefits, and considerations
  • identify how Teradata uses intelligent memory
  • describe how Teradata perform request processing using the dispatcher and AMPs

Practice: The Teradata Architecture

  • identify and describe the Teradata database and architecture concepts

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.