Teradata Training

TERADATA COURSE CONTENT:-

 What is Teradata?

 Teradata V12 &Versions

 Teradata Users Scalability

 Teradata & other RDBMS

 Teradata Warehouse

TERADATA ARCHITECTURE & IT’S 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

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

TERADATA INDEXES:-

 Types Of Indexes In Teradata

 Hash Index

 Join Index

 Primary Index (Unique, Non- Unique)

 Secondary Index (Unique, Non- Unique)

 Keys & Indexes (How & Why These Used)

HOW TO STORAGE & RETRIEVAL OF DATA:-

 Hash Algorithm

 Row Hash

 Hash Map

 Hash Bucket

TERADATA SQL QUARRYMAN:-

 SQL Fundamentals

 Data Types And Literals

 DDL Statements

 DML Statements Teradata Naming Conversing

TERADATA SQL FUNCTIONS & OPERATIONS:-

 String Functions

 Format Functions

 Cast Functions

 Cast Functions

 Group & Aggregation Functions

 Logical Operations

 Arithmetic Operations

 Set Operations

 Join Operations

 Conditional Expressions

TERADATA JOIN STRATEGIES & UNIONS:-

 Hash Join

 Merge Join

 Nested Join

 Product Join

 Inner Join

 Left & Right Outer Join

 Full Outer Join

TERADATA BASIC COMMANDS:-

 Help

 Show

 Explain

 Collect Statistics

TERADATA OBJECTS:-

 Types Of Tables

 Set Tables

 Multi Tables

 Volatile Tables

 Global Temporary Tables

 Derived Tables

 Views

 Stored Procedures

TERADATA MEMORY SPACES:-

 Permanent Spaces

 Temporary Spaces

 Spool Spaces

 Users Spaces & Pwd

TERADATA PERFORMANCE TUNING ON SQL

ASSISTANCE:-

 Explain Usage

 Collecting Statistics

 SQL Tuning

 Various SQL Statements

TERADATA UTILITIES & TOOLS (IMPORT & EXPORT):-

 Teradata Bteq Scripts

 Overview of Bteq

 Overview of MultiLoad

 Overview of FastLoad

 Overview of Tpump

 Advantages & Limitations of MultiLoad, FastLoad and

Tpump