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