Teradata Online Training
Introduction:
• What is Teradata?
• Teradatav12 & versions Other versions
• Overview OF Teradata
• Teradata warehouse
• Teradata in the Enterprise
• Teradata Users & Scalability
• interview Q&A and Certification queries

Teradata Architecture and Components:
• Teradata Architecture
• SMP Architecture
• MPP Architecture
• AMP(Access Module Processing)
• TDP(Teradata Directory Program)
• CLI(Call Level Interface)
• TPA(Trusted Parallel Application)
• Parallelism Architecture
• Benefits and Types

Data Recovery and Security:
• Why for locks &how to release
• Various locks for simultaneous access
• RAID 1&RAID 5
• Disk Arrays
• Fall Back
• Clique
• AMP Clustering
• Types OF Journals
• Recovery Journal
• Trasient Journal
• Permanent Journal
• Before Journal
• After Journal
• How & where is used journals
• Answering various recovery questions

Teradata Indexes:
• Primary Index
• Unique
• Non unique
• Partitioned
• Secondary Index
• Unique
• NonUnique
• Hash, Join, Value Ordered
• Skewness
• Secondary Index Sub table
• Accessing Records via Primary Index
• Accessing records via Secondary Index
• Keys Vs Indexes
• Full Real time scenarios and explaining

Teradata Sql Reference:
• SQL Fundamentals
• Data Types and Literals
• Data Definition Statements(DDL)
• Data Manipulation Statements(DML)
• Explaining with proper examples

Teradata Functions and Operators:
• String Functions
• Format Function
• Cast Functions
• Group & Aggregate Functions
• With & with by clauses
• Practices of this section

Teradata Transactions

Implicit Transaction

Explicit Transaction:
• Performance Tuning and Explain Utility
• Explain Usage
• Collecting Statistics
• Tuning SQL Performance
• Usage of PMON
• Explaining various SQL statements
• Joins and Unions
• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Detailed explanation
• Join Strategies
• Product Join
• Merge Join
• Hash Join
• Nested Join
• Questions of this section

Teradata Basic Commands:
• HELP
• SHOW
• EXPLAIN
• COLLECT STATISTICS

Teradata Objects:
• Tables
• SET table
• Multi Set table
• Volatile tables
• Global Temporary tables
• Derived tables
• Views
• Macros
• Stored Procedures
• Triggers
• Practices and FAQs of this session

Teradata spaces:
• PERM space
• SPOOL space
• TEMPORARY space
• Teradata User and managing
• Practical Examples

Teradata Transaction Modes:
• BTET
• ANSI
• Interactive
• Batch

Teradata Sql Assistant(Queryman):
• Teradata Performance Monitor
• Teradata BTEQ
• Batch Scripts with samples
• Branching and Looping
• Importing data through scripts
• Exporting data through scripts
• Error handling
• Explanation with proper debugging
• Teradata Fast Load
• Various Phases of Fast Load
• Advantages and Process
• Limitations of Fast Load
• Sample Scripts