TERA DATA

TERA DATA

Overview:
Is one of the popular Relational Database Management Systems. TERADATA is a fully scalable relational database management system TERADATA is database which is planned to manage logical queries. TERADATA is open system TERADATA suitable for market specification TERADATA useful for manage large data warehousing operations.

Training Objectives of TERADATA:
Teradata provides market leading data and analytics platform Teradata provides Analytics platform and connectors to integrate seamlessly with Hadoop. Understand Teradata's competitive advantage over other RDBMSs. Understand Teradata Architecture and Indexing mechanism. Apply various performance turning techniques to optimize the queries.

Target Students / Prerequisites:
Basic Knowledge of SQL and Student should have technical background and understanding DBMS concepts

Course Contents:

Teradata Architecture and Components
PDE(Parallel Data Extension)
Process (virtual processors)
PE (Parsing Engine)
AMP (Access Module processing)
Board less By net
TDP (Teradata Directory Program)
CLI (Call Level Interface)
TPA (Trusted parallel Application)
Going in depth by explaining the process of SQL statement execution

Various Architecture
Node Architecture (shared nothing)
SMP Architecture
MPP Architecture
Parallelism Architecture
Benefit & types

Data Recovery and Protection
Object Locks-Various locks for simultaneous access
RAIDI
RAIDI5
Disk Arrays
Fall Back
Clique
AMP Clustering
Journals

Teradata Storage and Retrieval Architecture
Request processing
Syntaxes
Resolver
Security Module
Optimizer
E .Step Generator
GNC Apply
Dispatcher

Primary index
Hash algorithm
Row hash
DSW
Hash Map
Hash Bucket
Reaching V disk

Teradata Indexes
Primary Index
Unique
Non unique
Partitioned
Secondary Index
Unique
Non unique
Hash, Join, Value Ordered
Skewness
Secondary Index Sub table
Accessing Records via primary index
Accessing records via Secondary index
Keys vs. indexes

Teradata SQl Reference
Fundamentals
Data Types and Literals
Data Definition Statements
Data manipulation statements

Teradata Functions and Operators
String functions
Format functions
Cast functions
Group & Aggregate functions
With & with by clauses

Teradata Transactions
Implicit Transaction
Explicit Transaction

Performance Tuning and Explain Utility
Explain Usage
Collection Statistics
Tuning SQL Performance
Usage of PMON
Joints & Unions
Inner Join
Left Outer Join
Right Outer join
Full Outer Join
Teradata Basic Commands
HELP
SHOW
EXPLAIN
COLLECT STATISTICS
Teradata objects
Tables
     o SET table
     o Multi Set table
     o Volatile tables
     o Global Temporary tables
     o Derived tables
Views
Macros
Stored procedures
Triggers

Teradata spaces
PERM space
SPOOL space
TEMPORARY space
Teradata user and managing.
Teradata Transaction Modes
BTET
ANSI
Interactive
Batch

Load and Unload Utilities & Tools
Teradata SQL Assistant (Query man)
Teradata Performance Monitor
Teradata BTEQ
Batch Scripts with samples
Branching and Looping
Importing data through scripts
Exporting data through scripts
Session Control Command Set
Error handling.
Teradata Fast load
Various Phases of Fast Load
Advantages and Process
Limitations of Fast Load
Sample scripts
Teradata Multi Load
Various Phases of Multi load
Limitations of Multi Load
Working with multiple tables
Applying various operations
Sample Scripts

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.