|
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 SqlAssistant(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 |
