Teradata Basics: Relational Database and Data Warehouse Basics

individuals looking to understand the features functions, and benefits of a Teradata database


Expected Duration
111 minutes

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.


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





Multi-license discounts available for Annual and Monthly subscriptions.