Call Us at: +1616-469-0394 | Email: info@hexissoft.com

Follow Us on: facebook_icon twitter-icon linkdein_icon

COURSES

QUICK ENQUIRY











aboutus_banner

Teradata Online training

Teradata
Introduction

  • What is Teradata?
  • Teradatav12 & versions Other versions
  • Overview OF Teradata
  • Teradata warehouse
  • Teradata in the Enterprise
  • Teradata Users & Scalability
  • interview Q&A and Certification queries

Teradata Architecture and Components

  • SMP Architecture
  • MPP Architecture
  • Discussion on AMPS and NODES
  • TPA(Trusted Parallel Application)
  • Parallelism Architecture
  • CLI(Call Level Interface)
  • Benefits and Types

Teradata Indexes

  • Primary Index
  • Unique
  • Non unique
  • Partitioned
  • Secondary Index
  • Unique
  • NonUnique
  • Hash, Join, Value Ordered
  • Skewness
  • Secondary Index Sub table
  • Accessing Records via Primary Index
  • Accessing records via Secondary Index
  • Keys Vs Indexes
  • Full Real time scenarios and explaining

Teradata Functions and Operators

  • String Functions
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & with by clauses
  • Practices of this section

Teradata Sql Reference

  • SQL Fundamentals
  • Data Types and Literals
  • Data Definition Statements(DDL)
  • Data Manipulation Statements(DML)

Explaining with proper examples

Back to Top…