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
- RAID1 & RAID5
- 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 Comman:
- 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
Real time Issues and resolving it:
- Teradata Multi Load
- Various Phases of Multi Load
- Limitations of Multi Load
- Working with multiple tables
- Applying various operations
- Sample Scripts
Real time Issues and solving it:
- Teradata Parallel Data Pump
- Limitations of TPump
- Overview of TPump
- Sample Scripts
- Teradata Fast Export
- Exporting Data
- Passing Parameters
- OUTMODS
- Sample Scripts
- Utility Vs Parallelism