Teradata Basics: Relational Database and Data Warehouse Basics from Skillsoft

Online, Self-Paced

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