Teradata Online Training

OVERVIEW OF TERADATA

• What is Teradata…
• Teradata v12 & next versions
• Teradata History
• Teradata users scalability
• Teradata and other R-DBMS’s
• Teradata is a warehouse
• Teradata in the Enterprise level
• Interview Questations & Answers and Certification support
• Real time Scenarios & Problems – Solutions

TERADATA ARCHITECTURE & IT’S COMPONENTS

• Node Architecture (Shared Architecture)
• SMP Architecture
• MPP Architecture
• Parsing engine(PE) Architecture
• AMP Architecture &usage
• Bynet Benefits and types
• Parallel data extension-(PDE)
• Teradata directory program(TDP)
• Call level interface-(CLI)
• Trusted parallel application-(TPA)
• Virtual processors
• Bynet 0 and Bynet 1
• Parallism Architecture

RECOVERY &PROTECTION OF DATA

• What is fall back &where it used
• Why for fall back
• What is Clique
• AMP Clustering
• & types for simultaneous Access
• Why for locks &how to release
• RAID 1 and RAID 5
• Journals and types
• Virtual Disk Array
• How & where is used journals
• Q and A about data recovery

TERADATA INDEXES

• Types of indexes in Teradata
• Hash index
• Join index
• Primary index(unique, non- unique)
• Secondary index(unique, non- unique)
• Skewness
• Keys & indexes (How & why these used)

HOW TO STORAGE & RETRIEVAL OF DATA

• Hash algorithm
• hash
• Hash map
• Hash bucket
• Receiving VDisc

TERADATA SQL QUARRYMAN

• SQL fundamentals
• Data types and literals
• DDL Statements
• DML Statements
• Teradata naming conversing

TERADATA SQL QUARRYMAN

• SQL fundamentals
• Data types and literals
• DDL Statements
• DML Statements
• Teradata naming conversing

TERADATA SQL FUNCTIONS & OPERATIONS

• String functions
• Format functions
• Cast functions
• Cast functions
• Group and Aggregation functions
• Logical operations
• Arithmetic operations
• set operations
• join operations
• conditional expressions

TERADATA JOIN STRATEGIES & UNIONS

• hash join
• merge join
• nested join
• product join
• inner join
• left & right outer join
• full outer join

TERADATA BASIC COMMANDS

• Help
• Show
• Explain
• Collect statistics

TERADATA OBJECTS

TERADATA MEMORY SPACES

• Permanent spaces
• Temporary spaces
• Spool spaces
• Users spaces & PWD

TERADATA TRANSACTION MODES

• Batch mode
• BTET mode
• ANSI mode
• How Converted into others

TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE

• Usage of PMON
• Explain usage
• Collecting statistics
• SQL tuning
• Various SQL statements
• Real time Issues & resolving

TERADATA UTILITIES & TOOLS (IMPORT & EXPORT)

• Teradata BTeq scripts
• Overview of BTeq
• Looping stages
• Batches scripts
• Import &export scripts with Examples
• Error handling
• Real time scripts
• Teradata FastLoad
• Types of phages & how to find it
• Advantages & its process
• Limitations of fast load
• Real time scripts
• Teradata MultiLoad
• Overview of Multi load
• Types of phages in MultiLoad
• Advantages & its process
• Limitations of MultiLoad
• Uses various types of operations
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata Tpump
• Overview of Tpump
• Limitations of Tpump
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata Fast Export
• How to export the data
• Passing parameters
• IN and OUT Modes
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata SQL Assistant(Quarryman)
• Teradata performance monitor
• Teradata Administrator usage
• Teradata performance tuning on scripts