Teradata Online Training | Teradata Training | Teradata Course online

Teradata development Online Training 


1.What is Teradata?
2.Teradatav12 &versions
3.Teradata History
4.Teradata users scalability
5.Teradata &other RDBMS
6.Teradata warehouse
7.Teradata in the Enterprise

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 Queryman
• SQL fundamentals
• Data types and literals
• DDL Statements
• DML Statements
• Teradata naming conversing
• 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
• Global temporary tables
• Derived tables
• Views
• Macros
• Stored procedures
• Teradata memory spaces
• Permanent spaces
• Temporary spaces
• Spool spaces
• Users spaces & PWD

Teradata performance tuning on SQL Assistance

• 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