• What is Teradata?
• Teradatav12 &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

2. Teradata Architecture & Its 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

3. 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

4. Teradata Indexes

• Types of indexes in Teradata
• Hash index
• Join index
• Primary index
• Secondary index
• Skewness
• Keys & indexes

5. How To Storage & Retrieval Of Data

• Hash algorithm
• Row hash
• Hash map
• Hash bucket
• Receiving VDisc

6. Teradata Sql Quarryman

• SQL fundamentals
• Data types and literals
• DDL Statements
• DML Statements
• Teradata naming conversin

7. Teradata Sql Functions & Operations

• String functions
• Format functions
• Cast functions
• Group & Aggregation functions
• Logical operations
• Arithmetic operations
• set operations
• join operations
• conditional expressions

8. Teradata Join Strategies & Unions

• Hash join
• Merge join
• Nested join
• Product join
• Inner join
• Left & right outer join
• Full outer join
• Conditions & Exceptions

9. Teradata Basic Commands

• Help
• Show
• Explain
• Collect statistics

10. Teradata Objects

• Types of tables
• Set tables
• Multi tables
• Volatile tables
• Global temporary tables
• Derived tables
• Views
• Macros
• Stored procedures
• Triggers

11. Teradata Memory Spaces

• Permanent spaces
• Temporary spaces
• Spool spacess
• Users spaces & PWD

12. Teradata Transaction Modes

• Batch mode
• BTET mode
• ANSI mode
• How Converted into others

13. Teradata Performance Tuning On Sql Assistance

• Usage of PMON
• Explain usage
• Collecting statistics
• SQL tuning
• Various SQL statements
• Real time Issues & resolving

14. 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

15. Teradata Fastload

• Types of phages & how to find it
• Advantages & its process
• Limitations of fast load
• Real time scripts

16. Teradata Multiload

• Overview of Multi load
• Types of phages in MultiLoad
• Advantages & its process
• Limitations of MultiLoad
• Uses various types of operations
• Work on Multi tables
• Real time scripts
• Sample scripts

17. Teradata Fast Export

• How to export the data
• Passing parameters
• IN/OUT Modes
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata SQL Assistant
• Teradata performance monitor
• Teradata Administrator usage
• Teradata performance tuning on scripts

18. Other features

• 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