Relational Database & Data Warehouse Basics

Teradata 14    |    Beginner
  • 14 videos | 1h 8m 7s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 53 users Rating 4.5 of 53 users (53)
Teradata provides a relational database system that offers various tools and utilities for management, administration, and querying. Explore the basics of Teradata including what a data warehouse is along with its architecture and design.

WHAT YOU WILL LEARN

  • 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
  • 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

IN THIS COURSE

  • 2m 39s
    In this video, you will learn how to identify what Teradata has to offer. FREE ACCESS
  • 5m 17s
    After completing this video, you will be able to describe what a data warehouse is and how Teradata is used with it. FREE ACCESS
  • Locked
    3.  The Active Data Warehouse
    4m 40s
    Upon completion of this video, you will be able to describe an active data warehouse in Teradata. FREE ACCESS
  • Locked
    4.  Teradata Active Solutions
    3m 15s
    Upon completion of this video, you will be able to describe Teradata active solutions, including their features and benefits. FREE ACCESS
  • Locked
    5.  The Relational Database System
    4m 56s
    Upon completion of this video, you will be able to describe the concepts of a relational database system and its terminology. FREE ACCESS
  • Locked
    6.  The Data Warehouse Architectures
    4m 17s
    After completing this video, you will be able to describe the goals of a Teradata data warehouse and its architecture. FREE ACCESS
  • Locked
    7.  Data Marts
    5m 18s
    After completing this video, you will be able to describe data marts and when they are appropriate to use with Teradata. FREE ACCESS
  • Locked
    8.  The Enterprise Data Model
    4m 33s
    Upon completion of this video, you will be able to describe the enterprise data model. FREE ACCESS
  • Locked
    9.  Data Warehouse Design Overview
    5m 12s
    In this video, you will identify the database design life cycle and how logical data modeling is completed. FREE ACCESS
  • Locked
    10.  The Three-Schema Architecture
    4m 32s
    Upon completion of this video, you will be able to describe the three-schema architecture. FREE ACCESS
  • Locked
    11.  The Logical Data Model Frameworks
    3m 58s
    During this video, you will learn how to identify the Teradata logical data model frameworks and their advantages and disadvantages. FREE ACCESS
  • Locked
    12.  Semantic Data Modeling Overview
    4m 2s
    After completing this video, you will be able to describe how to perform entity relationships analysis for semantic data modeling. FREE ACCESS
  • Locked
    13.  Entities, Attributes, and Relationships
    8m 34s
    In this video, you will identify entities, attributes, and relationships in an E-R logical model. FREE ACCESS
  • Locked
    14.  The Normalization Process
    6m 56s
    After completing this video, you will be able to describe the normalization process. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Relational Database Management System (RDBMS)
Rating 4.2 of 86 users Rating 4.2 of 86 users (86)
Course Digital Transformation Insights: Finance, Accounting & IT Functions
Rating 4.3 of 383 users Rating 4.3 of 383 users (383)
Course Introducing SELECT Statement Queries
Rating 4.6 of 47 users Rating 4.6 of 47 users (47)