Tera Data Course

• 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 Rcovery 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

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