Teradata Fundamentals Training Course

Duration

21 hours (usually 3 days including breaks)

Requirements

Basic knowledge of SQL and Database Systems would be helpful, although the basics will be covered during the training course. 

Overview

Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism. 

This course introduces the delegates to Teradata.

Course Outline

Introduction to Teradata

  • Background
  • Why use Teradata
  • User Scalability

Relational Concepts

  • Introduction to RDBMS 
  • Warehousing Concepts

Set Up and Installation

  • Installation
  • Tools and Utilities like BTEQ

Teradata Architecture

  • Components
    • Node
    • Parsing Engine
    • Message Parsing Layer – BYNET
    • Access Module Processor
  • Storage Architecture
  • Retrieval Architecture
  • Architectural Overview

Teradata Basic Concepts – SQL

  • Data Type
  • Tables
    • Permanent
    • Volatile
    • Global Temporary
    • Derived
    • Set v/s Multiset Tables
  • Playing with Data – CRUD Operations [DDL and DML]
  • Logical and Conditional Operators
  • SET Operators
  • String Manipulation
  • Date/Time
  • Built in and Aggregate Functions
  • Joins and Subqueries
  • Indexes
    • Primary
    • Secondary

Teradata Advanced Concepts

  • Case
  • Coalesce
  • Macros
  • Stored Procedures
  • Space
    • Temp
    • Spool
    • Permanent
  • Join Strategies
  • Statistics
  • Compression
  • Hashing Algorithm
  • OLAP Functions
  • User Management

Teradata Additional Concepts

  • Utilities
    • FastLoad
    • MultiLoad
    • FastExport
    • BTEQ
  • Data Protection Methodologies
  • Optimization Strategies

Note: The Training will be a mix of theory and hands on exercises, and it would be helpful if the delegates actively particpate in the given exercises.

Leave a Reply

Your email address will not be published. Required fields are marked *