Logo

Course Contents

TERADATA SYLLABUS

Data Warehousing Concepts

  • About Data Warehouse & warehousing
  • Active Warehouse & passive Warehouse
  • Data warehouse using Evaluation
  • OLTP, DSS,OLTP,&OLCP
  • SDLC(DWD Life Cycle)
  • Schema Types
  • Characteristics' Of Dimension &Fact Tables
  • ETL Process & cleaning 
  • ER & dimentional Model Overview
  • Introduction to TERADATA
  • UInique Features of Teradata
  • Teradata System
  • Node component
  • SMP & MPP
  • BYNET Hardware &SoftWare
  • Communication between Nodes
  • Teradata Maximums

 

  • TERADATA Architecture
  • Architecture Flow
  • Shared Nothing Acrhitecture
  • PE with Explain
  • Visual Data Layout
  • Primary Index
  • Purpose of Primary Index
  • Non unique Primary Index
  • unique Primary Index

 

  • Secondary Index
  • Purpose of the Secondary Index
  • Unique Secondary Index
  • Non Unique Secondary Index
  • Teradata SQl
  • SQL Basics
  • Teradata Punctuation
  • HELP,show,Explain
  • Working With Nulls
  • And ,OR,Not, Between & like
  • Aggregation
  • Subqueries & Co-related Sub Queries
  • Aliasing,Title,cast &format
  • Interrrogating Data

 

  • Types of Tables
  • Set and Multiset Tables
  • Volatile Tables
  • Derived Tables
  • Global Tempory Tables
  • Teradata Spaces
  • Perm Space
  • Spool Space
  • Term Space
  • Performance Tunning with Space

 

  • Joins
  • Join Types
  • Join strategies
  • Join Index
  • Agg join index
  • Set Operators
  • Union/Union all
  • Intersect
  • Except or minus

 

  • Views
  • Purpose Of view
  • Create View Syntax
  • Usage
  • Macros
  • Purpose of Macros
  • Create Macro Syntax

 

  • Data and  Times
  • Teradata Key words
  • Storage of dates on Disk
  • DateForm
  • ADD_Months Command
  • Extract  Command
  • System Calender
  • System Calendar with Date Comparision
  • Intervel Processing with Date And Time
  • Rank Function and Qualify Usage
  • Rank Functions
  • Qualify Usage
  • Rank with OLAP functions
  • OLAP Function
  • CSUM
  • MSUM
  • MAVG

 

  • Teradata Utilites
  • MLOAD
  • FLOAD
  • FAST EXPORT
  • BTEQ
  • TERADATA OLELOAD
  • TERADAT PARLLAL TRANSPOSER
  • TPUMP
  • Locks
  • Exclusive
  • Write
  • Read
  • Access

 

  • Protection Features
  • Fallback
  • Raid
  • Clique
  • Stores Procedure
  • Performance Tunning

    Note: Duration of the course is 30h of one hour each.