Teradata Online Training

Teradata Online Training Course Content

Teradata Introduction

  • Teradata Introduction
  • Teradata Advantages
  • RDBMS vs Data warehouse
  • Teradata Tools & Utilities
  • Teradata Installation

Teradata Architecture

  • Teradata Components
  • Storage & Retrieval architecture
  • System architecture
  • How parallelism works

Basic SQL

  • Data types
  • DDL statements(CREATE,DROP,ALTER)
  • DML statements (SELECT, INSERT,UPDATE,DELETE)
  • DCL statements (Grant, Revoke)
  • SET Operators
  • Logical & Conditional Operators
  • String Manipulation
  • Date & Time Manipulation
  • Joins
  • Built-in functions
  • Aggregates

Indexes

  • Primary Index
  • Secondary Index
  • Partition Primary Index

Teradata Objects

  • Tables and its types
  • Space concepts
  • Views
  • Macros
  • Stored Procedures
  • Join Index

Advanced SQL

  • Sub queries
  • Coalesce
  • OLAP Functions
  • Compression
  • Collect Statistics
  • DBC tables
  • Explain plan
Utilities
  • FastLoad
  • MultiLoad
  • BTEQ
  • FastExport
  • TPT
Data Protection
  • Fallback
  • Clusters
  • Clique
  • Permanent Journals
  • Hot Standby Nodes
  • RAID
Performance Optimization
  • Join Strategies
  • Confidence levels
  • Statistics collection process
  • Performance tuning techniques
Optional
  • Real time projects
  • Interview questions

for Teradata Online Training Course Demo Register Now

Register Now





Training Type

Teradata Job Trends