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.