Check with seller TERAData Training at FuturePointTech Hyderabad

TERADATA
What is Teradata why for it is what for it is
What is Teradata?
Teradatav13 &versions
Teradata History
Teradata users scalability
Teradata &other RDBMS
Teradata warehouse
Teradata in the Enterprise
Interview Q&A and Certification queries
Real time Issues & resolving

Teradata architecture & it’s components
Node Architecture(Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &uses
Bynet Benefits &types
Parallel data extension(PDE)
Teradata directory program(TDP)
Call level interface(CLI)
Trusted parallel application(TPA)
Virtual processors
Bynet 0 &Bynet 1
Parallism Architecture

Recovery & Protection of Data
What is fall back &where it used
Why for fall back
What is Clique
AMP Clustering
Locks & types for simultaneous Access
Why for locks &how to release
RAID 1 &RAID 5
Journals &types
Virtual Disk Array
How & where is used journals
Q & 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
Row 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 Functions & operations
String functions
Format functions
Cast functions
Cast functions
Group & 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
Types of tables
•Set tables
•Multi tables
•Volatile tables
o Global temporary tables
o Derived tables
Views
Macros
Stored procedures
Triggers


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
o Overview of Multi load
•Types of phages in MultiLoad
•Advantages & its process
•Limitations of MultiLoad
•Uses various types of operations
o Work on Multi tables
•Real time scripts
o Sample scripts

Teradata Tpump
•Overview of Tpump
•Limitations of Tpump
•Work on Multi tables
•Real time scripts
o Sample scripts

Teradata Fast Export
•How to export the data
o Passing parameters
o IN/OUT Modes
o Work on Multi tables
•Real time scripts
o Sample scripts

Teradata SQL Assistant(Quarryman)
Teradata performance monitor
Teradata Administrator usage
Teradata performance tuning on scripts

Keyservice by Trainer
FAQS
Covering DBA concepts
Concentration on performance tuning
Real time scenarios
Certification guidance
Resume preparation
Sample resumes
Interview & certification FAQS
How to face the interview
Class notes which is useful for who is trying for job
Project preparation



Drop a mail info@futurepointtech.com we will get in touch with u

Contact seller